[Gretl-users] Re: fRUSTRATION TRYING TO LOAD AN XLSX DATASET
Many thanks Marcin for the appended file. Much appreciated.
I have now tried the cut and paste approach that has worked without
generating additional ghost variables.
It would be good to get a bug fix in Gretl for uploading Panel data
directly from an xlsx file ,however, without the addition of superfluous
empty variables or having to resort to a cut & paste approach.
Brian
On Mon, 15 Dec 2025 at 17:38, Marcin Błażejowski <marcin(a)gretlconference.org>
wrote:
On 12/15/25 18:16, Brian Revell wrote:
Hi
I have an xlsx datafile comprising 10 rivers labelled 1..10, 24
observations dated 2000-2023 plus 5 variables (See attached screenshot). I
have use File open command specifying it is an xlsx file which it reads and
then produces an error message.
F*ound 1 valid sheet*
*Found 11 Variables and 240 observations!!!*
*Name missing for variable 7 !!!*
I am using Gretll version 2025c
Strange thing (all on Debian):
1. clipboard method (copy+paste): works perfectly,
2. xlsx importing: got same error as Brian,
3. converted to ods: works, thought some fake variables were imported (see
attached file).
Marcin
_______________________________________________
Gretl-users mailing list -- gretl-users(a)gretlml.univpm.it
To unsubscribe send an email to gretl-users-leave(a)gretlml.univpm.it
Website:
https://gretlml.univpm.it/postorius/lists/gretl-users.gretlml.univpm.it/
Attachments:
- attachment.htm (text/html — 3.4 KB)