Re: [Gretl-users] Xlsx problem
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)"
And Gretl gives me the following output:
? open "L:\CONFIDENCIAL\Planilha\Dados Países\Brasil\Mercado de
Crédito\Dados Crédito.xlsx" --sheet="Gretl" --rowoffset=148
'Gretl' -> worksheets/sheet11.xml
expected 403 shared strings but only found 397
Found 9 variables and 139 observations
At row 149, column 8:
First char of varname (0x0) is bad
(first must be alphabetical)
Please rename this variable and try again
Error executing script: halting
The name of the variable is "conc md PJ". I tried to rename it as
"teste"
but the error remains.
Kind regards,
Henrique Andrade*
*
Attachments:
- attachment.html (text/html — 2.1 KB)