Class ExcelExportDataTableOptions

Specifies the possible ExportDataTable options.

Inheritance

System.Object

ExcelExportDataTableOptions

Namespace: Syncfusion.XlsIO

Assembly: Syncfusion.XlsIO.Portable.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	Description
ExcelExportDataTableOptions

ComputedFormulaValues

Indicates that the formula values are computed and exported to the datatable.

Declaration

public const ExcelExportDataTableOptions ComputedFormulaValues

Field Value

Type	Description
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	Description
ExcelExportDataTableOptions

DetectColumnTypes

Indicates that XlsIO should try to detect column types.

Declaration

public const ExcelExportDataTableOptions DetectColumnTypes

Field Value

Type	Description
ExcelExportDataTableOptions

DetectMixedValueType

Indicates that XlsIO should try to detect different types in single column

Declaration

public const ExcelExportDataTableOptions DetectMixedValueType

Field Value

Type	Description
ExcelExportDataTableOptions

ExportHiddenColumns

Indicates that the hidden columns can be exported to the datatable.

Declaration

public const ExcelExportDataTableOptions ExportHiddenColumns

Field Value

Type	Description
ExcelExportDataTableOptions

ExportHiddenRows

Indicates that the hidden rows can be exported to the datatable.

Declaration

public const ExcelExportDataTableOptions ExportHiddenRows

Field Value

Type	Description
ExcelExportDataTableOptions

None

No datatable.

Declaration

public const ExcelExportDataTableOptions None

Field Value

Type	Description
ExcelExportDataTableOptions

PreserveOleDate

Indicates whether to preserve Ole date (double numbers) instead of date-time values.

Declaration

public const ExcelExportDataTableOptions PreserveOleDate

Field Value

Type	Description
ExcelExportDataTableOptions

TrimColumnNames

Indicates that the leading and trailing spaces from column names should be removed

Declaration

public const ExcelExportDataTableOptions TrimColumnNames

Field Value

Type	Description
ExcelExportDataTableOptions

value__

Declaration

public int value__

Field Value

Type	Description
System.Int32