Importing from excel

[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.

[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.

[88fr.leo]

Thanks

[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

[EViews Gareth]

Here

[88fr.leo]

Yes, this is what I want. But, is there any way of doing this by a program?!
Thx

[EViews Gareth]

Code: Select all

wfopen import.xlsx colhead=3 namepos=last

[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

[EViews Gareth]

Hard to say without seeing the file. Did you try:

Code: Select all

wfopen myfile.xls

?

[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

[EViews Gareth]

Code: Select all

wfopen c:\temp\futures_data.xls range="Sheet1!$D$7:$P$4000"

[chansen]

Thanks!