ExportTableOptions Properties

Gets or sets whether to compute the value of formulas. If true, exported values will be the computed result of formulas. If false, exported values will be the textual representation of formulas.

Gets or sets whether to export column names. If true, the exported DataTable will include column names from the Excel file. If false, the exported DataTable will use default column names (e.g., Column1, Column2).

Gets or sets whether to preserve data formatting. If true, exported values will retain their display format (e.g., dates, currency). If false, exported values will be based on their raw data type.

Gets or sets whether to preserve data types. If true, exported columns will have their DataTable column types set based on the cell's data type (e.g., DateTime, decimal). If false, all columns will have their data type set to string. Note: This option only takes effect when KeepDataFormat is false.

Gets or sets the renaming strategy for duplicate column names. Possible values are: - RenameStrategy.Exception: Throws an exception. - RenameStrategy.Digit: Renames using a numeric suffix. - RenameStrategy.Letter: Renames using an alphabetic suffix.