Aspose.Cells.ExternalConnections Namespace

Contains all classes of external connections.
Public classConnectionParameter
Specifies properties about any parameters used with external data connections Parameters are valid for ODBC and web queries.
Public classConnectionParameterCollection
Specifies the ConnectionParameter collection
Public classDBConnection
Specifies all properties associated with an ODBC or OLE DB external data connection.
Public classExternalConnection
Specifies an external data connection
Public classCode exampleExternalConnectionCollection
Specifies the ExternalConnection collection
Public classWebQueryConnection
Specifies the properties for a web query source. A web query will retrieve data from HTML tables, and can also supply HTTP "Get" parameters to be processed by the web server in generating the HTML by including the parameters and parameter elements.
Public enumerationConnectionDataSourceType
Specifies external database source type
Public enumerationConnectionParameterType
Specifies the parameter type of external connection
Public enumerationCredentialsMethodType
Specifies Credentials method used for server access.
Public enumerationHtmlFormatHandlingType
Specifies how to handle formatting from the HTML source
Public enumerationOLEDBCommandType
Specifies the OLE DB command type.
Public enumerationReConnectionMethodType
Specifies what the spreadsheet application should do when a connection fails.
Public enumerationSqlDataType
Specifies SQL data type of the parameter. Only valid for ODBC sources.