在gridview中将Gridview导出到Excel [英] Export Gridview Within gridview to excel

问题描述

我在那7列中使用了一个gridview ..在第7列中我使用了另一个gidview.但是问题是我想在excel中显示此gridview.但是在excel中，它仅显示第7列的外部网格nag为0. .so我也想显示7列网格..在第7列gridview中，我取三列并显示相关数据..plz帮助我

I take one gridview.in that 7 columns..in 7th column i take another gidview.but problem is i want to show this gridview in excel..but in excel it shows only outer grid nag 7 th column is 0..so i want to show 7 column grid also..in 7th column gridview i take three columns and show related data..plz help me

推荐答案

hi
检查一下

hi
check it out

public void ExportToExcel(DataTable dt)
    {
            con.Open();
            string sql = "select *from test";
            cmd = new SqlCommand(sql, con);
            dt = new DataTable();
            da = new SqlDataAdapter(cmd);
            da.Fill(dt);
            GridView1.DataSource = dt;
            GridView1.DataBind();
            cmd.Dispose();


            string filename = "DownloadTest.xls";
            System.IO.StringWriter tw = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
            DataGrid dgGrid = new DataGrid();
            dgGrid.DataSource = dt;
            dgGrid.DataBind();

            dgGrid.RenderControl(hw);
            
            Response.ContentType = "application/vnd.ms-excel";
            Response.AppendHeader("Content-Disposition", "attachment; filename=" + filename + "");
            this.EnableViewState = false;
            Response.Write(tw.ToString());
            Response.End();


            con.Close();
    }

嘿，查看本文，您可能会在这里找到答案:
9将数据导出到Excel for ASP的解决方案. NET [ ^ ]

Hey, check this article, you may find answer here:
9 Solutions to Export Data to Excel for ASP.NET[^]

这篇关于在gridview中将Gridview导出到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！