The most efficient way to export large amount of data to excel

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 y开发者_运维问答ou do it? I need some advice about this issue.

---

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

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

---

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