I'm trying to export 100,000+ rows to Excel from the data grid, and as expected, I'm running into OutOfMemoryException issues. That's understandable, and I've seen your help articles that recommend we use Reporting when that may be the case.
I want to avoid that, though, for simplicity. It's much more preferable for our users if they can just click an export button, specify a location to save it, and just fire and forget, no matter how big the data set is or how long it would take.
So, my question to you is, is it possible to append to an existing Excel file when exporting from the grid view? This way, I can request say 5,000 entities at once, put the objects in a data grid, export it to the file selected by the user, and then request the next set of entities. Rinse and repeat. I want to batch the requests, since requesting 100,000+ rows will likely lead to a timeout anyway, so this would be really convenient. All I've seen in all your documentation, though, requires overwriting the existing file.
If that's not possible, can you provide any guidance on how else we could export 100,000+ rows to Excel without resorting to Reporting, while still leveraging the data grid or RadSpreadsheet?