Dictionary to Excel/CSV

Hi you can use Export Data Store Entity to Excel Smart Service or Export Data Store Entity to CSV Smart Service (https://docs.appian.com/suite/help/23.3/Export_To_Excel_Smart_Service.html) in the documentation link you can find an example of how you ca do this in the interface.

If you have your data in a grid in interface or in any other place you can do a button "Generate CSV" that call a start process. In this start process you call first a rule that create a csv string (in the first row all columns name, splitted by , or ; and in the following rows your data splitted with the same convention of first row), then call the Text Doc From Template Smart Service (https://docs.appian.com/suite/help/23.1/Text_Doc_From_Template_Smart_Service.html) and !important! provide as a template file an excel file! At the end of the process, in the interface you call the result, better the id of the generated document using fv!processInfo.pp.generatedDocId (in OnSuccess section of startProcess function you called in terface).

You can save this id in a local on your interface and show a link (show if this local is not null) "Download Csv"

Hi you can use Export Data Store Entity to Excel Smart Service or Export Data Store Entity to CSV Smart Service (https://docs.appian.com/suite/help/23.3/Export_To_Excel_Smart_Service.html) in the documentation link you can find an example of how you ca do this in the interface.

If you have your data in a grid in interface or in any other place you can do a button "Generate CSV" that call a start process. In this start process you call first a rule that create a csv string (in the first row all columns name, splitted by , or ; and in the following rows your data splitted with the same convention of first row), then call the Text Doc From Template Smart Service (https://docs.appian.com/suite/help/23.1/Text_Doc_From_Template_Smart_Service.html) and !important! provide as a template file an excel file! At the end of the process, in the interface you call the result, better the id of the generated document using fv!processInfo.pp.generatedDocId (in OnSuccess section of startProcess function you called in terface).

You can save this id in a local on your interface and show a link (show if this local is not null) "Download Csv"

Hi this could actually work but I forgot to mention in the question that I have a template in my data and I've used Export CDT to Excel and works perfectly fine for me.