ExternalConnectionCollection

ExternalConnectionCollection class

Specifies the ExternalConnection collection

public class ExternalConnectionCollection : CollectionBase<ExternalConnection>

Properties

Name Description
Capacity { get; set; }
Count { get; }
Item { get; set; } Gets the ExternalConnection element at the specified index. (2 indexers)
Item { get; } Gets the ExternalConnection element with the specified name.

Methods

Name Description
BinarySearch(ExternalConnection)
BinarySearch(ExternalConnection, IComparer<ExternalConnection>)
BinarySearch(int, int, ExternalConnection, IComparer<ExternalConnection>)
Clear()
Contains(ExternalConnection)
CopyTo(ExternalConnection[])
CopyTo(ExternalConnection[], int)
CopyTo(int, ExternalConnection[], int, int)
Exists(Predicate<ExternalConnection>)
Find(Predicate<ExternalConnection>)
FindAll(Predicate<ExternalConnection>)
FindIndex(Predicate<ExternalConnection>)
FindIndex(int, Predicate<ExternalConnection>)
FindIndex(int, int, Predicate<ExternalConnection>)
FindLast(Predicate<ExternalConnection>)
FindLastIndex(Predicate<ExternalConnection>)
FindLastIndex(int, Predicate<ExternalConnection>)
FindLastIndex(int, int, Predicate<ExternalConnection>)
GetEnumerator()
GetExternalConnectionById(int) Gets the ExternalConnection element with the specified id.
IndexOf(ExternalConnection)
IndexOf(ExternalConnection, int)
IndexOf(ExternalConnection, int, int)
LastIndexOf(ExternalConnection)
LastIndexOf(ExternalConnection, int)
LastIndexOf(ExternalConnection, int, int)
RemoveAt(int)

Examples

[C#]
Workbook wb = new Workbook("connection.xlsx");
ExternalConnectionCollection dataConns = wb.DataConnections;
ExternalConnection dataConn = null;
for (int i = 0; i < dataConns.Count; i++)
{
    dataConn = dataConns[i];
    //get external connection id
    Console.WriteLine(dataConn.ConnectionId);
}

[Visual Basic]
Dim wb As Workbook = New Workbook("connection.xlsx")
Dim dataConns As ExternalConnectionCollection = wb.DataConnections
Dim dataConn As ExternalConnection
Dim count As Integer = dataConns.Count - 1
Dim i As Integer
For i = 0 To count Step 1
    dataConn = dataConns(i)
    'get external connection id
    Console.WriteLine(dataConn.ConnectionId)
Next

See Also