将大数据表导​​出到Excel [英] Exporting Large Datatable to 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屋！