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!
Saving Workfile data to Excel (.xlsx) using wfsave
Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Saving Workfile data to Excel (.xlsx) using wfsave
What is .$folder1 . ?
Follow us on Twitter @IHSEViews
Re: Saving Workfile data to Excel (.xlsx) using wfsave
Hello Gareth
Please excuse that I forgot to specify this. The code is written and executed in Perl and I specified that $folder1 = getcwd - get pathname of current working directory.
Please excuse that I forgot to specify this. The code is written and executed in Perl and I specified that $folder1 = getcwd - get pathname of current working directory.
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Saving Workfile data to Excel (.xlsx) using wfsave
Well it looks ok to me, assuming you have the quotes and spaces in the right place.
Follow us on Twitter @IHSEViews
Who is online
Users browsing this forum: No registered users and 41 guests