new ImportOptions()
The ImportOptions type defines options to import data from CSV format. The Import() method imports data from CSV format. A comma-separated values (CSV) file is a delimited text file that uses a comma to separate values. Each line of the file is a data record. Each record consists of one or more fields, separated by commas.
Members
(static) eof :string
The eof (EndOfField) field specifies the character to separate fields within the row/item/line (has effect only if format field is "CSV").
Type:
- string
Example
"\t" {string}, specifies TAB charactar as field separator(static) eor :string
The eor (EndOfRow) field specifies the characters the row/item/line ends (has effect only if format field is "CSV").
Type:
- string
Example
";" {string}, specifies that the ; character to end each row/item/line(static) format :string
The format field specifies the format of source to import data form.
Type:
- string
Example
null {null}, specifies that the source of import is an array of [[value]] type
"CSV" {string}, specifies that the source of import is a string in CSV format(static) hdr :boolean
The hdr field specifies whether the first line indicates the control's legend (has effect only if format field is "CSV").
Type:
- boolean
Example
false {boolean}, specifies the no header line is provided
true {boolean}, the first line defines the control's legend(static) limit :number
The limit field specifies the maximum number of rows/items/lines to import.
Type:
- number
Example
undefined {undefined}, specifies unlimited number of rows/items/lines to import
1000 {number}, limits the items to import to 1,000(static) str :string
The str field specifies the character to quote values (has effect only if format field is "CSV").
Type:
- string
Example
"'" {string}, specifies ' character to quote any value that contains other ' or eof character