How can I import Excel data using programming?

For questions regarding programming in the EViews programming language.

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

farrel
Posts: 108
Joined: Thu Sep 18, 2008 11:13 pm

How can I import Excel data using programming?

Postby farrel » Thu Sep 25, 2008 1:44 pm

It's topic relates both to "Programming" and "Data Manipulation" ...

Anybody can help me to import Excel data massive into Eviews using programming language??
What code should be written?
What essentials I have to learn about to do these manipulations?

P.S. I use Eviews 6.0

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

Postby EViews Gareth » Thu Sep 25, 2008 1:56 pm

You can just use the wfopen command to read in Excel. In basic form:

Code: Select all

wfopen c:\myfile.xls


See the Command Reference for details on the options on wfopen to do more complicated things.


Return to “Programming”

Who is online

Users browsing this forum: Google [Bot] and 34 guests