RE: [Gretl-users] Request: options in reading excel data files
On Fri, 18 Apr 2008, Michael Boldin wrote:
Finally, I wanted to be able to automate importing a set of
similar EXCEL files in GRETL and could not see how to get full
control with something like
open excel 'C:\data.xls' 1 1 'sheet1'
In CVS and the Windows snapshot you now have, for example:
open foo.xls --sheet=1 --xoffset=0 --yoffset=0
This applies to XLS, gnumeric and ODS. Zero or more of the three
new parameters may be given. The defaults are shown above: sheet
number 1, x (column) and y (row) offsets both zero. The sheet is
specified as a positive integer and the offsets as non-negative
integers.
Allin Cottrell