QueryTableXls module
- class QueryTableXls.QueryTableXls
Bases:
SpireObjectRepresents a query table in an Excel worksheet.
This class encapsulates the properties and methods for managing query tables in Excel. Query tables are used to import data from external data sources such as databases, text files, web pages, or other data sources into an Excel worksheet.
- property AdjustColumnWidth: bool
Gets or sets whether column widths are automatically adjusted when refreshing the query table.
When set to True, Excel will automatically adjust the column widths to fit the imported data when the query table is refreshed.
- Returns:
True if column widths are automatically adjusted; otherwise, False.
- Return type:
bool
- property PreserveFormatting: bool
Gets or sets whether formatting is preserved when refreshing the query table.
When set to True, any manual formatting applied to the query table will be preserved when the query table is refreshed with new data.
- Returns:
True if formatting is preserved during refresh; otherwise, False.
- Return type:
bool