WorkbookBase.Connections 属性

定义

命名空间:

Microsoft.Office.Tools.Excel

程序集:

Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

获取工作簿和数据源之间的连接的集合。

public:
 property Microsoft::Office::Interop::Excel::Connections ^ Connections { Microsoft::Office::Interop::Excel::Connections ^ get(); };

public Microsoft.Office.Interop.Excel.Connections Connections { get; }

member this.Connections : Microsoft.Office.Interop.Excel.Connections

Public ReadOnly Property Connections As Connections

属性值

Connections

Microsoft.Office.Interop.Excel。Connections包含工作簿与数据源之间的连接的集合。

示例

下面的代码示例将新的数据连接添加到指定的 CSV 文件。 接下来，该示例循环访问工作簿中存在的所有连接，并显示每个连接的名称、类型和说明。 此示例要求驱动器 C 根目录中有一个名为 SalesData.csv 的 CSV 文件。CSV 文件应包含逗号分隔的数据。 运行此示例时，Excel 将启动 文本导入向导;按照此向导中的步骤创建与 CSV 文件的数据连接。

此示例适用于文档级自定义项。

private void WorkbookConnections()
{
    Excel.WorkbookConnection myConnection =
        this.Connections.AddFromFile(@"C:\SalesData.csv");
    myConnection.Description = "Data stored in a CSV file.";

    foreach (Excel.WorkbookConnection connection in this.Connections)
    {
        MessageBox.Show(
            "Connection Name: " + connection.Name 
            + "\r\nConnection Type: " + connection.Type.ToString()
            + "\r\nDescription: " + connection.Description);
    }
}

Private Sub WorkbookConnections()
    Dim myConnection As Excel.WorkbookConnection = _
        Me.Connections.AddFromFile("c:\SalesData.csv")
    myConnection.Description = "Data stored in a CSV file."

    For Each connection As Excel.WorkbookConnection In Me.Connections
        MessageBox.Show(connection.Name + " " + connection.Type.ToString() _
            + " " + connection.Description)
    Next
End Sub