Discussion
IN
Last activity: 27 Jun 2019 6:10 EDT
Generate excel from pagelist
Build a activity as mentioned in screen shot .
Build an excel as attached and upload it as a binary file
Directory-excel
filename-OperatorsBinaryFile
extension-xlsx
activity params-"OperatorsBinaryFile.xlsx" ,"excel!OperatorsBinaryFile!xlsx"
-
Reply
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Citigroup Inc
IN
Hi,
I tried the same as you have suggested above to create excel, My activity is getting executed without error and browse page is also having proper data. But I am not getting excel to download after loading data in it.
Please help me if you can.
Thanks in advance.
Tushar
Pegasystems Inc.
US
Hi Tushar, When you say that your excel is not getting downloaded with data but the browse page has proper data I am not clear. So when you run the activity you see the activity popup a browser with download filename in it and when you click on the file you are seeing the content right? If so, is the content not appearing correctly at runtime using a button click?
Could you make sure you have your binary file configured correctly and let us know the browser you are using.
Thanks,
Chithra.
HSBC
IN
Hi Chitra,
I followed the same steps however i am getting NullPointerException set on my Test pageList. below are some screenshots :
Pegasystems Inc.
US
Hi Nikita, could you share screenshot of how the Test page has been configured in your activity.
Thanks!
Swedbank AB
SE
Hi,
I am able to down load the file when we run the activity . But if invoke same activity from button in section file is not loading . In tracer all works fine?
can you tell us your able to download from front end.
Thanks
Virtusa Polaris Pvt Ltd
LK
Hi, Add Refresh section Action with The activity as show below.
This worked for me to download in the same window.
Swedbank AB
SE
i could download file by calling activity in open url window action on button.
JP Morgan Chase & Co.
IN
Pegasystems Inc.
US
Hi, I got the run-time exception as well and noticed that the log error showing "lack access required to execute <activity>". So I updated my activity to allow access under "Security" tab and that fixed the issue for me.
Let us know if that helps!
Adept View
NL
Hi,
Can you tell about Allow direct invocation from the client or service?
What it actually means?
Pegasystems Inc.
IN
Hi,
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 Post button here. Once created, please reply back here with the URL of the new post.
You may also refer this discussion link as a reference in the new thread.