Create excel from local data

Question

Team, 
 I am having a requirement to generate an excel document from data available as list of CDT (Storing data to DB not allowed). Need suggestions on this.

Danny Verb · Answer

You can do this by converting a datasubset to base64 and then converting base64 to an Appian document. You need to be careful doing this as these plugins can really harm your environment because of how much text they generate. Look at the Excel Tools plugin to find the function 'exportdatasubsettobase64' and then look at the plugin 'Base64 document conversion' to use the smart service. I recommend not saving base64 in a process variable and instead calling the function to exportdatasubsettobase64 within the other smart service. You should also set the process to terminate upon completion and to delete after 1 day

Create excel from local data

Top Replies