FireDAC Components for Excel Online

Build 21.0.7930

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.


PropertyDescription
AllowFormulaWhether or not to treat values starting with an equals (=) sign as formulas during inserts and updates.
HeaderIndicates whether or not the provider should detect column names from the first row.
MaximumColumnSizeThe maximum column size.
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.
OtherThese hidden properties are used only in specific use cases.
PagesizeThe maximum number of results to return per page from Excel Online when UsePagination is True.
PseudoColumnsThis property indicates whether or not to include pseudo columns as columns to the table.
ReadonlyYou can use this property to enforce read-only access to Excel Online from the provider.
RowScanDepthThe maximum number of rows to scan to look for the columns available in a table.
RTKThe runtime key used for licensing.
ShowSharedDocumentsWhether or not to show shared documents.
SupportEnhancedSQLThis property enhances SQL functionality beyond what can be supported through the API directly, by enabling in-memory client-side processing.
TimeoutThe value in seconds until the timeout error is thrown, canceling the operation.
TypeDetectionSchemeDetermines how to determine the data types of columns.
UsePaginationWhether or not the CData ADO.NET Provider for Excel Online should use client side paging.
UseSimpleNamesBoolean determining if simple names should be used for tables and columns.
ValueInputOptionDetermines how the provider parses values the user submits to Excel Online.
ValueRenderOptionDetermines how the provider renders values in the output.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930