Export to excel Gridview or Repeater having 100000 records

Hi Saikiran,

You have to specify max row per sheet.

this is what are looking for . Read this :

http://www.codeproject.com/Tips/659666/Export-very-large-data-to-Excel-file

i gone through the links i can't get the proper solution exact problem is i have 100000 records in dataset i need to split them into multiple sheets if sheet1 is completed then slipt remaining records to sheet2 please give the exact solution with example...

regards
saikiran gst

Hi
saikiran gst

http://www.codeproject.com/Tips/659666/Export-very-large-data-to-Excel-file

http://stackoverflow.com/questions/3749372/when-exporting-more-then-500000-records-in-excel-using-c-sharp-net-it-gives-sys

http://www.linkedin.com/groups/how-export-more-than-65535-40949.S.136085812


Please Check The Above Link

U May Get Some Ideas

With Regards.....,
R.V.Rajagopalan

go throw 

http://www.codeproject.com/Tips/477436/Export-Gridview-Data-to-Excel-in-ASP-NET

http://surajdeshpande.wordpress.com/2013/09/01/export-gridview-data-to-excel-in-asp-net/