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

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!