next up previous contents index
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