Export to excel Gridview or Repeater having 100000 records

Question

Hi I need to export to excel from gridview or repeater having 100000 and above records in gridview or repeater if it possible please give reply the solution and with example Regards saikirangst

Rajagopalan R V · Answer

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

sudipta sanyal · Answer

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/

Anupam Singh · Answer

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

Saikiran Gst · Answer

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