GridView导出Excel文件(无乱码)

    技术2022-05-11  117

    gv_Test.AllowPaging = false;        GetData();    //绑定gv_Test数据,数据不能为空        Response.Clear();        Response.Buffer = true;        Response.AppendHeader("Content-Disposition", "attachment;filename=rptTelephonistWorkLoad.xls");  //弹出对话框;        //Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");  //设置输出流为简体中文

            Response.ContentEncoding = System.Text.Encoding.UTF7;

            Response.ContentType = "application/vnd.ms-excel";  //设置输出文件类型        System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);        System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);        System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);        oStringWriter.WriteLine("<div align=/"center/">标题</div>");        oStringWriter.WriteLine("<div>统计开始时间:" + Get_StartTime() + "</div>");        oStringWriter.WriteLine("<div>统计结束时间:" + Get_EndTime() + "</div>");        oStringWriter.WriteLine("<div>报表生成时间:" + DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString() + "</div>");        oStringWriter.WriteLine("<br />");        gv_Test.RenderControl(oHtmlTextWriter);        Response.Write(oStringWriter.ToString());        Response.End(); 

    还必须加以下方法:

    public override void VerifyRenderingInServerForm(Control control)    {        //base.VerifyRenderingInServerForm(control);    }


    最新回复(0)