Class ExcelExportDataTableOptions
Specifies the possible ExportDataTable options.
Inheritance
Namespace: Syncfusion.XlsIO
Assembly: Syncfusion.XlsIO.NET.dll
Syntax
public sealed class ExcelExportDataTableOptions : Enum
Fields
ColumnNames
Indicates that the first row of the range will be considered as a column name of the datatable.
Declaration
public const ExcelExportDataTableOptions ColumnNames
Field Value
Type |
---|
ExcelExportDataTableOptions |
ComputedFormulaValues
Indicates that the formula values are computed and exported to the datatable.
Declaration
public const ExcelExportDataTableOptions ComputedFormulaValues
Field Value
Type |
---|
ExcelExportDataTableOptions |
DefaultStyleColumnTypes
When DetectColumnTypes is set and this flag is set too, it means that default column style must be used to detect style, if this flag is not set, but DetectColumnTypes is set, then first cell in the column will be used to detect column type.
Declaration
public const ExcelExportDataTableOptions DefaultStyleColumnTypes
Field Value
Type |
---|
ExcelExportDataTableOptions |
DetectColumnTypes
Indicates that XlsIO should try to detect column types.
Declaration
public const ExcelExportDataTableOptions DetectColumnTypes
Field Value
Type |
---|
ExcelExportDataTableOptions |
DetectMixedValueType
Indicates that XlsIO should try to detect different types in single column
Declaration
public const ExcelExportDataTableOptions DetectMixedValueType
Field Value
Type |
---|
ExcelExportDataTableOptions |
ExportHiddenColumns
Indicates that the hidden columns can be exported to the datatable.
Declaration
public const ExcelExportDataTableOptions ExportHiddenColumns
Field Value
Type |
---|
ExcelExportDataTableOptions |
ExportHiddenRows
Indicates that the hidden rows can be exported to the datatable.
Declaration
public const ExcelExportDataTableOptions ExportHiddenRows
Field Value
Type |
---|
ExcelExportDataTableOptions |
None
No datatable.
Declaration
public const ExcelExportDataTableOptions None
Field Value
Type |
---|
ExcelExportDataTableOptions |
PreserveOleDate
Indicates whether to preserve Ole date (double numbers) instead of date-time values.
Declaration
public const ExcelExportDataTableOptions PreserveOleDate
Field Value
Type |
---|
ExcelExportDataTableOptions |
TrimColumnNames
Indicates that the leading and trailing spaces from column names should be removed
Declaration
public const ExcelExportDataTableOptions TrimColumnNames
Field Value
Type |
---|
ExcelExportDataTableOptions |