Importing data from eviews

For questions regarding programming in the EViews programming language.

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

miorinnovo
Posts: 128
Joined: Sun Mar 01, 2015 5:01 pm

Importing data from eviews

Postby miorinnovo » Fri Jan 05, 2018 12:42 pm

Hello,

I'm trying to import data from an excel file but the data starts a few rows down, how do I specify the starting cell?

Thank you

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11902
Joined: Tue Sep 16, 2008 5:38 pm

Re: Importing data from eviews

Postby EViews Gareth » Fri Jan 05, 2018 1:22 pm

In general you do not need to, since EViews will figure it out for itself.

However you can specify a specific range using the range= argument on both the import and wfopen commands.
Follow us on Twitter @IHSEViews

miorinnovo
Posts: 128
Joined: Sun Mar 01, 2015 5:01 pm

Re: Importing data from eviews

Postby miorinnovo » Fri Jan 05, 2018 3:19 pm

Thanks, I'm just having an issue with naming the series because I dont have a name on the row directly above the data I want. Is there a way to choose another row with titles in it? Here my code:

Code: Select all

import B:\\file.xlsx range=page!$A13:$H$149 colhead=1 na="#N/A" @freq M 2010m08 @id @date @smpl @all

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11902
Joined: Tue Sep 16, 2008 5:38 pm

Re: Importing data from eviews

Postby EViews Gareth » Fri Jan 05, 2018 4:14 pm

Unfortunately not - the names need to be part of the single range.
Follow us on Twitter @IHSEViews

miorinnovo
Posts: 128
Joined: Sun Mar 01, 2015 5:01 pm

Re: Importing data from eviews

Postby miorinnovo » Thu Jan 11, 2018 3:44 pm

Thanks, when I try to import eviews stops responding and it says "uncompromising file" in bottom left. Any idea what might be the problem?

EViews Steve
EViews Developer
Posts: 530
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: Importing data from eviews

Postby EViews Steve » Thu Jan 11, 2018 4:33 pm

Care to post the file here?

miorinnovo
Posts: 128
Joined: Sun Mar 01, 2015 5:01 pm

Re: Importing data from eviews

Postby miorinnovo » Fri Jan 12, 2018 8:03 pm

I was just being impatient it seems. it eventually works. thanks!


Return to “Programming”

Who is online

Users browsing this forum: Baidu [Spider] and 23 guests