Saving Workfile data to Excel (.xlsx) using wfsave
Posted: Tue Nov 14, 2017 5:00 am
My old code for saving Workfile Data to an .xls file worked like a charm:
write(t=xls,na=.,t,d=c,names,dates)".$folder1 . "\\export.xls fcst_1 fcst_2 fcst_3
Now, I would like to save the data to an .xlsx file using the new command wfsave. The current code I have now does not seem to work:
wfsave(type=excelxml)". $folder1 . "\\export.xlsx @keep fcst_1 fcst_2 fcst_3
Any suggestions or comments on how to fix the new code would be highly appreciated!
write(t=xls,na=.,t,d=c,names,dates)".$folder1 . "\\export.xls fcst_1 fcst_2 fcst_3
Now, I would like to save the data to an .xlsx file using the new command wfsave. The current code I have now does not seem to work:
wfsave(type=excelxml)". $folder1 . "\\export.xlsx @keep fcst_1 fcst_2 fcst_3
Any suggestions or comments on how to fix the new code would be highly appreciated!