How to export selected rows in a gridField to a xls file and download it within a interface?

Question

I have a requirement where customer can select rows of record and click on "EXPORT TO XLS" button and download the selected records to a xls file. How to achieve that in Appian interface?

Tim · Accepted Answer

Hi Sudipas, what version of Appian are you using? The function a!exportDataStoreEntityToExcel() was added to 18.3 and removes the need to use plugins, using OOB functionality is by far the best approach to meet your original question. 
 
You mentioned querying 2 tables, for this you should create a VIEW on the database to perform the joins and create the logical dataset.

Tim · Answer

You can use the following function (depending on your version): docs.appian.com/.../Export_To_Excel_Smart_Service.html Within the a!queryFilter() you can pass the selected PK values to filter the result set.

sandeepd · Answer

Hi , 
 
Web Api would be best option for you from performance perspective as well. 
 
Select records from Grid, fetch record details again from query and pass this to Web Api for Exporting csv. 
 
Thanks, 
Sandeep Deshmukh

Vadivelan · Answer

Hi Kevin, 
 Please try the below. 
 Set the "Starting Cell" position as "A2"(second row). 
 Custom Cell Positions can be set as "A1", "B1", etc. 
 
 Thanks, 
 Vadivelan

How to export selected rows in a gridField to a xls file and download it within a interface?

Top Replies