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

Question

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

M Pooja · Answer

piyusha6151 , Batching should be good. yes appian export sql to excel has 36MB limit. and Excel supports 16k columns, but performance degrades beyond 200&ndash;300 columns. So prefer batching in non business hours.

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

Top Replies