Can we download multiple Excel files on click of a button ?
We have a requirement to generate multiple Excel files on click of a button. We are able to generate one Excel on click of button, but when we try with multiple files, the latest file overrides the orevious files and only one gets downloaded. Please advise, if this can be achieved?
***Updated by moderator: Lochan to update Categories***
Pegasystems Inc.
GB
The only ways I can think of doing this:
1. Create custom code to ZIP up the EXCEL files into a single file before downloading.
-or-
2. Create custom client code (javascript probably) that is able to trigger multiple downloads of files.
This is a general challenge for all HTTP-based clients , rather than something specific with PRPC, see here for instance : http://stackoverflow.com/questions/2339440/download-multiple-files-with-a-single-action
Pegasystems Inc.
GB
See also here: https://collaborate.pega.com/question/how-create-zip-archive-and-attach-case - which might help with regard to a suggested method for creating ZIP files on the server.
Pegasystems Inc.
GB
If you are dealing with single-sheet EXCEL files; I guess another variation of the ZIP-THEM-ALL-UP approach would be to use Apache POI (say) to create a 'super' spreadsheet of the other spreadsheets - placing the data of each spreadsheet in a single sheet ? - Again: this would require some customization to work of course.
HCL
US
Hi Prit,
Thanks a lot for the responses and information. I will have to go through al the the links and think about the feasible approach.
As per the requirement, we have now added 3 actions(Open URL in a new window) on cick of a button by calling 3 activities. This seems to work temporarily. I will have to find the best solution however.
Pegasystems Inc.
US
https://community.pega.com/support/support-articles/document-download-performed-only-link-clicked-first explains how to download PDF files on click of a button . May be something similar can be applied to can be applied to this scenario