[Gretl-users] Re: Reading error from excel files created by Ox (Allin Cottrell)

Thank you Allin once again! Yes, I can now read .xlsx file created by Ox in gretl. I’m not sure what’s going on with OX. Not only was the excel file format not standard, but both .csv and .dta files created by “savemat” statement in Ox are causing reading error in gretl. Now that I have at least one file format that can be shared between Ox and gretl, I”m happy. Fred > > 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=20 >>> header and gives me generic variable names as in: v1, v2, =E2=80=A6 >>> =20 >>> Any suggestion for what I should do? >> >> It seems like we should be able to pick up column headings from such a = > file=20 >> but apparently Ox uses a somewhat unorthodox representation. If you ope= > n the=20 >> Ox-generated xlsx file in LibreOffice then save it, still in xlsx forma= > t,=20 >> gretl will find the headings OK. Maybe we can figure out how to handle = > the=20 >> Ox-generated case, or maybe not... > > OK, I think we're now able to handle the header strings in=20 > Ox-generated xlsx files (updates in git and snapshots). > > Allin