Excel 2007 format problems
Posted: Thu Mar 25, 2010 11:32 am
Tom,
I am having trouble reading Excel 2007 format files.
I am using the following code at the start of the file:
end(reset)
cal(m) 1977
all 0 2020:1
open data "StateSMAIGDP.xlsx"
DATA(FORMAT=XLSX,ORG=COLUMNS,SHEET="RATS") /
close data
When I use the SAME CODE, but substitute XLS for XLSX (same file, just saved as older format), it reads fine. Is this a known bug in 7.3? Or is there something additional I need to do with XLSX format? I attach the XLSX format file for your reference.
Regards,
Jason Frederick
I am having trouble reading Excel 2007 format files.
I am using the following code at the start of the file:
end(reset)
cal(m) 1977
all 0 2020:1
open data "StateSMAIGDP.xlsx"
DATA(FORMAT=XLSX,ORG=COLUMNS,SHEET="RATS") /
close data
When I use the SAME CODE, but substitute XLS for XLSX (same file, just saved as older format), it reads fine. Is this a known bug in 7.3? Or is there something additional I need to do with XLSX format? I attach the XLSX format file for your reference.
Regards,
Jason Frederick