Page 1 of 1

Read xlsx

Posted: Fri Jan 31, 2014 5:34 am
by panacocha
Hi,
just tried to program a data import from new Excel xlsx-file with eviews8.
But with the usual read code I didn't manage to import the data:
read(b2, s=input) X:\Ber_.............\file.xlsx 21

If I save the xlsx file as xls and try it, it works.
But does anyone know an easier way?
Thanks a lot.

Re: Read xlsx

Posted: Fri Jan 31, 2014 8:33 am
by EViews Glenn
Don't use read, use wfopen or pageload.

Re: Read xlsx

Posted: Mon Feb 03, 2014 6:33 am
by panacocha
Thanks Glenn,
managed to import data from xlsx via wfopen command
wfopen "X:\........xlsx" range="input" colhead=1 @drop time
But what I am missing now is the frequency setting, which was possible with the read-command, e.g. q 1994:1 2014:4
How do I integrate this?
Thanks a lot again.

Re: Read xlsx

Posted: Mon Feb 03, 2014 10:25 am
by EViews Glenn
Don't drop your time variable. We should be able to figure out the time structure from that variable.