I have developed code to export data to Excel using Response.ContentType = "application/csv". The output Data Excel file loaded with 65536 Rows only, this file is not loaded completely since the limitation of excel is 65536. My Recordcount is more than 700000.
Please any one let me know how I can Export Data to Excel file over than 65536 Rows.
View Complete Post