Eporting a group to Excel

For questions regarding programming in the EViews programming language.

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

FCIQ
Posts: 4
Joined: Wed Aug 28, 2013 2:13 pm

Eporting a group to Excel

Postby FCIQ » Fri Aug 30, 2013 7:50 am

Hi!

I was just wondering if there was a way to export a group to an excel file, using a command such as save or write for instance. Just so you know I group my series in order to give them a very specific order I have to respect. Maybe you could give me a way to sort them in the way I want so I could just do this in a workfile page and then export it very easily using the pagesave command.

Thanks in advance for your support!

Mathieu

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

Re: Eporting a group to Excel

Postby EViews Gareth » Fri Aug 30, 2013 8:13 am

You can use wfsave or pagesave.

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

Re: Eporting a group to Excel

Postby EViews Glenn » Fri Aug 30, 2013 9:49 am

With the group name.

jthodge
Posts: 77
Joined: Tue Oct 21, 2008 5:52 am

Re: Eporting a group to Excel

Postby jthodge » Fri Apr 10, 2015 7:34 am

I'm trying to use pagesave with the @keep option to export a group of series to an Excel file. My group has one series listed twice (I'd like it to appear in two different columns of the Excel file). But the resulting Excel file only has the series listed one time. Why isn't the pagesave (or @keep) command dropping that duplicate series from the group before exporting?

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

Re: Eporting a group to Excel

Postby EViews Gareth » Fri Apr 10, 2015 8:34 pm

It just does. You'll have to create a second series equal to the first and put that second one in the group.


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 2 guests