On Tue, 21 Feb 2017, Allin Cottrell wrote:
On Tue, 21 Feb 2017, Henrique Andrade wrote:
> I'm trying to analyze panel data for the first time using Gretl and I
> realized something (IMHO) weird. Gretl can open a csv file with
> non-numeric values but can't do that using xslx file. Please take a
> look at the commands (and the files attached):
> open panel.xlsx --coloffset=1 --rowoffset=1 # not working
> open panel.csv # working
> Is it possible to circumvent that behavior and open panel data stored
> in xlsx files?
I's very much easier for gretl to parse CSV data than xlsx. So
going via CSV is recommended in case of complications such as
non-numeric variables. (Panel data as such is not the issue here,
just the non-numeric values.)
Yeah, but... it does seem a bit lame that we don't handle
non-numeric values directly from spreadsheet files.
I've managed to factor out the handling of non-numeric stuff from
its context in our CSV importer, so that it can be used in the xlsx
importer. This is now in git, though not yet snapshots.
The other spreadsheet importer plugins are older, and it'll take a
bit more work to get them up to speed, but that should follow