Enum ExcelExportDataTableOptions
Specifies the possible ExportDataTable options.
Namespace: Syncfusion.XlsIO
Assembly: Syncfusion.XlsIO.Base.dll
Syntax
[Flags]
public enum ExcelExportDataTableOptionsFields
| Name | Description |
|---|---|
| ColumnNames | Indicates that the first row of the range will be considered as a column name of the datatable. |
| ComputedFormulaValues | Indicates that the formula values are computed and exported to the datatable. |
| 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. |
| DetectColumnTypes | Indicates that XlsIO should try to detect column types. |
| DetectMixedValueType | Indicates that XlsIO should try to detect different types in single column |
| ExportHiddenColumns | Indicates that the hidden columns can be exported to the datatable. |
| ExportHiddenRows | Indicates that the hidden rows can be exported to the datatable. |
| None | No datatable. |
| PreserveOleDate | Indicates whether to preserve Ole date (double numbers) instead of date-time values. |
| TrimColumnNames | Indicates that the leading and trailing spaces from column names should be removed |