将大量数据导出为ex​​cel的最有效方法

If you had to get large amount data(nearly 230.000 rows) from database(I use oracle) to an excel file with asp.net, how would you do it? I need some advice about this issue.

如果你必须从数据库(我使用oracle)获取大量数据(接近230.000行)到asp.net的excel文件,你会怎么做?我需要一些关于这个问题的建议。

2 个解决方案

#1

You should consider using csv(Comma Separated Value) file format. It is very lightweight and supported by excel:

您应该考虑使用csv(逗号分隔值)文件格式。它非常轻巧,并且由excel支持:

http://creativyst.com/Doc/Articles/CSV/CSV01.htm

#2

I would suggest that you take a look at NPOI library.

我建议您看看NPOI库。