下载近半年的订单,60w左右,年中总结,多个运营同时下载,OOM系统崩溃。
尝试了easyExcel,还是有OOM现象发生。
问题1:速度慢
问题2:内存溢出
如何解决大数据量的Excel上传下载问题?
- 写回答
- 好问题 0 提建议
- 关注问题
- 邀请回答
-
3条回答 默认 最新
CSDN专家-Time 2021-10-08 17:57关注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解决 无用评论 打赏 举报