[Gretl-users] Request: options in reading excel data files

[Allin Cottrell]

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