matrix 501 by 501 to excel in eviews 11

[mark lynch]

Hi

Trying to write a 501 by 501 matrix to excel using this code:

bet1sina.sheet
bet1sina.write(t=xls, b2) "c:\users\beta1.xls" range="beta1"

I get this error - Exceeds maximum size for spreadsheet (502 > 256 columns)

Is there a better way?
thanks

[EViews Gareth]

Unfortunately, no.

The only solution is to create a new page with 501 observations, copy the matrix over, convert the matrix into a group/series with mtos, then use wfsave to save the page as an excel file.

[mark lynch]

thanks - will give it a try

[startz]

As a mildly insane thought, might it work to push the matrix out to R or Matlab and then use a couple of lines of code there to send the matrix onward to Excel?