Page 1 of 1

saving a transposed workfile as an excel file

Posted: Wed Oct 18, 2023 10:14 am
by helpmecodeplease
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

Re: saving a transposed workfile as an excel file

Posted: Wed Oct 18, 2023 10:23 am
by EViews Gareth
The "byrow" part does the transposing.

Re: saving a transposed workfile as an excel file

Posted: Wed Oct 18, 2023 10:36 am
by helpmecodeplease
ah, of course, thanks.

Re: saving a transposed workfile as an excel file

Posted: Wed Oct 18, 2023 10:57 am
by EViews Gareth
You can only save one page at a time.