protected void img_ExportToExcel3_Click(object sender, ImageClickEventArgs e) { DataTable dt = FRB.ListAllProf(); if (dt.Rows.Count > 0) { GridView3.DataSource = dt; GridView3.DataBind(); try { var pck = new OfficeOpenXml.ExcelPackage(); var ws = pck.Workbook.Worksheets.Add("ProfInfoList"); //foreach (var dt. in collection) //{ //} ws.Cells["A1"].LoadFromDataTable(dt, true); Response.Clear(); Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AddHeader("content-disposition", "attachment; filename=ProfInfoList.xlsx"); Response.BinaryWrite(pck.GetAsByteArray()); //dt.Columns.Add("StudentID", typeof(int)); //dt.Columns.Add("StudentName", typeof(string)); //dt.Columns.Add("RollNumber", typeof(int)); //dt.Columns.Add("TotalMarks", typeof(int)); } catch (Exception ex) { //log error } Response.End(); // Response.Clear(); // Response.Buffer = true; // Response.AddHeader("content-disposition", "attachment;filename=ReportListAllProf.xls"); // Response.Charset = ""; // Response.ContentType = "application/vnd.ms-excel"; // using (StringWriter sw = new StringWriter()) // { // HtmlTextWriter hw = new HtmlTextWriter(sw); // //To Export all pages // ////gv_Show.AllowPaging = false; // ////this.BindGrid(); // //gv_Show.HeaderRow.BackColor = Color.White; // foreach (TableCell cell in GridView3.HeaderRow.Cells) // { // cell.BackColor = GridView3.HeaderStyle.BackColor; // } // foreach (GridViewRow row in GridView3.Rows) // { // //row.BackColor = Color.White; // foreach (TableCell cell in row.Cells) // { // if (row.RowIndex % 2 == 0) // { // cell.BackColor = GridView3.AlternatingRowStyle.BackColor; // } // else // { // cell.BackColor = GridView3.RowStyle.BackColor; // } // cell.CssClass = "textmode"; // } // } // GridView3.RenderControl(hw); // //style to format numbers to string // string style = @"<style> .textmode { } </style>"; // Response.Write(style); // Response.Output.Write(sw.ToString()); // Response.Flush(); // Response.End(); // } } }