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

[Allin Cottrell]

On Tue, 22 Apr 2008, Riccardo (Jack) Lucchetti wrote:

> On Tue, 22 Apr 2008, Michael Boldin wrote:
> 
> > Allin-- all is well with one GRETL install.  The sheet and 
> > offset options work as expected.
> > 
> > My minor complaints are
> > -- might be easier to remember offsets if they are --rowoffset and
> > --coloffset
> 
> I agree.

OK, --rowoffset and --coloffset it is.

> > -- if you offset into a blank area you get 'Unspecified error'
> 
> Are you suggesting that something should be done or just that 
> the error message should be more informative?

Clearly a more informative error message is wanted here.

> > -- some might want to use sheet names, not knowing the OLE order.
> 
> Yes, this would be very neat.

OK, you can now do either --sheet=3 or --sheet="Sheetname".  The 
double quotes are mandatory when a name is given.

> > -- if 2 or more open/imports are run in a series, the command 
> > log seems to reset (empty) after each one. There are cases 
> > where keeping the command log going to see all imports and 
> > 'run "file.inp" ' steps would be better for debugging and 
> > documentation.

Yes, that's worth thinking about.

> Also, the same syntax should be applied to the "append" command.

Ah, yes, good point.

Allin.