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
Discussion posts and replies are publicly visible
piyusha6151 , 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.
is this some where documented for export to sql plugin where we can capture this limitation and share with client?