Class ImportTableOptions

ImportTableOptions class

Represents the options of importing data into cells.

public class ImportTableOptions


ImportTableOptions()Creates the default importing options.


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