Exporting to existing excel file
Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt
Re: Exporting to existing excel file
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
Hi Steve,
The Wfsave funtion exports dates in the dd/mm/yyyy format. Is there a way to change this to yyyyqq format?
Thanks.
The Wfsave funtion exports dates in the dd/mm/yyyy format. Is there a way to change this to yyyyqq format?
Thanks.
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13323
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Exporting to existing excel file
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
Re: Exporting to existing excel file
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?
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?
Who is online
Users browsing this forum: No registered users and 42 guests