Export series to Excel Sheets ( V8.1)

[nak3255]

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.

[EViews Gareth]

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.

[nak3255]

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.

[EViews Gareth]

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.