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

[Michael Boldin]

Allin

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

Here is what my script output shows, for the attached 'opentest1.inp' and
XLS files.  All --xoffset= and --yoffset= values give the same results as =0

gretl version 1.7.4
Current session: 2008/04/21 18:03
? open 'C:\Documents and Settings\Michael\Desktop\test1.xls'  --sheet=1 \
  --xoffset=2 --yoffset=1
Listing 3 variables:
  0) const    1) X1       2) X2     

? summary X1

               Summary Statistics, using the observations 1 - 5
                 for the variable 'X1' (5 valid observations)

  Mean                     3.0000    
  Median                   3.0000    
  Minimum                  1.0000    
  Maximum                  5.0000    
  Standard deviation       1.5811    
  C.V.                     0.52705   
  Skewness                 0.00000   
  Ex. kurtosis            -1.3000    


? summary X2

               Summary Statistics, using the observations 1 - 5
                 for the variable 'X2' (5 valid observations)

  Mean                   300.00      
  Median                 300.00      
  Minimum                100.00      
  Maximum                500.00      
  Standard deviation     158.11      
  C.V.                     0.52705   
  Skewness                 0.00000   
  Ex. kurtosis            -1.3000    




Gretl 'About' tells meI am using 1.7.4 and build of 3-20-2008

Do I need to compile from the C code?

--Michael Boldin

-----Original Message-----
From: gretl-users-bounces at lists.wfu.edu
[mailto:gretl-users-bounces at lists.wfu.edu] On Behalf Of Allin Cottrell
Sent: Friday, April 18, 2008 11:46 PM
To: Gretl list
Subject: 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
_______________________________________________
Gretl-users mailing list
Gretl-users at lists.wfu.edu
http://lists.wfu.edu/mailman/listinfo/gretl-users
-------------- next part --------------
A non-text attachment was scrubbed...
Name: opentest1.inp
Type: application/x-gretlscript
Size: 119 bytes
Desc: not available
Url : http://lists.wfu.edu/pipermail/gretl-users/attachments/20080421/170006e9/opentest1-0001.bin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test1.xls
Type: application/octet-stream
Size: 15872 bytes
Desc: not available
Url : http://lists.wfu.edu/pipermail/gretl-users/attachments/20080421/170006e9/test1-0001.obj