Download Data to Excel

Question

How to Download data to an Excel where a view has more than 150 columns?

Mathieu Drouin · Answer

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.

Mike Schmitt · Answer

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.

Mike Schmitt · Answer

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.