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.

Sundar · 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

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.phones.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: