Reading error from excel files created by Ox
- First Post
- Replies
- Stats
-
Go to
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2008 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2007 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2006 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2005 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2004 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
Hi Allin and all other hard working member of the gretl team.
I’m having a hard time reading excel files created by "Ox Console version 8.02
(OS_X_64/U) (C) J.A. Doornik, 1994-2018”.
If I save a matrix in xls format, gretl gives me a message of “Failed to get workbook
info”.
If I save the matrix in xlsx format, gretl skips the header and gives me generic variable
names as in: v1, v2, …
Any suggestion for what I should do?
Fred
Am 21.02.2020 um 09:32 schrieb Fred Engst:
Hi Allin and all other hard working member of the gretl team.
I’m having a hard time reading excel files created by "Ox Console version 8.02
(OS_X_64/U) (C) J.A. Doornik, 1994-2018”.
If I save a matrix in xls format, gretl gives me a message of “Failed to get workbook
info”.
If I save the matrix in xlsx format, gretl skips the header and gives me generic variable
names as in: v1, v2, …
Any suggestion for what I should do?
Show us a file which provokes the problem (preferably a small one).
thanks
sven
On Fri, 21 Feb 2020, Fred Engst wrote:
Hi Allin and all other hard working member of the gretl team.
Hi, Fred.
I’m having a hard time reading excel files created by "Ox
Console
version 8.02 (OS_X_64/U) (C) J.A. Doornik, 1994-2018”.
If I save a matrix in xls format, gretl gives me a message of
“Failed to get workbook info”.
I'm not sure why Ox saves xls files in the archaic format of MS
Excel 2.1 (1987) but the furthest back gretl goes in MS archaeology
is Excel 4 (1992). That's unlikely to change.
If I save the matrix 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...
Allin
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
1772
days inactive
1774
days old
3 comments
3 participants
tags (0)
participants (3)
-
Allin Cottrell -
Fred Engst -
Sven Schreiber