【Vegas原创】GridView修改表头，并导出Excel(C#版)

2年前 (2022) 程序员胖胖胖虎阿

182 0 0

protected void btnExcel_Click(object sender, EventArgs e)
    {
        //绑定
        bindgrdExcel();
        //修改多行表头
        ModifygrdHeader();
        //导出Excel
        toExcelgrdExcel();

    }
    /// <summary>
    /// Response方法导出Excel，必须加的代码
    /// </summary>
    /// <param name="control"></param>
    public override void VerifyRenderingInServerForm(Control control)
    {
        // Confirms that an HtmlForm control is rendered for
    }
    /// <summary>
    /// 绑定grdExcel
    /// </summary>
    void bindgrdExcel()
    {
        DataSet ds = db.GetDataSet("procUtility_Excel");
        grdExcel.DataSource = ds.Tables[0];
        grdExcel.DataBind();
    }
    /// <summary>
    /// 导出Excel
    /// </summary>
    void toExcelgrdExcel()
    {
        Response.Clear();
        Response.Buffer = true;
        Response.Charset = "GB2312";
        Response.AppendHeader("Content-Disposition", "attachment;filename=Qty.xls");
        //如果设置为 GetEncoding("GB2312");导出的文件将会出现乱码！！！
        Response.ContentEncoding = System.Text.Encoding.UTF8;
        Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。

        System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
        System.Web.UI.Html32TextWriter oHtmlTextWriter = new Html32TextWriter(oStringWriter);

        grdExcel.RenderControl(oHtmlTextWriter);
        Response.Output.Write(oStringWriter.ToString());
        Response.Flush();
        Response.End();
    }
   /// <summary>
    /// 自定义多行表头
   /// </summary>
    void ModifygrdHeader()
    {
        try
        {

            this.grdExcel.HeaderRow.Cells.Clear();
            TableCell cell = new TableCell();
            cell.Text = "<tr  style='background-color: #006699;font-size: 15px;color: #FFFFFF;padding: 2pt;'><td rowspan='2' style='font-size=15px'>Customer</td><td  rowspan=2  style='font-size=15px'>" +
                         "Size</td><td rowspan='2'  style='font-size=15px'>TAC Film</td><td rowspan='2'  style='font-size=15px'>搭配性产品</td><td rowspan='2'  style='font-size=15px'>T/B</td><td rowspan='2'  style='font-size=15px'>Absorption Angle</td>" +
                         "<td rowspan='2'  style='font-size=15px'>Dimension_X</td><td rowspan='2'  style='font-size=15px'>Dimension_Y</td><td rowspan='2'  style='font-size=15px'>经济幅宽</td><td colspan='2'  style='font-size=15px'>1330mm</td><td colspan='2'  style='font-size=15px'>1475mm</td><td colspan='2'  style='font-size=15px'>2000mm</td>" +
                         "</tr><tr  style='background-color: #006699;font-size: 12px;color: #FFFFFF;padding: 2pt;'><td>片数/M</td><td>利用率</td><td>片数/M</td><td>利用率</td><td>片数/M</td><td>利用率</td>";

            this.grdExcel.HeaderRow.Cells.Add(cell);
        }
        catch (Exception e)
        {
            string url = Request.ApplicationPath + "/error.aspx?error=" + e.Message.ToString() + "&strurl=" + Request.Url.ToString() + "&way=gridheader";
            Response.Redirect(url);
        }
    }