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
Importing a Matrix from Excel
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13307
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Importing a Matrix from Excel
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.
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
Who is online
Users browsing this forum: No registered users and 18 guests