Page 1 of 1

Importing from excel directly into a matrix

Posted: Tue Aug 27, 2013 9:55 am
by blonggovnl
Hi,

Just wondering how I might import data from an excel file directly into a matrix. FYI: It's a 7x3 matrix of parameters, without a time dimension.

Does the import command allow for this or should I use something else. The help file only seems to have information on doing this in a "point and click" fashion.

Thanks,

BL

Re: Importing from excel directly into a matrix

Posted: Tue Aug 27, 2013 10:06 am
by EViews Gareth

Code: Select all

Matrix.read
Outlined in the object reference.

Note that it does not support .XLSX files.

Re: Importing from excel directly into a matrix

Posted: Thu Aug 29, 2013 4:10 am
by BrsG
[Using 8]

Related: is there a way to import directly into a table?

Background: I would like to import not only my series and their names, but also their descriptions.

Best
Boris

Re: Importing from excel directly into a matrix

Posted: Thu Aug 29, 2013 7:48 am
by EViews Gareth
No, there is not.

As an aside, why can you not simply read the descriptions in from Excel using wfopen?