gridview 输出报表：

 gridview 输出报表：

    /// <summary>
    /// 绘出Excel格式
    /// </summary>
    private void ExportStyle()
    {
        //序号
        this.gvWorkList.Columns[0].HeaderStyle.Width = 40;
        this.gvWorkList.HeaderStyle.BackColor = Color.FromArgb(112, 112, 112); // "#666666";
        this.gvWorkList.HeaderStyle.ForeColor = Color.White;// "#FFFFFF";
        this.gvWorkList.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
        this.gvWorkList.BackColor = Color.FromArgb(224, 226, 236);
    }

    /// <summary>
    /// 导出功能
    /// </summary>
    /// <param name="FileName"></param>
    private void Export(string FileName, HttpResponse resp)
    {
        resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB18030");
        resp.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
        resp.ContentType = "application/vnd.ms-excel";
        this.EnableViewState = false;
        StringWriter tw = new StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(tw);
        //this.gvWorkList.RenderControl(hw);
        //resp.Write(tw.ToString());
        //resp.End();

        ExportStyle();

        this.gvWorkList.AllowPaging = false;
        //BindCondition(1, -1);
        BindData();
        this.gvWorkList.RenderControl(hw);
        Response.Write(tw.ToString());
        Response.End();
        this.gvWorkList.AllowPaging = true;
        BindData();
    }

 

/// <summary>
    /// Raises the button export excel event to export current data into excel.
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnExportExcel_Click(object sender, EventArgs e)
    {
        if (this.gvWorkList.Rows.Count > 0)
        {
            HttpResponse hr = System.Web.HttpContext.Current.Response;
            Export("Export_TrainingStatistics.xls", hr);
        }
        else
        {
            //WebUtility.ShowResultMessageBox(GetMessage("mychinabusiness", "TrainingStatistics", "NoSearch"), UpdatePanel1);
        }
    }