Kendo export to excel

Question

Hi I am using mvc 5 in that i need to export the records into excel. it works fine. there is 30 000 records i need to export into excel now its not working. I am using kendo. Thanks.

Dhanunjay Jajimoggla · Answer

Please check once your client side script. Because IE not supported for some script property's...

neel k · Answer

This code works fine Chrome but not working in IE. What's wrong in this code. public ActionResult Index() { return View(db.tbl_GR_Reports.ToList()); } public ActionResult ExportData() { GridView gv = new GridView(); gv.DataSource = db.tbl_GR_Reports.ToList(); gv.DataBind(); Response.ClearContent(); Response.Buffer = true; Response.AddHeader(content-disposition attachment; filename=list.xls); Response.ContentType = application/ms-excel; Response.Charset = ; StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); gv.RenderControl(htw); Response.Output.Write(sw.ToString()); Response.Flush(); Response.End(); return RedirectToAction(tbl_GR_Reports); }

Dhanunjay Jajimoggla · Answer

Hi neel k I understand what is your problem But there no chance to export the that much of records with our local pc configurations because that's depends on the systems performance also. For your problem you must export the page by page records. Thank You.