Page 1 of 1
Importing data from eviews
Posted: Fri Jan 05, 2018 12:42 pm
by miorinnovo
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
Re: Importing data from eviews
Posted: Fri Jan 05, 2018 1:22 pm
by EViews Gareth
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.
Re: Importing data from eviews
Posted: Fri Jan 05, 2018 3:19 pm
by miorinnovo
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
Re: Importing data from eviews
Posted: Fri Jan 05, 2018 4:14 pm
by EViews Gareth
Unfortunately not - the names need to be part of the single range.
Re: Importing data from eviews
Posted: Thu Jan 11, 2018 3:44 pm
by miorinnovo
Thanks, when I try to import eviews stops responding and it says "uncompromising file" in bottom left. Any idea what might be the problem?
Re: Importing data from eviews
Posted: Thu Jan 11, 2018 4:33 pm
by EViews Steve
Care to post the file here?
Re: Importing data from eviews
Posted: Fri Jan 12, 2018 8:03 pm
by miorinnovo
I was just being impatient it seems. it eventually works. thanks!