[Gretl-users] Re: Reading error from excel files created by Ox
On Fri, 21 Feb 2020, Allin Cottrell wrote:
On Fri, 21 Feb 2020, Fred Engst wrote:
> If I save [a matrix from Ox] in xlsx format, gretl skips the
> header and gives me generic variable names as in: v1, v2, …
>
> Any suggestion for what I should do?
It seems like we should be able to pick up column headings from such a file
but apparently Ox uses a somewhat unorthodox representation. If you open the
Ox-generated xlsx file in LibreOffice then save it, still in xlsx format,
gretl will find the headings OK. Maybe we can figure out how to handle the
Ox-generated case, or maybe not...
OK, I think we're now able to handle the header strings in
Ox-generated xlsx files (updates in git and snapshots).
Allin