Create an excel file

excel.cs

string fileName = string.Empty;

var grid = new System.Web.UI.WebControls.GridView();

grid.DataSource = _db.spArtworkContentReport_ContentOnly_DI_Buyer(true, false).ToList();
fileName = "DataReport";
        
grid.DataBind();

Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=" + fileName + "_" + DateTime.Now.ToString() + ".xls");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);

grid.RenderControl(htw);

Response.Write(sw.ToString());
Response.End();