How to generate excel using mvc with css and jquery

Question

I want to generate excel in form of my design i try but it not working.

Kapil Bhati · Answer

make this action in your controller. public void Export_ExcelFile() { var sb = new StringBuilder(); var data = from s in edm.table //where (s.UserType != 3 && s.UserType != 2) select new { s.LoginId, s.Password, s.Company_Name, s.F_Name, s.L_Name, s.Email, s.Address, s.City, s.State, s.phone,s.mobile }; var list = data.ToList(); var grid = new System.Web.UI.WebControls.GridView(); grid.DataSource = list; grid.DataBind(); string filename = string.Format("{0}", DateTime.Now.ToString("g").Replace("/", "-").Replace(":", "_").Replace(" ", "-")); filename = "UserList_" + filename + ".xls"; Response.ClearContent(); Response.AddHeader("content-disposition", "attachment; filename="+filename+""); Response.ContentType = "application/vnd.ms-excel"; StringWriter sw = new StringWriter(); System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw); grid.RenderControl(htw); Response.Write(sw.ToString()); Response.End(); } and in view write this code:

Sundaram Subramanian · Answer

http://growingtech.blogspot.in/2012/10/export-html-to-excel-using-jquery-and.html http://jsfiddle.net/jqwidgets/6HRU8/ http://www.aspdotnet-pools.com/2015/03/aspnet-mvc-export-data-to-excel-file-of.html Follow these links, you may get an Idea, Thanks in advance

How to generate excel using mvc with css and jquery

Answers (2)