ExportTableOptions Class |
Namespace: Spire.Xls
The ExportTableOptions type exposes the following members.
Name | Description | |
---|---|---|
![]() |
ExportTableOptions |
Default constructor, initializes an instance of ExportTableOptions.
|
Name | Description | |
---|---|---|
![]() |
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.
|
![]() |
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).
|
![]() |
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.
|
![]() |
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.
|
![]() |
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.
|
Name | Description | |
---|---|---|
![]() |
Equals |
Determines whether the specified object is equal to the current object.
(Inherited from
Object
.)
|
![]() |
Finalize |
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from
Object
.)
|
![]() |
GetHashCode |
Serves as the default hash function.
(Inherited from
Object
.)
|
![]() |
GetType |
Gets the
Type
of the current instance.
(Inherited from
Object
.)
|
![]() |
MemberwiseClone |
Creates a shallow copy of the current
Object
.
(Inherited from
Object
.)
|
![]() |
ToString |
Returns a string that represents the current object.
(Inherited from
Object
.)
|