导出表格EXCEL____备忘

最新推荐文章于 2024-02-18 18:14:24 发布

weixin_30814223

最新推荐文章于 2024-02-18 18:14:24 发布

阅读量83

点赞数

原文链接：http://www.cnblogs.com/zccokie/archive/2010/08/19/1803501.html

版权

1,首先复制下面的代码至要导出EXCEL页面.调用ExportToExcel('table的ID','要导出EXCEL的名称')即可.

代码

2.然后再创建一个ExcelTransfer.aspx页面,aspx.cs代码如下

代码

using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class ExcelTransfer : System.Web.UI.Page
{
protected void Page_Load( object sender, EventArgs e)
{
string strContent = Request[ " content " ];

if ( string .IsNullOrEmpty(strContent))
return ;

string strFileName = Request[ " fileName " ];

if ( string .IsNullOrEmpty(strFileName))
{
strFileName = " 导出表格数据 " ;
}

Response.Clear();
Response.Buffer = true ;

Response.Charset = System.Text.Encoding.UTF8.WebName;
Response.AppendHeader( " Content-Disposition " , " attachment;filename= " + Server.UrlEncode(strFileName) + " .xls " );
Response.ContentEncoding = System.Text.Encoding.GetEncoding( " gb2312 " );
Response.ContentType = " application/ms-excel " ;
this .EnableViewState = false ;
Response.Write( " <html><head><meta http-equiv=\ " content - type\ " content=\ " text / html; charset = utf - 8 \ " /></head><body> " + strContent + " </body></html> " );
// Response.Write(strContent);
Response.End();

}
}

Over....

转载于:https://www.cnblogs.com/zccokie/archive/2010/08/19/1803501.html