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.
Copying data from Workfile into Excel file by row
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
Copying data from Workfile into Excel file by row
- Attachments
-
- With_JunkData.PNG (11.02 KiB) Viewed 17023 times
-
- Expected Result.PNG (11.81 KiB) Viewed 17023 times
-
- EViews Developer
- Posts: 799
- Joined: Tue Sep 16, 2008 3:00 pm
- Location: Irvine, CA
Re: Copying data from Workfile into Excel file by row
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.
Return to “Installation and Registration”
Who is online
Users browsing this forum: No registered users and 20 guests