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.
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.