DataFeedConnection DataFeedConnection DataFeedConnection Interface

Definition

Contains the data and functionality needed to connect to data feeds. The same object is used for all Data Feed types.

public interface class DataFeedConnection
[System.Runtime.InteropServices.Guid("000244D4-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface DataFeedConnection
Public Interface DataFeedConnection
Attributes

Properties

AlwaysUseConnectionFile AlwaysUseConnectionFile AlwaysUseConnectionFile

True if the connection file is always used to establish connection to the data source. Boolean (bool in C#). Read/Write

Application Application Application

Returns an Application object that represents the Excel application. Read-only.

CommandText CommandText CommandText

Returns or sets the command string for the specified data source. Object (object in C#) Read/Write

CommandType CommandType CommandType

Returns or sets the command string for the specified data source. Object (object in C#) Read/Write

Connection Connection Connection

Returns or sets a string that contains Service Contract settings that enable Excel to connect to a Data Feed data source. Object (object in C#) Read/Write

Creator Creator Creator

Returns a 32-bit integer that indicates the application in which the specified object was created. Integer (int in C#) Read-only

EnableRefresh EnableRefresh EnableRefresh

True if the connection can be refreshed by the user. The default value is True. Boolean (bool in C#) Read/Write

Parent Parent Parent

Returns an Object (object in C#) that represents the parent object of the specified DataFeedConnection object. Read-only.

RefreshDate RefreshDate RefreshDate

Returns the date on which the OLE DB connection was last refreshed. DateTime. Read-only

Refreshing Refreshing Refreshing

True if an OLE DB query is in progress for the specified data source connection. Boolean (bool in C#) Read/Write

RefreshOnFileOpen RefreshOnFileOpen RefreshOnFileOpen

True if the connection is automatically updated each time the workbook is opened. The default value is False.

RefreshPeriod RefreshPeriod RefreshPeriod

Returns or sets the number of minutes between refreshes. Integer (int in C#) Read/Write

SavePassword SavePassword SavePassword

True if password information in a data feed connection string is saved in the connection string. False if the password is removed.

ServerCredentialsMethod ServerCredentialsMethod ServerCredentialsMethod

Returns or sets the type of credentials that should be used for server authentication. XlCredentialsMethod Read/Write

SourceConnectionFile SourceConnectionFile SourceConnectionFile

Returns or sets a String (string in C#) indicating the Office Data Connection file or similar file that was used to create the connection. Read/Write

SourceDataFile SourceDataFile SourceDataFile

A path to the original file used to create the connection. In the case of an OData connection, this is the location of the *.atom or *.atomsvc file used to create the connection. String (string in C#) Read/Write

Methods

CancelRefresh() CancelRefresh() CancelRefresh()

Cancels a refresh operation on a data feed connection.

Refresh() Refresh() Refresh()

Refreshes the data feed connection.

SaveAsODC(String, Object, Object) SaveAsODC(String, Object, Object) SaveAsODC(String, Object, Object)

Saves the data feed connection as an Office Data Connection file.

Applies to