Skip to main content
P
patriciad0003
Inspiring
June 25, 2024
Question

Generate excel and download it in one click

  • June 25, 2024
  • 3 replies
  • 0 views

Hi all,

We are trying to find if there is a way to generate an Excel, using a!exportDataStoreEntityToExcel() or other functionality, and start the download automatically without the need to access the interface after a while to download the Excel manually thought a link. We want to generate the excel and then download it in one click.

Has anyone tried this before or know how it can be achieved?

Thanks in advance.

3 replies

sriramk5349
sriramk5349
June 25, 2024

 if possible try to show the details in grid and show export to excel button.


As far as I know, there is no solution for generating and downloading the excel file in one click other than above solution

shubhama926776
shubhama926776
Brainy
June 25, 2024

There is no way from user input task to generate and download document on one click. 
But, If you know that the user will download a particular set of data, I recommend the following approach when using a process model:
Before going to the user input task, generate the document using the a!exportDataStoreEntityToExcel() smart service.
Then, simply provide the user with a link to download the document.

शुभम्
mikes0011
mikes0011
Brainy
June 25, 2024

This gets asked at least every few months - as usual, the (appian supported) answer is that the best solution will be one using 2 clicks - one to generate, another to download.

Terms & ConditionsAccessibility statement