try { string excel_name = "Call-Log-(KBD/SWH)"; HttpContext.Current.Response.Clear(); // HttpContext.Current.Response.ClearContent() // HttpContext.Current.Response.ClearHeaders() HttpContext.Current.Response.Buffer = true; HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"; HttpContext.Current.Response.Write("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\">"); HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=" + excel_name + "(" + System.DateTime.Now + ").xls"); HttpContext.Current.Response.Charset = "utf-8"; HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("windows-1250"); //sets font HttpContext.Current.Response.Write("<font style="font-size: 10.0pt; font-family: Calibri">"); HttpContext.Current.Response.Write("<br><br><br>"); //sets the table border, cell spacing, border color, font of the text, background, foreground, font height HttpContext.Current.Response.Write(""); //am getting my grid's column headers int columnscount = GridView1.Columns.Count; for (int j = 0; j <= columnscount - 1; j++) { //write in new column HttpContext.Current.Response.Write(""); } HttpContext.Current.Response.Write(""); foreach (DataRow row in table.Rows) { //write in new row HttpContext.Current.Response.Write(""); for (int i = 0; i <= table.Columns.Count - 1; i++) { HttpContext.Current.Response.Write(""); } HttpContext.Current.Response.Write(""); } HttpContext.Current.Response.Write("<table border="1" cellspacing="0" cellpadding="0"> <tbody><tr><td>"); //Get column headers and make it as bold in excel columns HttpContext.Current.Response.Write(""); HttpContext.Current.Response.Write(GridView1.Columns(j).HeaderText.ToString()); HttpContext.Current.Response.Write(""); HttpContext.Current.Response.Write("</td></tr><tr><td>"); HttpContext.Current.Response.Write(row(i).ToString()); HttpContext.Current.Response.Write("</td></tr></tbody></table>"); HttpContext.Current.Response.Write("</font>"); HttpContext.Current.Response.Flush(); HttpContext.Current.Response.End(); } catch (Exception ex) { }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
Submit an article or tip