Connections Interface

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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: GuidAttribute InterfaceTypeAttribute

Implements: IEnumerable

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

Sdílet prostřednictvím