[Gretl-users] Xlsx problem
cottrell at wfu.edu
Fri Nov 18 09:01:16 EST 2011
On Fri, 18 Nov 2011, Henrique Andrade wrote:
> Em 17 de novembro Allin escreveu:
> On Thu, 17 Nov 2011, Henrique Andrade wrote:
>> I´m trying to open some .xlsx files and I´m getting the following error
>>> ? open "L:\CONFIDENCIAL\Planilha\**Dados Países\Brasil\Mercado de
>>> Crédito\Dados Crédito.xlsx" --sheet="Gretl2" --rowoffset=148
>>> 'Gretl2' -> worksheets/sheet12.xml
>>> expected 403 shared strings but only found 397
>> That means that the xlsx file claimed to have 403 entries in its string
>> table (sharedStrings.xml), but in fact this contained only 397 entries.
>> This seems to indicate that the file is broken, but I've now added a fudge
>> factor in gretl's xlsx importer, to replace any strings that are missing in
>> this way with the empty string, "".
> Dear Allin, now I'm getting the following error message:
> "First char of varname (0x0) is bad
> (first must be alphabetical)"
Could you send me a copy of the xlsx file? Thanks.
More information about the Gretl-users