Export more than 100 columns to excel

Question

Hi Team,

I have a requirement to export more than 100 columns of data into an excel file. Since we have a limit of 50 columns in export data store entity to excel, I am unable to achieve this functionality directly. Can anyone please suggest the approach of achieving this functionality?

Thanks!!

Mike Schmitt · Answer

Have you tried the JSON to Excel plug-in yet? I haven't stress tested its total columns supported (and over 100 columns seems like a nightmare in almost any use case FWIW), but it doesn't list a particular max number of columns, and DOES support exporting arbitrary data dictionaries (AND supports base template files ( unlike the OOTB "DSE to Excel" node)), so it might work for you.

Shubham Aware · Answer

I already answer similar question. https://community.appian.com/discussions/f/data/34813/how-to-export-data-to-excel-in-a-grid-with-more-than-50-columns