EViews.com

It works! Thanks a lot for your help!

Hi Would you mind posting an sample file that works with you commands %file = "c:\book1.xls" wfopen(page=Sheet1) %file for %s Sheet2 Sheet3 pageload(page=%s) %file range=%s next I have tried the simple programming %file = "C:\xxx\BOP1.xls" wfopen(page=BOP) %file pageload(page=BOP...

Thanks very much, but I want to use commands, not user interface like drag and drop

I am looking for something like
%file = "C:\xxx\Data_xxxx"
wfopen(page=xxx) %file

I would also like to open multiples sheets, having different formats.

Thanks,

JM

Hi, Thanks for your reply I am trying to import all names and data of a square matrix in one shot. I would like variable names to be imported alongside with associated data. I would not like to be obliged to give the variable names in Eviews. For example, variable names would be in the first column ...

Hello,

I would like to import an Excel matrix with different formats (one, two or three columns and one row) in command mode. I would like to read and import variables names (in the first column)
I would like to be able to import time (in column)
Would you have some examples?
Thanks very much
JM