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 Moderator, EViews Jason, EViews Matt
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13603
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Saving Workfile data to Excel (.xlsx) using wfsave
What is .$folder1 . ?
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.
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13603
- 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.
Who is online
Users browsing this forum: No registered users and 2 guests
