如何解决大数据量的Excel上传下载问题？

Question

下载近半年的订单，60w左右，年中总结，多个运营同时下载，OOM系统崩溃。
尝试了easyExcel,还是有OOM现象发生。
问题1：速度慢
问题2：内存溢出

Answer 1

c# .net可以参考openxml.

如何实现...(Open XML SDK) | Microsoft Docs Use the Open XML SDK to programmatically create Office Word, Excel, and PowerPoint documents, and manipulate their content. https://docs.microsoft.com/zh-cn/office/open-xml/how-do-i

java的话,你可能需要分批次进行处理。
这是大规模读写excel的方法。

c# - reading a large open xml spreadsheet - Stack Overflow i need to read (and parse) large spreadsheet files (20-50MB) using the openxml libraries and there doesn't seem to be a way to stream the rows one at a time for parsing. i'm consistently getting ... https://stackoverflow.com/questions/2061838/reading-a-large-open-xml-spreadsheet

How to Create Large Excel File using Openxml - CodeProject https://www.codeproject.com/Articles/877791/How-to-Create-Large-Excel-File-using-Openxml

10万行数据秒级写