matrices to excel

For questions regarding programming in the EViews programming language.

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

trainee
Posts: 38
Joined: Fri Jun 13, 2014 12:59 pm

matrices to excel

Postby trainee » Wed Jul 23, 2014 1:48 pm

Hi all,

Is there a way to export matrices to excel in E-views 7?

Thanks

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

Re: matrices to excel

Postby EViews Gareth » Wed Jul 23, 2014 2:06 pm

matrixname.write

trainee
Posts: 38
Joined: Fri Jun 13, 2014 12:59 pm

Re: matrices to excel

Postby trainee » Wed Jul 23, 2014 2:40 pm

Thanks Gareth. Weirdly enough, I get a dump but its not in an excel file format. Any help?

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

Re: matrices to excel

Postby EViews Gareth » Wed Jul 23, 2014 3:23 pm

What exactly did you write?

trainee
Posts: 38
Joined: Fri Jun 13, 2014 12:59 pm

Re: matrices to excel

Postby trainee » Thu Jul 24, 2014 6:06 am

matrixname.write d

'd' being the file name I want

EViews Glenn
EViews Developer
Posts: 2682
Joined: Wed Oct 15, 2008 9:17 am

Re: matrices to excel

Postby EViews Glenn » Thu Jul 24, 2014 7:32 am

I think

Code: Select all

matrixname.write(t=xls) d.xls
will work.

trainee
Posts: 38
Joined: Fri Jun 13, 2014 12:59 pm

Re: matrices to excel

Postby trainee » Thu Jul 24, 2014 8:20 am

Amazing. Thanks Glenn.


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 2 guests