menu

Xamarin.Android

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class ExcelExportDataTableOptions - Xamarin.Android API Reference | Syncfusion

    Show / Hide Table of Contents

    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
    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
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved