ADO.NET Provider for Microsoft SharePoint 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
DefineTablesDefine the tables within a spreadsheet.
FileThe name of the Excel file to which to connect.
FolderThe folder containing the workbook specified by the File property.
HeaderIndicates whether the first row should be used as a column header when using the REST API.
LibraryThe Document Library to which to connect.
IgnoreCalcErrorIndicates whether to ignore errors that occurred during the calculation.
MaxRowsLimits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
TypeDetectionSchemeDetermines how to determine the data type of columns.
UseRESTAPIWhether or not the REST API is used for retrieving data.

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