Page 1 of 1

Exporting data to Excel : Date in columns instead of rows

Posted: Sun Oct 14, 2012 5:39 am
by DBel2012
Hello,

I' working with Eviews 6 (but migrating to Eviews 7 in a few weeks). I need to feed an Excel application that was developped a few years ago. I have annual and quarterly series in Eviews that need to be exported to an Excel file, with each series being reported in line instead of column.

My first idea was to work with matrix. But I'm not sure its a good idea.

Anyways, I'm looking for a code that would do the task. Hope someone can help me.

Thanks!

Re: Exporting data to Excel : Date in columns instead of row

Posted: Sun Oct 14, 2012 3:54 pm
by EViews Gareth

Code: Select all

write(t=xls, t) c:\temp\myfile.xls ser1 ser2 ser3

Re: Exporting data to Excel : Date in columns instead of row

Posted: Mon Oct 15, 2012 3:56 am
by DBel2012
Thanks a lot Gareth!