Connection
このセクションでは、本プロバイダーの接続文字列で設定可能なConnection プロパティの全リストを提供します。
| プロパティ | 説明 |
| DefineTables | Specifies custom table definitions by mapping table names to sheet ranges in the spreadsheet. Use name-value pairs in the form TableName=SheetName!Range. |
| File | Specifies the name of the Excel file to connect to, including the .xlsx extension. |
| Folder | Specifies the folder path within the document library where the file specified in the File property is located. |
| Header | Specifies whether the first row of the sheet contains column names when using the REST API. |
| Library | Specifies the name of the document library that contains the Excel file you want to connect to. |
| IgnoreCalcError | Specifies whether the provider should ignore formula calculation errors in Excel worksheets. |
| MaxRows | Specifies the maximum number of rows the provider returns when a query does not include aggregation or grouping. |
| TypeDetectionScheme | Specifies how the provider determines the data types of columns in a worksheet. |
| UseRESTAPI | Specifies whether the provider uses the SharePoint REST API instead of the OData API to retrieve data. |