如何在不同的Excel工作表中显示datagrid [英] How do i show datagrid in different excel sheet

问题描述

hye，我如何在不同的excel表中显示datagrid。这里是我已经制作的代码，但它在同一张表格中显示了两个gridview。

hye, How do i show datagrid in different excel sheet. here the code that i have already made but it show both gridview in the same sheet.

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

        Response.AddHeader("content-disposition",
         "attachment;filename=GridViewExport.xls");
        Response.Charset = "";
        Response.ContentType = "application/vnd.ms-excel";
        StringWriter sw = new StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(sw);
        //------------------------------------------------------------------------------
        GridView1.AllowPaging = false;
        GridView1.DataBind();

        //Change the Header Row back to white color
        GridView1.HeaderRow.Style.Add("background-color", "#FFFFFF");


        GridView1.RenderControl(hw);
        //----------------------------------------------------------------------------------
        GridView2.AllowPaging = false;
        GridView2.DataBind();

        //Change the Header Row back to white color
        GridView2.HeaderRow.Style.Add("background-color", "#FFFFFF");


        GridView2.RenderControl(hw);
        //---------------------------------------------------------------------------------
        //style to format numbers to string
        string style = @"<style> .textmode { mso-number-format:\@; } </style>";
        Response.Write(style);
        Response.Output.Write(sw.ToString());
        Response.Flush();
        Response.End();

推荐答案

参考 - Re：将两个gridview导出到两个相同excel文件的不同工作表 [ ^ ]。

这篇关于如何在不同的Excel工作表中显示datagrid的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！