Exporting large data to excel from c#
===

I am using Mssql to store my data. After then I want to extract data came from sql to excel and send to user. User will be able to download that excel. I have found a lot of resources to extract data to excel. But my problem is that my data is too big. It has 85 columns and up to 80 000 rows. Teherefore it is too slow to extract even I am working on local. I think when I begin to serve online the system will be so slow. I am using two methods: By adding com reference to the project and seconly vnd.ms-excel method. First one opens the excel file quickly but it exracts so slowly and the second method extracts