读书人

Gridview B/S 导出到Excel 会讲的来~

发布时间: 2012-06-05 13:54:06 作者: rapoo

Gridview B/S 导出到Excel 会讲的来~会翻译的GO GO GO!

第一题:找人详细翻译一下 下面每句话的作用函数的作用 gridview导出到Excel(下面的功能能实现汉字无乱码)

C# code
//下面代码将gridview导出到excel#region   //将某天的详细数据导出到EXCEL    protected void Button3_Click(object sender, EventArgs e)    {        Response.Clear();        Response.Buffer = false;        Response.Charset = "GB2312";        Response.AppendHeader("Content-Disposition", "attachment;filename=pkmv_de.xls");        Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");        Response.ContentType = "application/ms-excel";        Response.Write("<meta http-equiv=Content-Type content=\"text/html; charset=GB2312\">");        this.EnableViewState = false;        System.IO.StringWriter oStringWriter = new System.IO.StringWriter();        HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);        GridView2.RenderControl(oHtmlTextWriter);        Response.Write(oStringWriter.ToString());        Response.End();    } public override void VerifyRenderingInServerForm(Control control)    {        //base.VerifyRenderingInServerForm(control);    }    #endregion




--------------继续提问---------------
Gridview有分页会导致数据溢出;
怎么在又分页的情况下 导出所有数据 和部分数据 有的请支招;
如果有能判断出导出数据的行 列 Gridview详细信息更佳! 分数给追加 哦!



[解决办法]
Response.Write("<meta http-equiv=Content-Type

content=\"text/html; charset=GB2312\">");
这个去掉,你是哪几句不懂,懒得全部备注.关键的几句跟你说下
Response.Charset = "GB2312";//这个编码你应该是知道的
Response.AppendHeader("Content-Disposition", "attachment;filename=pkmv_de.xls");//告诉浏览器是下载
Response.ContentType = "application/ms-excel";//告诉浏览器下载为excel格式

读书人网 >asp.net

热点推荐