如何将批量数据导出到Excel [英] How to export bulk data to excel

问题描述

我在sqlserver中有大约80到90列的表，它的数据大约在800000到900000之间，我需要使用asp.net和c＃将数据导出到400000左右。



我曾尝试使用Open-XML DOM方法从数据集导出数据，但它会挂起系统并在某些时候出现Memory Out of Bound错误。



可以将数据从sqlserver导出到Microsoft excel 2007/2010的任何其他方法，OpenXML sdk能够将大量数据导出到excel，任何教程或示例都会有很大帮助。

I have table in sqlserver having around 80 to 90 columns and it has data around 800000 to 900000, i need to export data around 400000 to excel using asp.net and c#.

I have tried to export data from dataset using Open-XML DOM method, but it will hangup the system and got Memory Out of Bound error at some point.

can any other method which will export data from sqlserver to Microsoft excel 2007/2010, can OpenXML sdk is capable to export large amount of data to excel, any tutorial or example will help a lot.

推荐答案

您需要将数据分解为更小的集合。请参阅 http://office.microsoft.com/en-gb /excel-help/excel-specifications-and-limits-HP005199291.aspx [ ^ ]对于Excel的大小限制。

You need to break your data down into smaller sets. See http://office.microsoft.com/en-gb/excel-help/excel-specifications-and-limits-HP005199291.aspx[^] for size limits of Excel.

这篇关于如何将批量数据导出到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！