Page 2 of 2
Re: Exporting to existing excel file
Posted: Wed Jul 26, 2017 5:44 am
by trainee
Thanks Steve. This worked: wfsave(type=excel, mode=update) tracking.xls range=weights!a2 @keep wt_gmfm_us_t @smpl 2014Q3 2017Q2
Re: Exporting to existing excel file
Posted: Wed Jul 26, 2017 2:47 pm
by trainee
Hi Steve,
The Wfsave funtion exports dates in the dd/mm/yyyy format. Is there a way to change this to yyyyqq format?
Thanks.
Re: Exporting to existing excel file
Posted: Wed Jul 26, 2017 2:50 pm
by EViews Gareth
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.
Re: Exporting to existing excel file
Posted: Wed May 16, 2018 4:22 am
by saranya
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?