ExternalConnectionCollection

ExternalConnectionCollection class

指定ExternalConnection集合

public class ExternalConnectionCollection : CollectionBase<ExternalConnection>

特性

姓名描述
Capacity { get; set; }
Count { get; }
Item { get; set; }获取ExternalConnection指定索引处的元素。 (2 indexers)
Item { get; }获取ExternalConnection具有指定名称的元素。

方法

姓名描述
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)获取ExternalConnection具有指定 id. 的元素
IndexOf(ExternalConnection)
IndexOf(ExternalConnection, int)
IndexOf(ExternalConnection, int, int)
LastIndexOf(ExternalConnection)
LastIndexOf(ExternalConnection, int)
LastIndexOf(ExternalConnection, int, int)
RemoveAt(int)

例子

[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];
    //获取外部连接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)
    '获取外部连接ID
    Console.WriteLine(dataConn.ConnectionId)
Next

也可以看看

ExternalConnection HtmlFormatHandlingType