JDBC Driver for Microsoft Excel Online

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
DefineTablesAssign table names to ranges.
WorkbookThe name or Id of the workbook.
DriveThe Id of the drive.
IncludeSharePointSitesWhether to retrieve drives for all SharePoint sites when querying Drives view. If 'true' the provider will retrieve all Site IDs recursively and for each of them issue a separate call to get their drives. Therefore, be aware that setting this property to 'true' may decrease performance for the Drives view. Note that the SharePointAccessToken or OAuthJWTCert connection property must be specified to query the SharePointSites view and other views if IncludeSharePointSites is set to 'true' when using the CLIENT OAuthGrantType or the AzureServicePrincipal AuthScheme.

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