ExternalConnectionCollection

ExternalConnectionCollection class

Especifica elExternalConnection colección

public class ExternalConnectionCollection : CollectionBase<ExternalConnection>

Propiedades

NombreDescripción
Capacity { get; set; }
Count { get; }
Item { get; set; }Obtiene elExternalConnection elemento en el índice especificado. (2 indexers)
Item { get; }Obtiene elExternalConnection elemento con el nombre especificado.

Métodos

NombreDescripción
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)Obtiene elExternalConnection elemento con el id. especificado
IndexOf(ExternalConnection)
IndexOf(ExternalConnection, int)
IndexOf(ExternalConnection, int, int)
LastIndexOf(ExternalConnection)
LastIndexOf(ExternalConnection, int)
LastIndexOf(ExternalConnection, int, int)
RemoveAt(int)

Ejemplos

[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];
    //obtener id de conexion externa
    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)
    'obtener identificación de conexión externa
    Console.WriteLine(dataConn.ConnectionId)
Next

Ver también