Class ExcelExportDataTableOptions
Specifies the possible ExportDataTable options.
Inheritance
Namespace: Syncfusion.XlsIO
Assembly: Syncfusion.XlsIO.Base.dll
Syntax
public sealed class ExcelExportDataTableOptions : EnumFields
ColumnNames
Indicates that the first row of the range will be considered as a column name of the datatable.
Declaration
public const ExcelExportDataTableOptions ColumnNamesField Value
| Type |
|---|
| ExcelExportDataTableOptions |
ComputedFormulaValues
Indicates that the formula values are computed and exported to the datatable.
Declaration
public const ExcelExportDataTableOptions ComputedFormulaValuesField 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 DefaultStyleColumnTypesField Value
| Type |
|---|
| ExcelExportDataTableOptions |
DetectColumnTypes
Indicates that XlsIO should try to detect column types.
Declaration
public const ExcelExportDataTableOptions DetectColumnTypesField Value
| Type |
|---|
| ExcelExportDataTableOptions |
DetectMixedValueType
Indicates that XlsIO should try to detect different types in single column
Declaration
public const ExcelExportDataTableOptions DetectMixedValueTypeField Value
| Type |
|---|
| ExcelExportDataTableOptions |
ExportHiddenColumns
Indicates that the hidden columns can be exported to the datatable.
Declaration
public const ExcelExportDataTableOptions ExportHiddenColumnsField Value
| Type |
|---|
| ExcelExportDataTableOptions |
ExportHiddenRows
Indicates that the hidden rows can be exported to the datatable.
Declaration
public const ExcelExportDataTableOptions ExportHiddenRowsField Value
| Type |
|---|
| ExcelExportDataTableOptions |
None
No datatable.
Declaration
public const ExcelExportDataTableOptions NoneField Value
| Type |
|---|
| ExcelExportDataTableOptions |
PreserveOleDate
Indicates whether to preserve Ole date (double numbers) instead of date-time values.
Declaration
public const ExcelExportDataTableOptions PreserveOleDateField Value
| Type |
|---|
| ExcelExportDataTableOptions |
TrimColumnNames
Indicates that the leading and trailing spaces from column names should be removed
Declaration
public const ExcelExportDataTableOptions TrimColumnNamesField Value
| Type |
|---|
| ExcelExportDataTableOptions |