ExportTableOptions module
- class ExportTableOptions.ExportTableOptions
Bases:
SpireObjectRepresents options for exporting Excel tables to other formats.
This class provides properties to control the behavior when exporting Excel tables to other formats such as DataTable, CSV, etc. It allows customization of data formatting, column names handling, and formula calculation during the export process.
- property ComputedFormulaValue: bool
Gets or sets whether to export the computed values of formulas.
When set to True, the result of formula calculations will be exported. When set to False, the formulas themselves may be exported depending on the target format.
- Returns:
True if computed formula values should be exported; otherwise, False.
- Return type:
bool
- property ExportColumnNames: bool
Gets or sets whether to export column names when exporting.
When set to True, the first row of the exported data will contain column names. When set to False, only the data will be exported without column names.
- Returns:
True if column names should be exported; otherwise, False.
- Return type:
bool
- property KeepDataFormat: bool
Gets or sets whether to keep the original data format when exporting.
When set to True, the exported data will maintain the same formatting as in Excel. When set to False, the data may be converted to native types in the target format.
- Returns:
True if the original data format should be kept; otherwise, False.
- Return type:
bool
- property RenameStrategy: RenameStrategy
Gets or sets the strategy for renaming columns when exporting.
This property determines how column names are handled when there are duplicates or invalid names in the target format.
- Returns:
An enumeration value representing the strategy for renaming columns.
- Return type:
RenameStrategy