ImportTableOptions

ImportTableOptions class

Represents the options of importing data into cells.

class ImportTableOptions;

Name	Description
constructor()	Creates the default importing options.

Property	Type	Description
convertGridStyle	boolean	Indicates whether apply the style of the grid view to cells.
convertNumericData	boolean	Gets or sets a value that indicates whether the string value should be converted to numeric or date value.
insertRows	boolean	Indicates whether new rows should be added for importing data records.
shiftFirstRowDown	boolean	Indicates whether shifting the first row down when inserting rows.
isFieldNameShown	boolean	Indicates whether field name should be imported.
exportCaptionAsFieldName	boolean	Indicates whether exporting caption as field name
dateFormat	string	Gets or sets date format string for cells with imported datetime values.
numberFormats	string[]	Gets or sets the number formats
isFormulas	boolean[]	Indicates whether the data are formulas.
totalRows	number	Gets or sets total row count to import from data source. -1 means all rows of given data source.
totalColumns	number	Gets or sets total column count to import from data source. -1 means all rows of given data source.
columnIndexes	number[]	Gets or sets the columns(0-based) to import from data source. null means all columns should be imported.
defaultValues	VObject[]	Default value for the value in the table is null.
isHtmlString	boolean	Indicates whether the value contains html tags.
checkMergedCells	boolean	Indicates whether checking merged cells.

Creates the default importing options.

constructor();

Indicates whether apply the style of the grid view to cells.

convertGridStyle : boolean;

Gets or sets a value that indicates whether the string value should be converted to numeric or date value.

convertNumericData : boolean;

Indicates whether new rows should be added for importing data records.

insertRows : boolean;

Indicates whether shifting the first row down when inserting rows.

shiftFirstRowDown : boolean;

Indicates whether field name should be imported.

isFieldNameShown : boolean;

Indicates whether exporting caption as field name

exportCaptionAsFieldName : boolean;

Remarks

Only works for DataTable.

Gets or sets date format string for cells with imported datetime values.

dateFormat : string;

Gets or sets the number formats

numberFormats : string[];

Indicates whether the data are formulas.

isFormulas : boolean[];

Gets or sets total row count to import from data source. -1 means all rows of given data source.

totalRows : number;

Gets or sets total column count to import from data source. -1 means all rows of given data source.

totalColumns : number;

Gets or sets the columns(0-based) to import from data source. null means all columns should be imported.

columnIndexes : number[];

Default value for the value in the table is null.

defaultValues : VObject[];

Indicates whether the value contains html tags.

isHtmlString : boolean;

Indicates whether checking merged cells.

checkMergedCells : boolean;