EViews.com

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

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.

No change.

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?

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

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?

Nice! Thanks!

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.

No.