Namespace OfficeOpenXml.Data.Connection¶
Classes¶
Represents a connection to an external data source in a workbook.
A collection of external connections in a workbook.
Data model specific properties for the connection.
Olap specific properties for the connection.
Represents a parameter for an Excel connection.
A collection of connection parameters.
Represents a text field in a text connection.
ExcelDataModelDataFeedProperties
Data model data feed specific properties.
OleDb properties for Data Model connections.
Database specific properties.
A reference to an HTML table in a web query connection.
An entity in the meta data entity collection for Power Query.
A power query metadata item used for describing the M-Formula.
Power query permission settings
Settings for power query connections. These settings are read from the CustomXml in the package with the key DataMashup
Properties for text file connections.
Connection properties for web queries.
Enums¶
The type of command used by the ExcelConnection.
The type of data source for a connection.
Connection parameter types.
Specifies the external connection data type and its date format order, used when importing or interpreting external data fields.
A file type for text data sources.
A text qualifier used for text data sources.
Which credentials to use.
How to handle formatting from the HTML source when bringing web query data into the worksheet.
ePowerQueryPermissionWorkbookGroupType
Permision level for the
How a connection object should reconnect.