編輯

共用方式為


Connections Interface

Definition

A collection of Connection objects for the specified workbook.

public interface class Connections : System::Collections::IEnumerable
[System.Runtime.InteropServices.Guid("00024486-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface Connections : System.Collections.IEnumerable
Public Interface Connections
Implements IEnumerable
Attributes
Implements

Examples

The following example shows how to add a connection to a workbook from an existing file.

Properties

_Default[Object]
Application

When used without an object qualifier, this property returns an _Application object that represents the Microsoft Office Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. Read-only.

Count

Returns the number of objects in the collection. Read-only Integer.

Creator

Returns a constant in the XlCreator enumeration that indicates the application in which this object was created. Read-only.

Parent

Returns the parent object for the specified object. Read-only.

Methods

Add(String, String, Object, Object, Object)

This object, member, or enumeration is deprecated and is not intended to be used in your code.

Add2(String, String, Object, Object, Object, Object, Object)

Adds a new connection to the workbook.

AddFromFile(String)

Adds a connection from the specified file.

AddFromFile2(String, Object, Object)

Adds a connection from the specified file.

GetEnumerator()
Item(Object)

This method creates a connection item.

Applies to