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

[Allin Cottrell]

On Mon, 21 Apr 2008, Michael Boldin wrote:

> In my first tests, the XLS imports worked with the different 
> --xoffset and --yoffset options.  But I then tried a script with 
> --sheet=2 and this did not work

What happened?

> My first guess was the --sheet=1 option opens the last open XLS 
> sheet (as saved in EXCEL), even if is not named 'Sheet1', and 
> the options you added count from the default sheet and =2 or =3 
> might not exist.

For gretl's purposes the sheets are simply numbered from 1 to N, 
in the order in which they appear in the OLE file.  I don't think 
that order would be changed depending on which sheet had been 
active when the file was last saved.  (I know that's not the case 
when you edit an XLS file using gnumeric.)

> But that does not explain all of the errors I get, as now I can 
> not import any XLS files, even through the menu.

What has changed since you successfully imported using the 
--xoffset and --yoffset options?

At this point I've done a fair amount of testing on on Linux but 
not on Windows; I'll need to try that.  But the code is common, so 
I'm puzzled.  

> Can I have two Gretl versions installed?  

No, that won't work.  There will only be one set of registry 
entries for gretl, so whichever was installed last will (I 
suppose) be the only one to work.

Allin Cottrell