Exporting data to Excel : Date in columns instead of rows

[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!

[EViews Gareth]

Code: Select all

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

[DBel2012]

Thanks a lot Gareth!