Skip to main content
February 4, 2025
Question

Is there any limitation of number of columns or excel size with Export_To_Excel_Smart_Service

  • February 4, 2025
  • 2 replies
  • 0 views

We need to generate excel from table having 40 MB data via Appian.

Out put excel will have 200 columns based of user selection in Appian UI. We are thinking do this via Batch during non business hours to avoid the load but checking is any limit on number of columns or excel size.

As Export sql to excel seems to be having 36 MB limit.

Can some one suggest?

Thanks

2 replies

mpoojas0001
February 5, 2025

 [mention:14427d7bfe0b4e0794062569c6374e69:e9ed411860ed4f2ba0265705b8793d05] , Batching should be good. yes appian export sql to excel has 36MB limit.  and Excel supports 16k columns, but performance degrades beyond 200–300 columns. So prefer batching in non business hours. 

February 5, 2025

is this some where documented for export to sql plugin where we can capture this limitation and share with client?