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.
Read xlsx
Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt
-
EViews Glenn
- EViews Developer
- Posts: 2682
- Joined: Wed Oct 15, 2008 9:17 am
Re: Read xlsx
Don't use read, use wfopen or pageload.
Re: Read xlsx
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.
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
Don't drop your time variable. We should be able to figure out the time structure from that variable.
Who is online
Users browsing this forum: No registered users and 2 guests
