将gridview的数据导入excel
//导入Excel事件
protected void but_DRExcel_ServerClick(object sender, EventArgs e)
{
// 当前对话
System.Web.HttpContext curContext = System.Web.HttpContext.Current;
// IO用于导出并返回excel文件
System.IO.StringWriter strWriter = null;
System.Web.UI.HtmlTextWriter htmlWriter = null;
if (gdv_jiaoFei != null)
{
// 设置编码和附件格式
curContext.Response.ContentType = "application/vnd.ms-excel";
curContext.Response.ContentEncoding =System.Text.Encoding.UTF8;
curContext.Response.Charset = ""; //显示的字符串格式
//Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");
// 导出excel文件
strWriter = new System.IO.StringWriter();
htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);
// 返回客户端
gdv_jiaoFei.RenderControl(htmlWriter);
//curContext.Response.Write(strWriter.ToString());
if (GridView1 != null)
{
GridView1.RenderControl(htmlWriter);
}
curContext.Response.Write(strWriter.ToString());
curContext.Response.End();
}
}
//下面重写方法必不可少
public override void VerifyRenderingInServerForm(Control control)
{
}
本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/chenjianyong94/archive/2009/05/26/4216491.aspx