Home
ImportData
This function is used to import comma-separated data files that have a header row that contains the column captions.

Syntax:

ImportData, filename, captionRowIndex, dataRowindex, columnRole[, columnRole…]

Parameters:

filename – the name fo the file to be imported. Must be in the myImportedData directory.

captionRowIndex – the row number (first row = 0) of the row that contains the column titles.

dataRowIndex – the row number (first row = 0) of the first row of data.

columnRole – one of {RowLabel_, Text_, Numeric_, Ignore_} that determines how that column will be treated during the import process. Repeated for each column in the file.

Examples:

ImportData,testdata.csv,0,1,RowLabel_,Text_,Numeric_

Is used to import the file testdata.csv which contains a header row followed by the data, and 3 columns with the first to be used for the label, the next as text column, and the remaining one as a numeric column.

 
< Prev   Next >

Reference