JDBC Driver for Microsoft Excel

Build 22.0.8462

Connection

This section provides a complete list of the Connection properties you can configure in the connection string for this provider.


PropertyDescription
ConnectionTypeThe type of connection to use.
URIThe Uniform Resource Identifier (URI) for the Excel resource location.
DefineTablesMap Excel ranges to table names.
HeaderIndicates whether the first row should be used as a column header.
OrientationIndicates whether the data in Excel is laid out horizontally or vertically.
ExcelFileThe location of an Excel file.
BufferChangesIndicates whether to hold changes to the data in memory until the connection is closed.
RegionThe hosting region for your S3-like Web Services.
ProjectIdThe Id of the project where your Google Cloud Storage instance resides.
OracleNamespaceThe Oracle Cloud Object Storage namespace to use.
StorageBaseURLThe URL of a cloud storage service provider.
UseVirtualHostingIf true (default), buckets will be referenced in the request using the hosted-style request: http://yourbucket.s3.amazonaws.com/yourobject. If set to false, the bean will use the path-style request: http://s3.amazonaws.com/yourbucket/yourobject. Note that this property will be set to false, in case of an S3 based custom service when the CustomURL is specified.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462