Click or drag to resize

ExportTableOptions Class

Options class for exporting to a DataTable, used to configure export behavior.
Inheritance Hierarchy
System Object
Spire.Xls ExportTableOptions

Namespace: Spire.Xls
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public class ExportTableOptions

The ExportTableOptions type exposes the following members.

Constructors
Name Description
Public method ExportTableOptions
Default constructor, initializes an instance of ExportTableOptions.
Top
Properties
Name Description
Public property ComputedFormulaValue
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.
Public property ExportColumnNames
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).
Public property KeepDataFormat
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.
Public property KeepDataType
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.
Public property RenameStrategy
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.
Top
Methods
Name Description
Public method Equals
Determines whether the specified object is equal to the current object.
(Inherited from Object .)
Protected method Finalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object .)
Public method GetHashCode
Serves as the default hash function.
(Inherited from Object .)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object .)
Protected method MemberwiseClone
Creates a shallow copy of the current Object .
(Inherited from Object .)
Public method ToString
Returns a string that represents the current object.
(Inherited from Object .)
Top
See Also