EViews.com

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

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.