Re: [Gretl-users] Fwd: importing panel data from excel
On Tue, 24 Sep 2013, cociuba mihai wrote:
I'm trying to import some real data from excel and unfortunately
at the
fourth sheet Gretl shows "Data error", when I'm starting Gretl from the
terminal the error is "error in xlsx_set_obs_string: no markers allocated
xlsx_read_row: returning 2".
I attached the script, the excel file and the terminal output.
Thanks. That error message is quite obscure and I've now fixed it up
in CVS, so that (in this case) it reads:
"Expected numeric data, found string:
'n.s.' at row 202, column 2"
The problem is just that. I suppose that "n.s." may be meant to
indicate a missing value, but it is not one of the strings that
gretl recognizes for that purpose. For reference, gretl takes the
following to indicate "missing":
an empty cell,
a cell containing an empty string,
"NA", "N.A.", "n.a.", "na", "N/A",
"#N/A", "NaN",
".NaN", ".", ".."
Allin Cottrell