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?
[EViews 5] Exporting a table to Excel to a specific cell
Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason
-
mr.interested
- Posts: 16
- Joined: Wed Jul 14, 2010 5:57 am
-
EViews Jason
- EViews Developer
- Posts: 870
- Joined: Tue Sep 16, 2008 3:50 pm
Re: [EViews 5] Exporting a table to Excel to a specific cell
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.
Who is online
Users browsing this forum: No registered users and 2 guests
