Namespace DRIT.Spreadsheet.Data
Classes
ConnectionParameter
Represents a parameter for a database connection.
DataConnection
Represents a base class for data connections.
DatabaseConnection
Represents a database connection for data operations.
ExternalConnectionCollection
Represents a collection of external data connections in a workbook.
OlapConnection
Represents an OLAP (Online Analytical Processing) connection.
QueryTable
Represents a query table that connects to external data.
QueryTableCollection
Represents a collection of query tables.
QueryTableDeletedField
Represents a field that was deleted from a query table.
QueryTableField
Represents a field in a query table.
QueryTableFieldCollection
Represents a collection of query table fields.
QueryTableRefresh
Represents refresh settings for a query table.
TextConnection
Represents a text file connection for importing data.
TextConnectionField
Represents a field in a text connection.
WebQueryConnection
Represents a web query connection for importing data from web sources.
Enums
CredentialsMethod
Specifies the method for handling credentials in data connections.
DataConnectionType
Specifies the type of a data connection.
ExternalConnectionType
Specifies the date format type for external connections.
GrowShrinkType
Specifies how rows/columns should grow or shrink when data is added or removed.
HtmlFormat
Specifies the HTML format options for export.
ParameterType
Specifies the type of a query parameter.
Qualifier
Specifies the text qualifier type for CSV/text imports.
TextFileType
Specifies the file type for text file imports.