ExcelImportDataOptions Class

Import Data options class

Inheritance
System.Object
ExcelImportDataOptions
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: Syncfusion.XlsIO
Assembly: Syncfusion.XlsIO.Base.dll
Syntax
public class ExcelImportDataOptions

Constructors

ExcelImportDataOptions()

Initializes a new instance of the ExcelImportDataOptions class.

Declaration
public ExcelImportDataOptions()

Properties

CollapseLevel

Specifies the group collapse level. The group will be expanded before this level and collapse will be applied from this level.

Declaration
public int CollapseLevel { get; set; }
Property Value
Type
System.Int32

FirstColumn

Specifies first column from where the data should be imported.

Declaration
public int FirstColumn { get; set; }
Property Value
Type
System.Int32

FirstRow

Specifies first row from where the data should be imported.

Declaration
public int FirstRow { get; set; }
Property Value
Type
System.Int32

IncludeHeader

Specifies whether class properties names must be imported or not.

Declaration
public bool IncludeHeader { get; set; }
Property Value
Type
System.Boolean

IncludeHeaderParent

Specifies whether parent class properties names must be imported or not.

Declaration
public bool IncludeHeaderParent { get; set; }
Property Value
Type
System.Boolean

NestedDataGroupOptions

Specifies whether the grouping is added with Collapse or Expand while importing nested collection objects.

Declaration
public ExcelNestedDataGroupOptions NestedDataGroupOptions { get; set; }
Property Value
Type
ExcelNestedDataGroupOptions

NestedDataLayoutOptions

Specifies how to fill the group field values while importing nested collection objects.

Declaration
public ExcelNestedDataLayoutOptions NestedDataLayoutOptions { get; set; }
Property Value
Type
ExcelNestedDataLayoutOptions

PreserveTypes

Indicates whether XlsIO should preserve column types from Data. By default, preserve type is TRUE. i.e., Setting it to True will import data based on column type, otherwise will import based on value type.

Declaration
public bool PreserveTypes { get; set; }
Property Value
Type
System.Boolean