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

Allin I tried from http://sourceforge.net/project/showfiles.php?group_id=36234&package_i... 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(a)lists.wfu.edu [mailto:gretl-users-bounces@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: 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(a)lists.wfu.edu http://lists.wfu.edu/mailman/listinfo/gretl-users