Exporting to existing excel file

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Jason, EViews Moderator

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

Re: Exporting to existing excel file

Postby trainee » Wed Jul 26, 2017 5:44 am

Thanks Steve. This worked: wfsave(type=excel, mode=update) tracking.xls range=weights!a2 @keep wt_gmfm_us_t @smpl 2014Q3 2017Q2

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

Re: Exporting to existing excel file

Postby trainee » Wed Jul 26, 2017 2:47 pm

Hi Steve,

The Wfsave funtion exports dates in the dd/mm/yyyy format. Is there a way to change this to yyyyqq format?

Thanks.

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

Re: Exporting to existing excel file

Postby EViews Gareth » Wed Jul 26, 2017 2:50 pm

Create an alpha series in the workfile that has the date with the date format you want (use @datestr(@date, "YYYYQQ")). Then save that with the other series.
Follow us on Twitter @IHSEViews

saranya
Posts: 33
Joined: Wed Nov 16, 2016 5:51 am

Re: Exporting to existing excel file

Postby saranya » Wed May 16, 2018 4:22 am

Hi,

Is it possible to change the sheet name via writing code in EViews? or the mode = update function is applicable only with the default name in excel?


Return to “Programming”

Who is online

Users browsing this forum: Google [Bot] and 3 guests