menu

WinForms

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Enum ExcelExportDataTableOptions - WindowsForms API Reference | Syncfusion

    Show / Hide Table of Contents

    Enum ExcelExportDataTableOptions

    Specifies the possible ExportDataTable options.

    Namespace: Syncfusion.XlsIO
    Assembly: Syncfusion.XlsIO.Base.dll
    Syntax
    [Flags]
    public enum ExcelExportDataTableOptions

    Fields

    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

    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved