C#中如何将GridView导出Excel
2011/6/23 15:14:51 类别:网络编程摘要:Asp.net(C#)中导出EXCEL方法 此方法调用代码 ExportToExcel(gridView1) gridView1为ID 添加到button事件
直接贴代码吧,C#(asp.net) 中实现将GridView 导出EXCEL 保存到本地。
private void ExportToExcel(GridView gridView)
{
//清空缓存
Response.Clear();
Response.Buffer = true;
//设置输出编码
Response.Charset = "GB2312";
Response.AppendHeader("Content-Disposition", "attachment;filename=ExcelName.xls");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.ContentType = "application/ms-excel";
//设置输出文件类型为excel文件。
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
gridView.RenderControl(oHtmlTextWriter);
Response.Output.Write(oStringWriter.ToString());
Response.Flush();
Response.End();
}
//补充实现代码(HTML部分)
//CodeBehind 代码
protected void btn_Ex_Click(object sender, EventArgs e)
{
ExportToExcel(Grird_ViewAll);
}
//解决导出EXCEL时报 类型“GridView”的控件必须放在具有 runat=server 的窗体标记 错误
public override void VerifyRenderingInServerForm(Control control)
{
// Confirms that an HtmlForm control is rendered for
}
