Extracting a matrix to excel

[strimar]

Hi,
Could you please help me with the following? I am trying to export several matrices from Eviews8 to Excel using:

Code: Select all

pagesave(type=excelxml, mode=update) "U:\myfolder\prova_matrix_export.xlsm" range="data!B3:AH5391" @keep dbmisiu_matrix_excel

but I get an error saying that the matrix is not a series. Is it possible to export a matrix?
If not do I have to transform the matrix into various series using “mtos”?

Unfortunately my workfile has to be on a quarterly frequency, but within it I have matrices with daily frequency. If I use “mtos” end up with the series with quarterly frequency. Consequently I lose the great majority of my data.

Thank you

[EViews Gareth]

The only way to write a matrix to an excel file is with matrix.write. Unfortunately it only creates .xls files, not .xlsx.

A better solution might be to create a daily page in your workfile and store the series there, rather than dealing with matrices at all.

[strimar]

OK, thank you