RE: [Gretl-users] Request: options in reading excel data files
Allin & Jack--
For 'Are you suggesting that something should be done or just that the error
message ('Unspecified error') should be more informative?'
The latter-- I am suggesting something more informative. Maybe if 0 rows
of data read, then the error message could be 'No data found, after offsets
(x,y)'
-----Original Message-----
From: gretl-users-bounces(a)lists.wfu.edu
[mailto:gretl-users-bounces@lists.wfu.edu] On Behalf Of Riccardo (Jack)
Lucchetti
Sent: Tuesday, April 22, 2008 8:36 AM
To: Gretl list
Subject: RE: [Gretl-users] Request: options in reading excel data files
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.
-- 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?
-- some might want to use sheet names, not knowing the OLE order.
Yes, this would be very neat.
-- 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.
Also, the same syntax should be applied to the "append" command.
Otherwise, behaves perfectly.
I can confirm this (on linux). Well done, Allin!
Riccardo (Jack) Lucchetti
Dipartimento di Economia
Università Politecnica delle Marche
r.lucchetti(a)univpm.it
http://www.econ.univpm.it/lucchetti