Next: BEGIN
Up: ACCEPT
Previous: ACCEPT /LINE
Contents
Index
ACCEPT Excel
Excel (TM) datafile may be readable by command ACCEPT. They must be con-
verted to CSV format (Comma Separated Values). A suitable use of the
dummy variables in ACCEPT command allows to skip the non-numeric fields.
The proper separator must then be specified using the second argument of
option /COLUMN: e.g.
ACCEPT * Var1 Var2 /File Excel.csv ";" /LINES 2 20
will read Var1 and Var2 from lines 2 to 20 of the corresponding Excel
file, from Excel columns "B" and "C" (second and third).
To be documented: Can character variables also be read with numeric ones
provided some adequate /FORMAT option ?
Gildas manager
2014-07-01