Question
Cognizant Technology Solutions
IN
Last activity: 16 Oct 2018 12:03 EDT
How To get the Excel file Generated From "MSOGenerateExcelFile" Activity with out downloading to local Syste?.
I need to Get the Excel file generated by "MSOGenerateExcelFile" Activity,which i need to upload to a server location.All these process should happen automatically, user should not get a popup for download.
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Accepted Solution
Pegasystems Inc.
IN
Hi AishwaryaKumar,
Popup will not come if Uncheck "DownloadFile" option from MSOGenerateExcelFile parameter option while calling it.
Generated excel will be stored in ServiceExport directory, from there file can be read and put is desired location .
Cognizant Technology Solutions
IN
Thank you sahus2,
let me try the same.How to get the service export directory can you please suggest?
Pegasystems Inc.
IN
Hello Jayashree,
Thank you for posting your query in the PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s available on the top right pane of this page. Once created, please reply back here with the URL of the new post.
We have also sent you a private message opening up a communication channel in case you have any further questions.
Cognizant Technology Solutions
IN
Hi Jayashree,
we have captured the excel output(excel Content) in a local variable in the java step of "MSOGenerateExcelfile" Activity and then using the output in "pyFileSource" property of Upload functionality.
Thanks,
Aiswarya Kumar Panda