如何将5,00,000条记录导出为ex​​cel [xls]格式 [英] how to export 5,00,000 records into excel [xls] format

问题描述

先生，

告诉我将5,00,000条记录导出为ex​​cel [xls excel 2003格式]的步骤。我能够导出65,536行。





如果我输出5,00,000条记录，我会收到系统内存异常，请给我解决这个问题的方法。

Hi sir,
Tell me the steps to export 5,00,000 records into excel [xls excel 2003 format]. I can able to export 65,536 rows.


If i export 5,00,000 records, i am getting System out of memory exception, Kindly give me the solution for this problem.

推荐答案

由于行限制 [ ^ ]。

您可以将其导出到* .csv文件中。看看：

http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/2fd020c9-4cc9-4f76-8fc8-d91383c85782/ [ ^ ]



也可以参考类似的讨论：

这里 [ ^ ]



..以及更多主题：此处 [ ^ ]

You can't export 5,00,000 records into Excel Spreadsheet, because of rows limitation[^].
You can export it into *.csv file. Take a look at:
http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/2fd020c9-4cc9-4f76-8fc8-d91383c85782/[^]

Also refer similar discussion:
here[^]

..and even more threads: here[^]

Hello Prabu，



单个工作表最多可容纳65,536行（参见这个 [ ^ ]）。在达到最大限制后，您必须更改逻辑以插入更多工作表，或者simplay将数据作为包含65536行的csv文件进行探测。



问候，

Hello Prabu,

A single worksheet can hold at the max 65,536 rows (See this[^]). You will have to change your logic to insert more worksheets after the max limit is reached or simplay explort data as csv file(s) each containing 65536 rows.

Regards,

你不能因为xls总共限制在65536行。您需要将其分成不同的表格或使用xlsx。其他简单的选择是导出到csv，尽管它可能不会在所有版本的excel中打开。但出口会成功。



祝你好运！

You can't because xls is restricted to 65536 rows in total. You would need to devide it into different sheets or use xlsx instead. Other simple option would be to export to csv although it might not open in all versions of excel either. But exporting would succeed.

Good luck!

这篇关于如何将5,00,000条记录导出为ex​​cel [xls]格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！