Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.
| Property | Description |
| TypeDetectionScheme | Determines the method for identifying the data types of columns. |
| AllowFormula | Whether or not to treat values starting with an equals (=) sign as formulas during inserts and updates. |
| IncludeFileExtensions | Specifies whether file extensions should be included in table names. |
| MaxRows | Specifies the maximum number of rows returned for queries that do not include either aggregation or GROUP BY. |
| NullValueMode | Indicates whether to read empty cells as null or as empty. |
| Other | Specifies additional hidden properties for specific use cases., to be used only when our Support team advises it, to address specific issues. See Remarks for details. |
| Pagesize | The maximum number of results to return per page from Microsoft Excel Online when UsePagination is True. |
| PseudoColumns | Specifies the pseudocolumns to expose as table columns, expressed as a string in the format 'TableName=ColumnName;TableName=ColumnName'. |
| Readonly | Toggles read-only access to Microsoft Excel Online from the provider. |
| RowScanDepth | The maximum number of rows to scan to look for the columns available in a table. |
| RTK | Specifies the runtime key for licensing the provider. If unset or invalid, the provider defaults to the standard licensing method. This property is only required in environments where the standard licensing method is unsupported or requires a runtime key. |
| SeparatorCharacter | Specifies the character used to separate the workbook name and worksheet name in the generated table name. |
| SharepointURL | The base URL of your Sharepoint Server. |
| ShowEmptyRows | Indicates whether the rows that contain no data (empty rows) should be pushed to the output. |
| ShowSharedDocuments | Whether or not to show shared documents. |
| Timeout | Specifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error. |
| UsePagination | Whether to use client-side paging. |
| UserDefinedViews | Specifies a filepath to a JSON configuration file that defines custom views. The provider automatically detects and uses the views specified in this file. |
| UseSearchAPI | Specifies whether the CData ADO.NET Provider for Microsoft Excel Online should use the /search(q='.xls') endpoint to locate and retrieve workbook files. When set to true (default) , the driver performs a targeted search to list only workbook files, improving efficiency in large directories. If set to false, all items are listed using the /children endpoint, and workbook files are filtered client-side. |
| UseSimpleNames | Specifies whether or not simple names should be used for tables and columns. |
| ValueInputOption | Determines how the provider parses values the user submits to Microsoft Excel Online. |
| ValueRenderOption | Determines how the provider renders values in the output. |