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 _______________________________________________ Gretl-users mailing list Gretl-users(a)lists.wfu.edu http://lists.wfu.edu/mailman/listinfo/gretl-users