datagrid到Excel Export [英] datagrid to Excel Export

问题描述

Hello Everybody，



我想在记录显示之前在公司详细信息中将2个数据网格数据导出到一张excel表格中。



PLZ我卡住了。帮助我。



感谢你。

Abdul

Hello Everybody,

I want to export 2 datagrid data in one excel sheet with company detail before record display.

plz i have stuck. help me out.

Thanking you.
Abdul

推荐答案

试试以下代码

try the following code

StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
Label lbl1=new Label1();
GridView gv1 = new GridView();
GridView gv2 = new GridView();
string fileName="abc.xls";
Response.Clear();
Response.Charset = "utf-8";
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment;filename=\"" + fileName + "\"");

Table table = new Table();
TableRow tr1 = new TableRow();
TableRow tr2 = new TableRow();
TableRow tr3 = new TableRow();
TableCell cell1 = new TableCell();
TableCell cell2 = new TableCell();
TableCell cell3 = new TableCell();

lbl1.Text="Company abc";

gv1.DataSource = data1;
gv1.DataBind();

gv2.DataSource = data2;
gv2.DataBind();

cell1.Controls.Add(lbl1);
tr1.Cells.Add(cell1);

cell2.Controls.Add(gv1);
tr2.Cells.Add(cell2);

cell3.Controls.Add(gv2);
tr3.Cells.Add(cell3);

table.RenderControl(htmlWrite);                
Response.Write(stringWrite.ToString());
Response.End();
htmlWrite.Dispose();
stringWrite.Dispose();
gv1.Dispose();
gv2.Dispose();

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