GridView导入到Excel
本文是通过查看http://www.cnblogs.com/stswordman/archive/2006/08/24/485641.html的例子的修改,具体步骤看上面的链接就可以了
1
//绑定数据的部分
2
private void ExcelGridView()
3
{
4
Order order = new Order();//函数类
5![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
6
grdFOrderSearch.DataSource = order.QueryConsignList_FW();//查询函数
7
8
grdFOrderSearch.DataBind();
9
}
10
//在导出Excel中,移除GridView中用到控件,只以数据的形式导出
11
private void DisableControls(Control gv)
12
{
13
LinkButton lb = new LinkButton();
14
Literal l = new Literal();
15
string name = String.Empty;
16![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
17
for (int i = 0; i < gv.Controls.Count; i++)
18
{
19
if (gv.Controls[i].GetType() == typeof(LinkButton))
20
{
21
l.Text = (gv.Controls[i] as LinkButton).Text;
22
gv.Controls.Remove(gv.Controls[i]);
23
gv.Controls.AddAt(i, l);
24
}
25
else if (gv.Controls[i].GetType() == typeof(VesselLinkButton) //其中VesselLinkButton为自定义控件
26
{
27
l.Text = (gv.Controls[i] as VesselLinkButton).Text;
28
gv.Controls.Remove(gv.Controls[i]);
29
gv.Controls.AddAt(i, l);
30
}
31
else if (gv.Controls[i].GetType() == typeof(HyperLink))
32
{
33
l.Text = (gv.Controls[i] as HyperLink).Text;
34
gv.Controls.Remove(gv.Controls[i]);
35
gv.Controls.AddAt(i, l);
36
}
37
if (gv.Controls[i].HasControls())
38
{
39
DisableControls(gv.Controls[i]);
40
}
41![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
42
}
43![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
44
}
45![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
46
//此句不可少
47
public override void VerifyRenderingInServerForm(Control control)
48
{ }
49![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
50
protected void grdFOrderSearch_RowDataBound(object sender, GridViewRowEventArgs e)
51
{
52
if (e.Row.RowType == DataControlRowType.DataRow)
53
{
54
//正确显示以零开头的数据项
55
e.Row.Cells[1].Attributes.Add("style", "vnd.ms-excel.numberformat:@;");
56
e.Row.Cells[2].Attributes.Add("style", "vnd.ms-excel.numberformat:@;");
57
}
58
}
59![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
60
//导出到Excel,如有分页可以导出全部数据
61
protected void btnExcel_Click(object sender, EventArgs e)
62
{
63
64
Response.ClearContent();
65![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
66
Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls");
67![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
68
Response.ContentType = "application/excel";
69![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
70
StringWriter sw = new StringWriter();
71![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
72
HtmlTextWriter htw = new HtmlTextWriter(sw);
73![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
74
grdFOrderSearch.AllowPaging = false;
75![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
76
ExcelGridView();
77![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
78
DisableControls(grdFOrderSearch);
79![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
80
grdFOrderSearch.RenderControl(htw);
81![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
82
Response.Write(sw.ToString());
83![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
84
Response.End();
85![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
86
grdFOrderSearch.AllowPaging = true;
87![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
88
ExcelGridView();
89![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
90
}
91![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
如果有出现乱码的情况就加上这一句![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
4
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
5
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
6
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
7
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
8
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
9
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
10
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
11
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
12
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
13
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
14
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
15
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
16
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
17
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
18
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
19
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
20
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
21
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
22
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
23
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
24
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
25
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
26
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
27
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
28
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
29
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
30
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
31
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
32
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
33
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
34
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
35
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
36
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
37
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
38
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
39
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
40
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
41
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
42
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
43
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
44
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
45
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
46
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
47
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
48
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
49
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
50
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
51
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
52
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
53
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
54
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
55
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
56
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
57
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
58
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
59
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
60
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
61
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
62
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
63
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
64
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
65
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
66
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
67
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
68
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
69
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
70
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
71
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
72
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
73
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
74
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
75
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
76
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
77
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
78
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
79
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
80
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
81
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
82
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
83
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
84
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
85
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
86
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
87
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
88
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
89
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
90
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
91
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF7;