Page 1 of 1

Read matrix from excel-file

Posted: Thu Aug 27, 2015 5:30 am
by 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

Re: Read matrix from excel-file

Posted: Thu Aug 27, 2015 6:16 am
by EViews Gareth
Yes, mat1 must exist first

Re: Read matrix from excel-file

Posted: Thu Aug 27, 2015 6:27 am
by 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"

Re: Read matrix from excel-file

Posted: Thu Aug 27, 2015 7:38 am
by EViews Gareth
You have a space between read and its options.

Re: Read matrix from excel-file

Posted: Thu Sep 03, 2015 11:12 pm
by sakerstallda
Thanks a lot :)