How to export data to excel in a grid with more than 50 columns?

Certified Senior Developer

I am using a read-only grid to show data for reports. I need to export the data to excel but the grid has more than 50 columns. I have already tried default export to excel feature and a!exportDataStoreEntityToExcel() function but none of these worked. 

FYI:

  • Data is in SQL.
  • Appian version is 23.2.
  • Columns cannot be merged or it's count can't be reduced

Is there any way I can export the data to excel?

  Discussion posts and replies are publicly visible