Read xlsx

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt

panacocha
Posts: 2
Joined: Fri Jan 31, 2014 5:28 am

Read xlsx

Postby panacocha » Fri Jan 31, 2014 5:34 am

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.

EViews Glenn
EViews Developer
Posts: 2682
Joined: Wed Oct 15, 2008 9:17 am

Re: Read xlsx

Postby EViews Glenn » Fri Jan 31, 2014 8:33 am

Don't use read, use wfopen or pageload.

panacocha
Posts: 2
Joined: Fri Jan 31, 2014 5:28 am

Re: Read xlsx

Postby panacocha » Mon Feb 03, 2014 6:33 am

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.

EViews Glenn
EViews Developer
Posts: 2682
Joined: Wed Oct 15, 2008 9:17 am

Re: Read xlsx

Postby EViews Glenn » Mon Feb 03, 2014 10:25 am

Don't drop your time variable. We should be able to figure out the time structure from that variable.


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 2 guests