Export Large Dataset To Excel

[Carl Herlitz]

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?

[Carl Herlitz]

So, nevermind that last question... Turns out this approach doesn't work really well. Performance is terrible.

I instead started using your RadSpreadStreamProcessing library, but I'm still running into OutOfMemoryExceptions for 100,000+ rows. I'm trying to figure out what the issue is. Do you happen to know if there's a limit to the number of rows you can write to Excel using RadSpreadStreamProcessing? Your demo only goes up to 50K rows, but I haven't seen anything in your documentation that specifies if there's a limit or not.

[Carl Herlitz]

You can probably just delete this thread. At this point, I'm 99% sure the out of memory issue is with Entity Framework, not RadSpreadStreamProcessing. Unless you know of a hard limit with that library, just delete.