<div>
<div class="content wysiwyg-content">
I have a web app which needs to allow users to save dataset to a Excel file to their desktop. &nbsp;There are many solutions online to export dataset to excel. &nbsp;Does anybody know, from performance point of view, which way is better when dataset is very large, (close to Excel limit - about 63000 rows)? &nbsp;<br />
<br />
Any suggestions and comments will be highly appreciated.
</div>
</div>


I have a web app which needs to allow users to save dataset to a Excel file to their desktop.  There are many solutions online to export dataset to excel.  Does anybody know, from performance point of view, which way is better when dataset is very large, (close to Excel limit - about 63000 rows)?  

Any suggestions and comments will be highly appreciated.

export large amount of data to Excel

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications