How to Download data to an Excel where a view has more than 150 columns?
Discussion posts and replies are publicly visible
What have you tried so far?
We have tried in Process model.we have a smart service named "Export Data store entity to Excel" where its throwing an error "Export can happen for max of 50 columns",What can we do in this situation?
Hi there,The other alternative is using Export SQL to Excel, but this service is deprecated and third party options are not safe to recommend.you can try exporting 50 columns in set and try merging the excel.
Sheet1:
Sheet 2:
Merged Sheet:In
In the above ,we are trying to merge to excel sheet using Merge Excel Smart Service,But the merge is not proper.Can you please provide a better way to handle it
At this point, your only option would be to revert to an API IMO.
Aspose makes one but there are others as well. You can try it out quickly here:
Only caveat is that the combined file will need to be less than 75mb.
Can you tell how many rows at max can be exported at a time ?If the number of rows exported are less, you can try Export DSE smart service's custom cell key & custom value parameter to fill the excel.AFAIK currently Appian has no OOTB option available for this use case.
Mathieu Drouin said:your only option would be to revert to an API IMO.
Why would that be their only option? The Export DSE to Excel node can be run several times consecutively, each time getting a different subset of the required columns.