[Gretl-users] Xlsx problem

Allin Cottrell 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
>>> messages:
>>>
>>> ? 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.

Allin Cottrell


More information about the Gretl-users mailing list