On Mon, 5 Mar 2012, Henrique Andrade wrote:
I think we still have some problems with the .xlsx files: Sometimes
Gretl
(version 1.9.7 / build date 2012-03-01 / Windows Vista) can't see the data
structure. This is a intriguing issue because even when the spreadsheets
are equal (at least visually) Gretl shows a different behavior.
Please take a look at the Teste.xlsx file attached. In that file we have
two sheets with the same information. With the command,
open C:\Users\f1831737\Desktop\Teste.xlsx --rowoffset=8 --sheet="IBC-Br SA"
Gretl doesn't define the data structure (time series). But with the command,
open C:\Users\f1831737\Desktop\Teste.xlsx --rowoffset=8 --sheet="IBC-Br SA
(2)"
Gretl defines my data as a time series.
The two sheets may look the same, but they're not! The one
that gretl doesn't recognize as dated has an extra empty row
at the bottom (the xlsx metadata claims that there is one more
row than in the other sheet). Since that extra row doesn't
have a date label, gretl gves up on a time-series
interpretation. In CVS (not snapshots yet) I've added
experimental code to get gretl to ignore such trailing blank
rows.
If I try to open via the GUI I get the following message/results:
<message>
'IBC-Br SA' -> worksheets/sheet1.xml
Found 6 variables and 385 observations"
</message>
And Gretl can not see the correct data structure. The same command in the
second sheet
gives me:
<message>
'IBC-Br SA' -> worksheets/sheet1.xml
didn't get worksheet
xmlParseFile falhou em xl\rId2
</message>
And Gretl doesn't open the data.
OK, that one seems like a gretl bug -- I'll look into it.
Allin, sorry for bugging you (and all the list members)
again with this subject, but I think the easiness of the
data opening is one of the most important features of Gretl
and, because of that, it's very important maintain its
correct functioning.
Thanks for the reports, they're helpful. We'll certainly try
to fix anything that's gretl's fault, but in cases where the
xlsx file is "weird" (in invisible ways) we can't always
guarantee a work-around.
Allin