Export To Excel in c#

Question

Hi All,

 

I need a help, We have an application which gives us data while search with a value.

 

so when we give a date range from start date and to end date,huge amount of data is coming into UI. Page gets freezed, so to avoid this we were used jquery table, lazy loading. After we implemented this lazy loading, data is coming with out any issues and page is not freezed. But our Project owner is asking to provide a Export To Excel functionality of that data and send it as excel to client via mail with an attachment,. Here the problem is how can we export such a huge amount of data a because excel support 10lakhs rows only and how can we send it via mail attachment.

 

We have data more than 10 lakhs for a given input and a given date range.

 

if we copied data to excel also it will take time and for opening it also will take time.

 

 

Can anyone please suggest your ideas to resolve our issue?  We are struggiling with this from last 3 months