EViews.com

Hi Team,

I am trying to export a time series data (GDP) from a workfile to an excel. I am using the command wfsave so that I can get the data replaced in an existing excel named "output" in a specific worksheet and specific rows/column. Although, the numbers are getting printed but the corresponding dates are not getting printed.

Command:
wfsave(t=excelxml, mode=update) outputq range="Sheet1!D3" byrow @keep gdp @smpl 2014q1 2015q1

Result in excel:
_date_ 41548 41640 41730 41821 41913 42005
gdp 15916.2 15831.7 16010.4 16150.6 16208.90359 16318.7675

Here instead of 2014q1, it is showing a number 41548. Similarly, for 2014q2 its showing 41640. How can I get the dates mentioned in the first row? Please help

regards, RM

Could you provide the workfile and excel file?

Hi Gareth,

Thanks for your reply and your help. I am attaching the program, the workfile and the excel (final output). The dates (2014q1 and so on) are not getting displayed.

-RM

Its just because you have the formatting of that cell in Excel to show a number. If you change the formatting to show it in date format, you'll see it went in just fine.

Oh my! That was it. :D Thank you!