Connection
This section provides a complete list of the Connection properties you can configure in the connection string for this provider.
| Property | Description |
| ConnectionType | Specifies the file storage service, server, or file access protocol through which your Microsoft Excel files are stored and retreived. |
| URI | A Uniform Resource Identifier (URI) to a resource location containing Excel workbook file(s). |
| DefineTables | A list of cell ranges within spreadsheets to model as tables. |
| Header | Specifies whether the first row (or column, when Orientation=Horizontal) is used as a source of column names. |
| Orientation | Indicates whether the data in Excel is laid out horizontally or vertically. |
| ExcelFile | The location of an Excel file. |
| BufferChanges | Specifies whether to wait until the connection is closed to apply changes made to workbook data. |
| Region | The hosting region for your S3-like Web Services. |
| OracleNamespace | The Oracle Cloud Object Storage namespace to use. |
| StorageBaseURL | Specifies the URL of a cloud storage service provider. |
| UseVirtualHosting | If 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. |
| TestConnectionBehavior | Specifies the behavior of the test connection. |
| UseLakeFormation | When this property is set to true, AWSLakeFormation service will be used to retrieve temporary credentials, which enforce access policies against the user based on the configured IAM role. The service can be used when authenticating through OKTA, ADFS, AzureAD, PingFederate, while providing a SAML assertion. |