Export grid data to Excel

Question

Hello,
I need an Export to Excel button to get an Excel file from the data in a grid (getting a report). I have tried to do it from different perspectives:
-I've tried to do it using CDTs (using the respective Smart Service tools Appian offers) wether it was in an Interface (in order to be able to download it there and then) or in the Process Modeler
-I've also tried the SQL to Excel plug in node (due to the data being the output of a stored procedure), once again in the Process Modeler (as far as I'm concerned, I haven't found a function with the same goal.

The closest I got was with the first option, but due to the changing nature of the project I am at the moment, the CDT I was using soon became obsolete and since then I've been trying to get around using one again without success.

P.D.: I'm using Appian Community Edition due to not really knowing the advantages of becoming an Appian partner/customer.

Thanks for your time,
Francisco

stefanhelzle0001 · Accepted Answer

To execute more than one smart service, you put these into a process and start it from the UI. Make sure to chain all nodes, then you get the process variables returned.

nareshs945 · Answer

Hi,Which version of Appian you are using. Appian latest version have an out of the box export functionality for record grids, you can use this to achieve your use case. To do thisCreate a Record for your table or view Once you set up that record, you can call that record grid in any Appian interface you want.You can also see helpful information herehttps://docs.appian.com/suite/help/22.1/read-only-grid-configuration.htmlhttps://docs.appian.com/suite/help/22.1/Records_Tutorial.html

Sign up

Login with SSO

Login to the community

Login with SSO