How to generate excel using mvc with css and jquery

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:

2 Replies

Know the answer? Post it — somebody with the same question will find it here.