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.
|