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't you just copy and paste?
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.
You will need to call the Export DSE to Excel node once for your first 50 columns, store the generated document ID and pass that in as the generation target for the next call where you will have it generate the next 50 columns, then call it a 3rd time in the same way to get the final 50. In each of the 3 nodes you will need to manually configure the Selection parameter to specify which columns you're asking it to pull for that round.
On nodes 2 and 3, you will need to specify a Starting Cell where you set it to column 51 (whatever column value that resolves to), and then for the final one, likewise to whatever the 101st column is named.