Copying data from Workfile into Excel file by row

For questions regarding installation and registration of EViews.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

nidhijain
Posts: 4
Joined: Tue Jan 16, 2018 2:10 am

Copying data from Workfile into Excel file by row

Postby nidhijain » Wed Feb 28, 2018 1:28 am

I have a work file having series with data from 1990 to 2050.
Now i want to copy the data from work file into excel file and that too by row means each series will be displayed in one row in excel and 1990 to 2050 will be displayed in column. First column of the excel is the name of the series.

I am using below command to accomplish data:

wfsave(type=excelxml, mode=update) MnemonicsSDData_Final_20171218v3.xls range="Sheet2!a1" byrow

It is copying data in the way expected.. but the first row is not showing the years from 1990 to 2050 but display some junk data.

I have attached images for both junk result and expected result for first row.

Please help to get the years in the first row instead of the junk values.
Attachments
With_JunkData.PNG
With_JunkData.PNG (11.02 KiB) Viewed 16888 times
Expected Result.PNG
Expected Result.PNG (11.81 KiB) Viewed 16888 times

EViews Steve
EViews Developer
Posts: 788
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: Copying data from Workfile into Excel file by row

Postby EViews Steve » Wed Feb 28, 2018 8:05 am

Actually, that number is the date. It's just in the wrong format. If you select those cells and change the cell display format to Date, you'll see the correct years.

excel_date_format.png
excel_date_format.png (48.55 KiB) Viewed 16878 times

excel_date_format_2.png
excel_date_format_2.png (20.76 KiB) Viewed 16877 times


Return to “Installation and Registration”

Who is online

Users browsing this forum: No registered users and 11 guests