Reading Excel data in multiple worksheets

For questions regarding programming in the EViews programming language.

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

Dirk
Posts: 5
Joined: Thu May 31, 2012 5:30 am

Reading Excel data in multiple worksheets

Postby Dirk » Thu May 31, 2012 6:53 am

Hi all,

I have a very basic question. I need a program to read monthly data into a "monthly" worksheet and quarterly data into a "quarterly" worksheet. Then I want the progam to copy the quarterly data into the monthly worksheet to achieve an automatic frequency conversion. Can anyone tell me how to program this?

Or is there a better way to convert quarterly to monthly data with an Eviews code?

Many thanks
D.

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

Re: Reading Excel data in multiple worksheets

Postby EViews Gareth » Thu May 31, 2012 7:44 am

Use the wfopen command to open up the first sheet, then use the pageload command to open up the rest of the sheets, then use the copy command to copy from one to the other.

Or, you could just use the import command to import directly from the quarterly Excel sheet into the monthly EViews page, doing frequency conversion on the fly.
Follow us on Twitter @IHSEViews

Dirk
Posts: 5
Joined: Thu May 31, 2012 5:30 am

Re: Reading Excel data in multiple worksheets

Postby Dirk » Thu May 31, 2012 10:43 pm

Many thanks, I'll try this.


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 15 guests