Exporting table to Excel

[VBoykis]

Hi All,

I know there are ways to export series to Excel, but is there a command that allows for the export of tables to an Excel file, something along the lines of the write (t=xls) c:\documents\file.xls t_table

Thank you.

[EViews Gareth]

EViews won't save a table directly to an Excel file, but it will save it as a CSV file (which Excel will open with no problems):

tablename.save(t=csv) c:\documents\file.csv

[flash]

Hi all,

has any imporvement been made in eviews 7 in regards to the above issue or does this continue to be the case still ?

Thanks.

[EViews Gareth]

No change.

[Karl1]

EViews won't save a table directly to an Excel file, but it will save it as a CSV file (which Excel will open with no problems):

tablename.save(t=csv) c:\documents\file.csv

The last line in the following commands did not work

modelbame.makegroup(s=m) table3b variablename1 variablename2
table3b.dtable
table3b.ddtabopts firstfreq(a) secfreq(none) display(year,7)
table3b.save(t=csv) c:\documents\table3b.csv

I get the error message "SAVE is not a valid view for TABLE3B in "DO_TABLE3B.SAVE(T=CSV) c:\documents\table3b.csv"."

Does anybody know what gets wrong here?

[EViews Gareth]

Your object, table3b, is not a table. It is a group. You'll need to freeze it into a table before saving.

[Karl1]

Seems like the freeze command freezes the raw data of the group, which is quaterly, and not the formated data, which is annual.
Is it possible to freeze the group as it is viewed?

[EViews Gareth]

Code: Select all

table3b.ddtabopts firstfreq(a) secfreq(none) display(year,7) freeze(tab1) table3b.dtable

[Karl1]

Nice! Thanks!

[nevernotnone]

Any update on this? I have a program that generates a number of summary tables that I would like to be able to write as multiple sheets within a single excel file.

[EViews Gareth]

No.