[Gretl-users] Re: error in reading excel data
On Tue, 2 May 2023, Alison Loddick wrote:
I read in an excel data file today and got the following error
[cid:image001.png@01D97D04.66BC2DD0]
Ive been through the file; the companies were text and the
numerical variables were all numbers. I thought I was going mad. I
copied it into a new spreadsheet and still had the same error. I
still don't know why. Has anyone else had It and can advise? I
ended up reading it into SPSS without any problems and saved it,
and then read it into GRETL without any problems.
It was a solution but not the answer.
Thanks to Alison for sending me the xlsx file off-list.
It turns out this was a case of a missing value, but represented in
a way that gretl did not recognize as such, namely via the string
$$ER: 9898,NO DATA AVAILABLE
which I gather indicates failure to pull data into an xlsx file from
an external source. Anyway, in git I've now added strings beginning
with "$$ER:" as an alias for "NA" in the context of xlsx files.
Snapshots will follow before long.
Allin