[EViews 5] Exporting a table to Excel to a specific cell
Posted: Wed Jul 14, 2010 6:16 am
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?
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?