Importig excel data into EViews
Posted: Wed Oct 10, 2012 9:27 am
Hello- am just a beginner in this so please forgive my ignorance.
I am trying to write a code to import the contents of sheet 1 in an excel file (myfile in C drive) into an existing workfile so using
IMPORT(resize) C:\myfile.xls range="Sheet1" @smpl @all
should do a basic sequential import right ?
What I see is that it throws me up a wizard(with all the correct specification and stuff) where I have to click on the "finish" button to get the job done.
Am trying to automate things here and if I want the code to go the whole hog - i.e the wizard should not pop up and I should not have to click on the "finish"
button then is there any control option I can use ?
I use Eviews7 btw.
Thanks .
I am trying to write a code to import the contents of sheet 1 in an excel file (myfile in C drive) into an existing workfile so using
IMPORT(resize) C:\myfile.xls range="Sheet1" @smpl @all
should do a basic sequential import right ?
What I see is that it throws me up a wizard(with all the correct specification and stuff) where I have to click on the "finish" button to get the job done.
Am trying to automate things here and if I want the code to go the whole hog - i.e the wizard should not pop up and I should not have to click on the "finish"
button then is there any control option I can use ?
I use Eviews7 btw.
Thanks .