A connection is a set of information needed to obtain data from an external data source other than an 1st_Excel12 workbook.
public interface class WorkbookConnection
[System.Runtime.InteropServices.Guid("00024485-0000-0000-C000-000000000046")] [System.Runtime.InteropServices.InterfaceType(2)] public interface WorkbookConnection
Public Interface WorkbookConnection
Connections can be stored within an Excel workbook. When the workbook is opened, Excel creates an in-memory copy of the connection which is refered to as the connection object. A connection object contains information such as the name of the server and the name of the object to be opened on that server. Optionally, the connection object may also include authentication credentials and/or a command that is to be passed to the server and executed (example: a SELECT statement to be executed by SQL Server.)
Note: The exact form of the connection depends on the mechanism that is being used to retrieve data – ODBC connections, OLEDB connections, and Web Queries will contain different information.
A connection may also be stored in a separate connection file. Most connections in an Excel workbook include a pointer to an external connection file. Connection files have extensions that clearly label them as connection files (*.ODC, *.IQY, etc.) and may be located on the user's local machine or in other well known or trusted locations such as WSS (Data Connection Library), or other corporate servers. Connection files enable multiple users within the same organization to re-use connections. Network administrators are able to change the way the entire organization connects to a back-end data source by changing a single connection file. A connection file is not always required when connecting to an external data source.
Connection names are strings that uniquely identify connections within the workbook in which they are used. There are other properties of a connection that are not unique. Whenever a formula in Excel takes an argument that is a connection, it will be sufficient to refer to the name of that connection, either directly (as a string) or indirectly (by referring to a cell that contains the connection name as a string.)
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.
Returns a 32-bit integer that indicates the application in which this object was created. Read-only Integer.
Returns a DataFeedConnection object that contains the data and functionality needed to connect to data feeds. Read-only
Returns or sets a brief description for a WorkbookConnection object. Read/write String.
Specifies whether or not the WorkbookConnection object has been added to the model. Boolean (bool in C#) Read-only.
Returns an object that contains information for the new Model Connection Type introduced in Excel 2013 to interact with the integrated Data Model. Read-only
Returns a ModelTables object associated with the particular connection. Read-only
Returns or sets the name of the workbook connection object. Read/write String.
Returns the parent object for the specified object. Read-only.
Determines if the connection should be refreshed when refresh all is executed. Boolean (bool in C#). Read/Write.
Returns a TextConnection object that contains the information on a query to a text file. Read-only.
Returns the workbook connection type. Read-only XlConnectionType.
Returns an object that contains information for a connection from the PowerPivot Model to data within the workbook such as a range, named range, or table. Read-only.
Deletes a workbook connection.
Refreshes a workbook connection.