ImportTableOptions class

Represents the options of importing data into cells.

public class ImportTableOptions


Name Description
ImportTableOptions() Creates the default importing options.


Name Description
CheckMergedCells { get; set; } Indicates whether checking merged cells.
ColumnIndexes { get; set; } Gets or sets the columns(0-based) to import from data source. null means all columns should be imported.
ConvertGridStyle { get; set; } Indicates whether apply the style of the grid view to cells.
ConvertNumericData { get; set; } Gets or sets a value that indicates whether the string value should be converted to numeric or date value.
DateFormat { get; set; } Gets or sets date format string for cells with imported datetime values.
DefaultValues { get; set; } Default value for the value in the table is null.
ExportCaptionAsFieldName { get; set; } Indicates whether exporting caption as field name
InsertRows { get; set; } Indicates whether new rows should be added for importing data records.
IsFieldNameShown { get; set; } Indicates whether field name should be imported.
IsFormulas { get; set; } Indicates whether the data are formulas.
IsHtmlString { get; set; } Indicates whether the value contains html tags.
NumberFormats { get; set; } Gets or sets the number formats
ShiftFirstRowDown { get; set; } Indicates whether shifting the first row down when inserting rows.
TotalColumns { get; set; } Gets or sets total column count to import from data source. -1 means all rows of given data source.
TotalRows { get; set; } Gets or sets total row count to import from data source. -1 means all rows of given data source.

See Also