mavera
Reputation: 3241
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 you do it? I need some advice about this issue.
Upvotes: 0
Views: 5837
Answers (2)
honibis
Reputation: 811
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
Upvotes: 3
Related Questions
- Export a large SQL Server result to excel (Row Count = 1 Million) using c#
- How can I export very large amount of data to excel
- Export Large Data to Excel
- Exporting Data to Excel very Slow
- Export Sql data to Excel very slow
- How to export large data to Excel
- Export more than 100k data sql server to excel using C#
- Write large amount of data to Excel using C#, Asp.net
- Export large number of rows from SQL Server 2012 to Excel
- What is the best / fastest way to export large set of data from C# to excel