saving a transposed workfile as an excel file

For questions regarding programming in the EViews programming language.

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

Post Reply
helpmecodeplease
Posts: 4
Joined: Wed Oct 04, 2023 8:30 am

saving a transposed workfile as an excel file

Postby helpmecodeplease » Wed Oct 18, 2023 10:14 am

I found this code to save a workfile as an excel sheet, just wondering how I do it so the series are transposed.

Thanks

Code: Select all

wfsave(type=excel, mode=update) test_new.xls byrow
Top
EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13323
Joined: Tue Sep 16, 2008 5:38 pm

Re: saving a transposed workfile as an excel file

Postby EViews Gareth » Wed Oct 18, 2023 10:23 am

The "byrow" part does the transposing.
Follow us on Twitter @IHSEViews
Top
helpmecodeplease
Posts: 4
Joined: Wed Oct 04, 2023 8:30 am

Re: saving a transposed workfile as an excel file

Postby helpmecodeplease » Wed Oct 18, 2023 10:36 am

ah, of course, thanks.
Last edited by helpmecodeplease on Wed Oct 18, 2023 10:57 am, edited 1 time in total.
Top
EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13323
Joined: Tue Sep 16, 2008 5:38 pm

Re: saving a transposed workfile as an excel file

Postby EViews Gareth » Wed Oct 18, 2023 10:57 am

You can only save one page at a time.
Follow us on Twitter @IHSEViews
Top
Post Reply

Return to “Programming”

Who is online

Users browsing this forum: No registered users and 19 guests