Importing from excel directly into a matrix

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt

blonggovnl
Posts: 16
Joined: Thu Aug 22, 2013 7:45 am

Importing from excel directly into a matrix

Postby blonggovnl » Tue Aug 27, 2013 9:55 am

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

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

Re: Importing from excel directly into a matrix

Postby EViews Gareth » Tue Aug 27, 2013 10:06 am

Code: Select all

Matrix.read
Outlined in the object reference.

Note that it does not support .XLSX files.

BrsG
Posts: 18
Joined: Thu Aug 29, 2013 3:20 am

Re: Importing from excel directly into a matrix

Postby BrsG » Thu Aug 29, 2013 4:10 am

[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

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

Re: Importing from excel directly into a matrix

Postby EViews Gareth » Thu Aug 29, 2013 7:48 am

No, there is not.

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


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 2 guests