Page 1 of 1

Urgent: Export data to Excel (EV 6)

Posted: Mon Aug 02, 2010 7:38 am
by nadja123
Hi there,

I have a .wf1 with several pages and would like to write data series from each page (they have the same names) into several pages of a newly created .xls file. It seems that EV 6 does not support creation of Excel sheets or writing to a sheet with a particular name. Is my impression correct?

Simplified example:

Code: Select all

' the code iterates over %x (page names and sheet names) write(t=xls,names,dates,s={%x}) filename.xls series1 series2

This gave no error messages, but wrote each set of series into one and the same Excel sheet, named "filename". The resulting .xls file contained only this one sheet and data from the last .wf1 page.

Can please someone suggest a workaround I could use in my code? Thanks for helping!

Re: Urgent: Export data to Excel (EV 6)

Posted: Mon Aug 02, 2010 7:56 am
by EViews Gareth
EViews is only capable of creating dumb Excel files, and as such does not support sheet names.

Re: Urgent: Export data to Excel (EV 6)

Posted: Mon Aug 02, 2010 9:12 am
by nadja123
Thanks Gareth, although this is precisely the answer I was afraid of. I will work this around by creating several .xls files, each with the page name as I anyway need to work with them in another software. But may I perhaps ask you to add this to suggestions and requests for EV development? Thanks, bye.