GridView导出Excel（解决Excel空白没有网格）代码,Asp.Net代码库,德仔网

代码语言

代码分类

【Asp.Net】 GridView导出Excel（解决Excel空白没有网格）

作者:Dezai.CN / 发布于2011/12/27/ 806

收录一种GridView导出Excel的方法，也是网上最常见的一种，但导出的Excel出现背景空白没有网格现象，后来明白这种方法不是真正的导出Excel，实际上是html，只是用Excel打开罢了

<div>private void toexcel(string title)</div>
{
GridView1.AllowPaging = false;   //先锁定分页
        string sqlstr1 =  "select * from HouseApp where YGS_Time is null";
         CAN.ExecGridViewBind(GridView1, sqlstr1);
//这里要绑定数据，这是我的方法，请写成你自己的
        Response.Clear();
Response.Buffer = false;
        Response.Charset =  "utf-8";
        Response.AppendHeader("Content-Disposition",  "attachment;filename=" + HttpUtility.UrlEncode(title) + ".xls");
         Response.ContentEncoding = System.Text.Encoding.UTF8;
         Response.ContentType = "application/ms-excel";
         Response.Write("<meta http-equiv=Content-Type content=\"text/html;  charset=utf-8\">");
        this.EnableViewState = false;
         System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
         HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);
         GridView1.RenderControl(oHtmlTextWriter);// 数字字符导Excel后转Text格式，否则前面的 0  字符会自动舍弃
        Response.Write(AddExcelHead());
         Response.Write(oStringWriter.ToString());
         Response.Write(AddExcelbottom());
        Response.End();

GridView1.AllowPaging = true;     //恢复分页
         //为GridView重新绑定数据源
        string sqlstr = "select * from HouseApp where  YGS_Time is null";
        CAN.ExecGridViewBind(GridView1, sqlstr);
     }
protected void Button1_Click(object sender, EventArgs e)
    {
         toexcel("文件名");
    }
    public static string AddExcelHead()
     {
        StringBuilder sb = new StringBuilder();
         sb.Append("<html  xmlns:x=\"urn:schemas-microsoft-com:office:excel\">");
        sb.Append("  <head>");
        sb.Append(" <!--[if gte mso  9]><xml>");
        sb.Append("<x:ExcelWorkbook>");
         sb.Append("<x:ExcelWorksheets>");
         sb.Append("<x:ExcelWorksheet>");
         sb.Append("<x:Name></x:Name>");
         sb.Append("<x:WorksheetOptions>");
         sb.Append("<x:Print>");
        sb.Append("<x:ValidPrinterInfo  />");
        sb.Append(" </x:Print>");
         sb.Append("</x:WorksheetOptions>");
         sb.Append("</x:ExcelWorksheet>");
         sb.Append("</x:ExcelWorksheets>");
         sb.Append("</x:ExcelWorkbook>");
         sb.Append("</xml>");
         sb.Append("<![endif]-->");
        sb.Append("  </head>");
        sb.Append("<body>");
        return  sb.ToString();
    }
    public static string AddExcelbottom()
     {
        StringBuilder sb = new StringBuilder();
         sb.Append("</body>");
        sb.Append("</html>");
         return sb.ToString();
    }
//重新下面方法解决错误：类型GridView的控件GridView1必须放置在具有runat=server的窗体标记内
public override void VerifyRenderingInServerForm(Control control)
     {
}

试试其它关键字

　导出Excel　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)