将大数据表导出到Excel [英] Exporting Large Datatable to Excel
本文介绍了将大数据表导出到Excel的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好,
我正在尝试输出一个大号。数据到excel表(超过5965行和800列),但我得到系统内存不足异常。
System.OutOfMemoryException: 'System.OutOfMemoryException'类型的例外情况
可能是什么原因?我不能将这张表分成多张。有些机构可以建议我以正确的方式来解决这个问题。
任何帮助都会受到赞赏。
解决方案
我建议在封闭的xml中进行导出excel的简单方法
尝试这个..
https://closedxml.codeplex.com/ [ ^ ]
Documentaion
https://closedxml.codeplex.com/wikipage?title = Showcase& referTitle =文档 [ ^
Hello all,
I am trying to export a large no. of data to excel sheet(over 5965 rows and 800 columns),but i am getting System out of memory exception.
System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException'
What can be the reason? I can not split this sheet into multiple ones. Can some body suggest me the proper way in order to resolve this issue.
Any help would be appreciated.
解决方案
i suggest do it in closed xml its a easy way to export the excel
try this..
https://closedxml.codeplex.com/[^]
Documentaion
https://closedxml.codeplex.com/wikipage?title=Showcase&referringTitle=Documentation[^]
这篇关于将大数据表导出到Excel的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文