EViews.com

Posted: **Thu Sep 03, 2015 11:10 am**

Good morning,

I am currently trying to write a program that involves exporting groups of variables into a MS Excel spreadsheet file. Ideally, I would like to export each group to a different sheet. With the ‘write’ command, I am able to export the groups to a single sheet in Excel; I am curious whether or not I can specify the creation of new sheets or write to already existing sheets. Here's the basic gist of my code:

Code: Select all

group scenario1 ......list of series......
group baseline .....list of series.......
smpl 2005:0 2020:4
write(t,t=xls) G:\MACRO\EconTopics\RulesofThumb\oil{%run} baseline scenario1

Suggestions?

Thanks so much for your time.

Posted: **Thu Sep 03, 2015 11:22 am**

EViews 8 does not allow you to modify existing Excel files, including writing to different sheets.

You'll have to move to EV9.

As an aside, you should be using wfsave rather than write.

Posted: **Thu Sep 03, 2015 11:34 am**

EViews Garreth,

Thanks. To clarify, any sort of sheet specification (including creating, not modifying, new sheets) is impossible inside of EViews 8?

I appreciate your time.

Posted: **Thu Sep 03, 2015 12:54 pm**

You can specify the sheet you want to save to, but every time you save to an Excel file it will wipe out anything already there including other sheets.

EViews.com

Export series to Excel Sheets ( V8.1)

Export series to Excel Sheets ( V8.1)

Re: Export series to Excel Sheets ( V8.1)

Re: Export series to Excel Sheets ( V8.1)

Re: Export series to Excel Sheets ( V8.1)