EViews.com

Posted: **Thu Jan 09, 2014 2:10 pm**

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

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

Posted: **Thu Jan 09, 2014 2:13 pm**

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.

Posted: **Fri Jan 10, 2014 8:40 am**

OK, thank you

EViews.com

Extracting a matrix to excel

Extracting a matrix to excel

Re: Extracting a matrix to excel

Re: Extracting a matrix to excel