Class ExcelExportDataTableOptions

Specifies the possible ExportDataTable options.

Inheritance
System.Object
ExcelExportDataTableOptions
Namespace: Syncfusion.XlsIO
Assembly: Syncfusion.XlsIO.UWP.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

Extension Methods