Copying data from Workfile into Excel file by row
Posted: 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.
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.