ImportTableOptions class

Represents the options of importing data into cells.

The ImportTableOptions type exposes the following members:

Constructor	Description
init	Creates the default importing options.

Property	Description
convert_grid_style	Indicates whether apply the style of the grid view to cells.
convert_numeric_data	Gets or sets a value that indicates whether the string value should be converted to numeric or date value.
insert_rows	Indicates whether new rows should be added for importing data records.
shift_first_row_down	Indicates whether shifting the first row down when inserting rows.
is_field_name_shown	Indicates whether field name should be imported.
export_caption_as_field_name	Indicates whether exporting caption as field name
date_format	Gets or sets date format string for cells with imported datetime values.
number_formats	Gets or sets the number formats
is_formulas	Indicates whether the data are formulas.
total_rows	Gets or sets total row count to import from data source. -1 means all rows of given data source.
total_columns	Gets or sets total column count to import from data source. -1 means all rows of given data source.
column_indexes	Gets or sets the columns(0-based) to import from data source. null means all columns should be imported.
default_values	Default value for the value in the table is null.
is_html_string	Indicates whether the value contains html tags.
check_merged_cells	Indicates whether checking merged cells.