Read matrix from excel-file

[sakerstallda]

I am trying to use the command read to import a matrix from excel into eviews. The name of the matrix is mat1, the data starts in the cell d3 and is situated in the sheet Yield. Why am I not able to use the command below? Do I have to define the matrix mat1 Before using the command read?

mat1.read (d3, s=Yield) "G:\EkAn\_Gemensam\Rapporter\Bankernas räntor och utlåning\Finansieringskostnad\Modell\Interpolering säkerställda\Räntor säkerställda storbankerna 2015-07-09.xls"

Regards

[EViews Gareth]

Yes, mat1 must exist first

[sakerstallda]

I have also tried as below. But I still don't get it to work. What do I miss? Some syntax error?

matrix (4000, 4000) mat1

mat1.read (d3, s=Yield) "G:\EkAn\_Gemensam\Rapporter\Bankernas räntor och utlåning\Finansieringskostnad\Modell\Interpolering säkerställda\Räntor säkerställda storbankerna 2015-07-09.xls"

[EViews Gareth]

You have a space between read and its options.

[sakerstallda]

Thanks a lot :)