Importig excel data into EViews

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt

ancientmariner
Posts: 1
Joined: Wed Oct 10, 2012 9:07 am

Importig excel data into EViews

Postby ancientmariner » 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 .

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

Re: Importig excel data into EViews

Postby EViews Gareth » Wed Oct 10, 2012 9:47 am

Try putting that line inside a program, rather than from the command line.


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 2 guests