Importing a Matrix from Excel

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

tdeco
Posts: 3
Joined: Wed Nov 18, 2015 1:38 pm

Importing a Matrix from Excel

Postby tdeco » Wed Nov 18, 2015 1:57 pm

I am having a bit of a problem importing data, and I was wondering if there is anybody that can help me.

I am trying to import data from an excel 2007 file directly into an EViews matrix

My code is as follows

matrix(!row,!col) whatever
import "E:\blah\blah\blah.xlsx" range="X!c1:id500"

What I get is an empty matrix "whatever", and a plethora of series. I would like to put all that data directly into a matrix. With a pre-2007 excel file I could simply use the "read" command as in

matrix name.read etc.

and everything would be placed in automatically. How can I do the equivalent action of filling the created matrix using the import command?

Any help would be much appreciated!

PS. For the record, I am using EViews 8

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

Re: Importing a Matrix from Excel

Postby EViews Gareth » Wed Nov 18, 2015 2:09 pm

In EViews 9 you can use the importmat command.

In EViews 8 you're out of luck. Matrix.read still exists, but does not support .XLSX files.

Your only solution is to import as series, as you are doing, then put the series into a group and convert the group into a matrix using stom.
Follow us on Twitter @IHSEViews


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 7 guests