GridView 导出Excel支持office2007代码,Asp.Net代码库,德仔网

代码语言

代码分类

【Asp.Net】 GridView 导出Excel支持office2007

作者:zgke / 发布于2014/7/29/ 928


	public void SaveToExcel(GridView _gv,Page _page)
	{
	_page.Response.Clear();
	_page.Response.Buffer = true;
	_page.Response.Charset = "GB2312";
	_page.Response.Write("<meta http-equiv=Content-Type content=text/html;charset=GB2312>");
	_page.Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");
	_page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
	_page.Response.ContentType = "application/vnd.xls";//设置输出文件类型为excel文件。
	System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
	System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
	_gv.RenderControl(oHtmlTextWriter);
	_page.Response.Output.Write(oStringWriter.ToString());
	_page.Response.Flush();
	_page.Response.End();

	}

试试其它关键字

　导出Excel　

同语言下

可能有用的

zgke贡献的其它代码(46)