Discussion

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"

Comments

Keep up to date on this post and subscribe to comments

September 4, 2018 - 9:46am

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

Pega
December 2, 2018 - 10:29pm
Response to TusharR3103

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.

December 7, 2018 - 3:47am
Response to Chithra

Hi Chitra,

I followed the same steps however i am getting NullPointerException set on my Test pageList. below are some screenshots :

 

Pega
December 7, 2018 - 8:55am
Response to NikitaG7

Hi Nikita, could you share screenshot of how the Test page has been configured in your activity.

Thanks!

September 4, 2018 - 6:15pm

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

June 27, 2019 - 6:10am
Response to Deva_Prathapaneni

Hi, Add Refresh section Action with The activity as show below.

This worked for me to download in the same window.

 

September 6, 2018 - 4:45pm

i could download file by calling activity  in open url window action on button.

November 28, 2018 - 4:59am
Response to Deva_Prathapaneni

Hi , Can you please help me on this?

I am not able to download the file even if when I am using "open url window " action and using that activity, getting run-time error

Pega
December 2, 2018 - 10:20pm
Response to SushantaP7861

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!

March 24, 2019 - 11:51pm
Response to Chithra

Hi,

Can you tell about Allow direct invocation from the client or service?

What it actually means?

March 25, 2019 - 7:05am
Response to RaghavenderReddyL

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.

Vidyaranjan | Community Moderator | Pegasystems Inc.