Page 1 of 1

[EViews 5] Exporting a table to Excel to a specific cell

Posted: Wed Jul 14, 2010 6:16 am
by mr.interested
Hello All,

Is there any way to export a table into Excel (i.e. into csv file), but to set the data to be inserted starting from a specific cell, or to a specific range?

In the manual I can find only a range of the table to be exported, but there's nothing about specifying a cell from which the data should start in the csv. I have a number of tables to export, but I don't want to export them into separate csv files, and then merging them manually. For example, I would like to export table 1 into 1st row (or to be started from A1, or to a range A1:D1--it really doesn't matter), table 2 into 2nd row (or from A2, or to a range A2:D2), etc.:
A B C
1 (table 1)
2 (table 2)
3 (table 3)

I've tried a number of ways including table.save(t=csv) table.csv(r=A3:D3), but that obviously didn't work. Any ideas?

Re: [EViews 5] Exporting a table to Excel to a specific cell

Posted: Wed Jul 14, 2010 7:55 am
by EViews Jason
Unfortunately you cannot specify a destination cell. In EViews 7, you could have used insertcol and insertrow to pad out the data. In EViews 5, you will need to manually pad by copying the data to their desired location via a loop within a program.