Connection
This section provides a complete list of the Connection properties you can configure in the connection settings for this provider.
| Property | Description |
| DefineTables | Define the tables within a spreadsheet. |
| File | The name of the Excel file to which to connect. |
| Folder | The folder containing the workbook specified by the File property. |
| Header | Indicates whether the first row should be used as a column header when using the REST API. |
| Library | The Document Library to which to connect. |
| IgnoreCalcError | Indicates whether to ignore errors that occurred during the calculation. |
| MaxRows | Limits 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. |
| TypeDetectionScheme | Determines how to determine the data type of columns. |
| UseRESTAPI | Whether or not the REST API is used for retrieving data. |