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

Michael Boldin michaelboldin at comcast.net
Mon Apr 21 20:17:56 EDT 2008


I got the right download now with a April build date  (sorry I somehow
misread a 3-20-2008 build as last week)

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

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. 

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

The error is always

   First character of varname (0x0) is bad (first must be alphabetical)

Even other spreadsheets that the old 1.7.4 can read can not be read by the
new Gretl now.  But I can open any Gretl sample dataset.  

Can I have two Gretl versions installed?  

-----Original Message-----
From: gretl-users-bounces at lists.wfu.edu
[mailto:gretl-users-bounces at lists.wfu.edu] On Behalf Of Allin Cottrell
Sent: Monday, April 21, 2008 6:13 PM
To: Gretl list
Subject: RE: [Gretl-users] Request: options in reading excel data files

On Mon, 21 Apr 2008, Michael Boldin wrote:

> I tried from
>
http://sourceforge.net/project/showfiles.php?group_id=36234&package_id=28605
> the Windows EXE
>  gretl-1.7.4.exe  Mirror  9954757 5432 i386 .exe (32-bit Windows)
> But it did to seem to use the -- arguments with open...

Thanks for testing!  But for this new feature you need the current 
snapshot:

http://ricardo.ecn.wfu.edu/pub/gretl/gretl_install.exe

It'll be in release 1.7.5 when that happens, which ought to be 
fairly soon.

Allin.
_______________________________________________
Gretl-users mailing list
Gretl-users at lists.wfu.edu
http://lists.wfu.edu/mailman/listinfo/gretl-users



More information about the Gretl-users mailing list