Class ExternalConnectionCollection

Namespace: Aspose.Cells.ExternalConnections
Assembly: Aspose.Cells.dll (25.2.0)

Specifies the Aspose.Cells.ExternalConnections.ExternalConnection collection

public class ExternalConnectionCollection : CollectionBase<externalconnection>, IList<externalconnection>, ICollection<externalconnection>, IEnumerable<externalconnection>, ICollection, IEnumerable

Inheritance

object ← CollectionBase<externalconnection> ← ExternalConnectionCollection

Implements

IList<externalconnection>, ICollection<externalconnection>, IEnumerable<externalconnection>, ICollection, IEnumerable

Inherited Members

CollectionBase<externalconnection>.BinarySearch(ExternalConnection), CollectionBase<externalconnection>.BinarySearch(ExternalConnection, IComparer<externalconnection>), CollectionBase<externalconnection>.BinarySearch(int, int, ExternalConnection, IComparer<externalconnection>), CollectionBase<externalconnection>.Contains(ExternalConnection), CollectionBase<externalconnection>.CopyTo(ExternalConnection[]), CollectionBase<externalconnection>.CopyTo(ExternalConnection[], int), CollectionBase<externalconnection>.CopyTo(int, ExternalConnection[], int, int), CollectionBase<externalconnection>.Exists(Predicate<externalconnection>), CollectionBase<externalconnection>.Find(Predicate<externalconnection>), CollectionBase<externalconnection>.FindAll(Predicate<externalconnection>), CollectionBase<externalconnection>.FindIndex(Predicate<externalconnection>), CollectionBase<externalconnection>.FindIndex(int, Predicate<externalconnection>), CollectionBase<externalconnection>.FindIndex(int, int, Predicate<externalconnection>), CollectionBase<externalconnection>.FindLast(Predicate<externalconnection>), CollectionBase<externalconnection>.FindLastIndex(Predicate<externalconnection>), CollectionBase<externalconnection>.FindLastIndex(int, Predicate<externalconnection>), CollectionBase<externalconnection>.FindLastIndex(int, int, Predicate<externalconnection>), CollectionBase<externalconnection>.IndexOf(ExternalConnection), CollectionBase<externalconnection>.IndexOf(ExternalConnection, int), CollectionBase<externalconnection>.IndexOf(ExternalConnection, int, int), CollectionBase<externalconnection>.LastIndexOf(ExternalConnection), CollectionBase<externalconnection>.LastIndexOf(ExternalConnection, int), CollectionBase<externalconnection>.LastIndexOf(ExternalConnection, int, int), CollectionBase<externalconnection>.GetEnumerator(), CollectionBase<externalconnection>.Clear(), CollectionBase<externalconnection>.RemoveAt(int), CollectionBase<externalconnection>.OnClearComplete(), CollectionBase<externalconnection>.OnClear(), CollectionBase<externalconnection>.Capacity, CollectionBase<externalconnection>.Count, CollectionBase<externalconnection>.InnerList, CollectionBase<externalconnection>.this[int], object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()

Examples

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);
}

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

Properties

this[int]

Gets the Aspose.Cells.ExternalConnections.ExternalConnection element at the specified index.

public ExternalConnection this[int index] { get; set; }

Property Value

ExternalConnection

this[string]

Gets the Aspose.Cells.ExternalConnections.ExternalConnection element with the specified name.

public ExternalConnection this[string connectionName] { get; }

Property Value

ExternalConnection

Methods

GetExternalConnectionById(int)

Gets the Aspose.Cells.ExternalConnections.ExternalConnection element with the specified id.

public ExternalConnection GetExternalConnectionById(int connId)

Parameters

connId int

external connection id

Returns

ExternalConnection

The element with the specified id. </externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection></externalconnection>