Re: [Gretl-users] Problem with xlsx file
On Fri, 14 Jun 2013, Henrique Andrade wrote:
I'm trying to open an Excel spreadsheet but Gretl shows me an
error
message. I don't understand what is going wrong once I've worked with this
data before with no issues (please find attached the "teste.xlsx" file).
Thanks. The trouble with this xlsx file is that the "empty"
cells (e.g. the missing "cambio" value for 1995/01/01) are not
truly empty, rather they are marked as string cells containing
an empty string. (If you open the file in gnumeric you see a
single-quote character in those cells, indicating their
"stringy" nature.) This is weird/broken; however, we can work
around it by treating cells containing empty strings as empty.
That's now done in CVS.
(As a general point, xlsx files often tend to contain
invisible nonsense, only apparent if you unzip the file and
inspect the underlying XML. Go Microsoft!)
Allin