App_Code/Tool.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO; 
using System.Collections.Specialized;
using System.Text.RegularExpressions;

/// <summary>
///Tool 的摘要说明
/// </summary>
public class Tool: System.Web.UI.Page
{
	public Tool()
	{
		//
		//TODO: 在此处添加构造函数逻辑
		//
	}

    /// <summary>
    /// 导出Excel
    /// </summary>
    /// <param name="gv_FileList"></param>
    /// <param name="LastColumn"></param>
    public void ExportExcel(GridView gv_FileList, bool LastColumn)
    {
        Response.Clear();
        Response.Buffer = true;
        Response.Charset = "GB2312";
        string filename = DateTime.Now.Year.ToString() + DateTime.Now.Millisecond.ToString();
        Response.AppendHeader("Content-Disposition", "attachment;filename=" + filename + ".xls");
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");

        Response.ContentType = "application/ms-excel";
        this.EnableViewState = false;
        System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);

        if (LastColumn == false)
        {
            gv_FileList.Columns[gv_FileList.Columns.Count - 1].Visible = false;
        }
        gv_FileList.RenderControl(oHtmlTextWriter);
        Response.Write(oStringWriter.ToString());
        Response.End();


    }

}