Namespace OfficeOpenXml.Data.Connection

Classes

ExcelConnection

Represents a connection to an external data source in a workbook.

ExcelConnectionCollection

A collection of external connections in a workbook.

ExcelConnectionDataModel

Data model specific properties for the connection.

ExcelConnectionOlapProperties

Olap specific properties for the connection.

ExcelConnectionParameter

Represents a parameter for an Excel connection.

ExcelConnectionParameters

A collection of connection parameters.

ExcelConnectionTextField

Represents a text field in a text connection.

ExcelDataModelDataFeedProperties

Data model data feed specific properties.

ExcelDataModelOleDbProperties

OleDb properties for Data Model connections.

ExcelDatabaseProperties

Database specific properties.

ExcelHtmlTableReference

A reference to an HTML table in a web query connection.

ExcelPowerQueryMetaDataEntry

An entity in the meta data entity collection for Power Query.

ExcelPowerQueryMetadataItem

A power query metadata item used for describing the M-Formula.

ExcelPowerQueryPermissions

Power query permission settings

ExcelPowerQuerySettings

Settings for power query connections. These settings are read from the CustomXml in the package with the key DataMashup

ExcelTextProperties

Properties for text file connections.

ExcelWebProperties

Connection properties for web queries.

Enums

eCommandType

The type of command used by the ExcelConnection.

eConnectionDataSourceType

The type of data source for a connection.

eConnectionParameterType

Connection parameter types.

eConnectionTextFieldType

Specifies the external connection data type and its date format order, used when importing or interpreting external data fields.

eConnectionTextFileType

A file type for text data sources.

eConnectionTextQualifier

A text qualifier used for text data sources.

eCredential

Which credentials to use.

eHtmlFormatingHandling

How to handle formatting from the HTML source when bringing web query data into the worksheet.

ePowerQueryPermissionWorkbookGroupType

Permision level for the

eReconnectionMethod

How a connection object should reconnect.