asp.net将GridView控件中的数据导出到Office(Excel,Word,PowerPoint)(源码)
asp.net将GridView控件中的数据导出到Office(Excel,Word,PowerPoint)
代码如下: #region 输出office
private void Export(string Filetype, string FileName)
{
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312";
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlDecode(FileName, Encoding.UTF8).ToString());
// 如果设置为 GetEncoding("GB2312");导出的文件将会出现乱码!!!
Response.ContentEncoding = System.Text.Encoding.UTF7;
Response.ContentType = Filetype;//设置输出文件类型。
StringWriter oStringWriter = new StringWriter();
HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);
gv.RenderControl(oHtmlTextWriter);
Response.Output.Write(oStringWriter.ToString());
Response.Flush();
Response.End();
}
#endregion
public override void VerifyRenderingInServerForm(Control control)
{
//base.VerifyRenderingInServerForm(control);
}
前台页面
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="excel.aspx.cs" EnableEventValidation="false" Inherits="将GridView导出到Excel_excel" %>
调用以上代码
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
Export("application/ms-excel", "dorm.xls");//输出Excel
}
