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
Importing data from eviews
Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Importing data from eviews
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.
However you can specify a specific range using the range= argument on both the import and wfopen commands.
Follow us on Twitter @IHSEViews
-
- Posts: 199
- Joined: Sun Mar 01, 2015 5:01 pm
Re: Importing data from eviews
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
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Importing data from eviews
Unfortunately not - the names need to be part of the single range.
Follow us on Twitter @IHSEViews
-
- Posts: 199
- Joined: Sun Mar 01, 2015 5:01 pm
Re: Importing data from eviews
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 Developer
- Posts: 799
- Joined: Tue Sep 16, 2008 3:00 pm
- Location: Irvine, CA
Re: Importing data from eviews
Care to post the file here?
-
- Posts: 199
- Joined: Sun Mar 01, 2015 5:01 pm
Re: Importing data from eviews
I was just being impatient it seems. it eventually works. thanks!
Who is online
Users browsing this forum: No registered users and 40 guests