Page 1 of 1
Importing from excel
Posted: Mon Dec 10, 2012 8:41 am
by 88fr.leo
Good Morning,
I am need to import a file from excel, but i don't wanna loose my layout. for this I mean that I want to keep my inicial lines and start importing from an underneath line. Is this possible? I will send a sample.
Re: Importing from excel
Posted: Mon Dec 10, 2012 8:47 am
by EViews Gareth
On Step 2 of the Excel read dialog, state that there are 3 header lines, and that the Header type is "Names in last line". Then hit Finish.
Re: Importing from excel
Posted: Tue Dec 11, 2012 5:19 am
by 88fr.leo
Thanks
Re: Importing from excel
Posted: Mon Dec 17, 2012 12:13 pm
by 88fr.leo
I'm sorry, but I tried here and didn't worked.
Where should I put "Names in last line", in the eviews program, or in excel workfile?
Thx
Re: Importing from excel
Posted: Mon Dec 17, 2012 1:27 pm
by EViews Gareth
Here
Re: Importing from excel
Posted: Tue Dec 18, 2012 6:02 am
by 88fr.leo
Yes, this is what I want. But, is there any way of doing this by a program?!
Thx
Re: Importing from excel
Posted: Tue Dec 18, 2012 8:59 am
by EViews Gareth
Code: Select all
wfopen import.xlsx colhead=3 namepos=last
Re: Importing from excel
Posted: Thu Mar 14, 2013 10:57 am
by chansen
I would appreciate if you could show the code for how to import data from an excel file in the range D7-P4000 and the names were in D7-P7.
Thanks
Charlotte
I have attached the file. I would like to read the data CDATE, SOURCE, .... TY1_OPD1 starting in D7. Thanks
Re: Importing from excel
Posted: Thu Mar 14, 2013 11:13 am
by EViews Gareth
Hard to say without seeing the file. Did you try:
?
Re: Importing from excel
Posted: Mon Mar 18, 2013 7:38 am
by chansen
I uploaded my file to my previous post. I would greatly appreciate if you could write the programming line for how to import it.
Tanks
Re: Importing from excel
Posted: Mon Mar 18, 2013 8:42 am
by EViews Gareth
Code: Select all
wfopen c:\temp\futures_data.xls range="Sheet1!$D$7:$P$4000"
Re: Importing from excel
Posted: Mon Mar 18, 2013 9:50 am
by chansen
Thanks!