Enum ExcelExportDataTableOptions

Specifies the possible ExportDataTable options.

[Flags]
public enum ExcelExportDataTableOptions

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