GridView 导出Excel(如何在excel中显示'0001'而不是'1')

1. GridView 导出Excel(如何在excel中显示'0001'而不是'1')
2. 在RowBound中添加
3.   if (e.Row.RowType == DataControlRowType.DataRow)
4.         {
5.             e.Row.Cells[1].Attributes.Add("style", "vnd.ms-excel.numberformat: @");
6.            
7.         }
8. 以上可以解决(如何在excel中显示'0001'而不是'1')的问题
10. 设公共变量 bool flag = false;
11.  protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
12.     {
13.        
14.         if (flag == true)
15.         {
16.             e.Row.Cells[this.GridView1.Columns.Count - 2].Visible = false;
17.            
18.         }
19. //可以解决导出时是否隐藏哪列的问题
20.     }
21.  protected void LinkButton1_Click(object sender, EventArgs e)
22.     {
23.         
24.         flag = true;//可以解决导出时是否隐藏哪列的问题
25.         Response.Clear();
26.         HttpContext.Current.Response.AppendHeader("Content-Disposition", 
28. "attachment;filename=" + "RedemptionReport.xls");
29.         Response.Charset = "UTF-8";
30.         Response.ContentEncoding = System.Text.Encoding.Default;
31.         Response.ContentType = "application/ms-excel"; 
32.         StringWriter stringWrite=new StringWriter(); 
33.         HtmlTextWriter htmlWrite=new HtmlTextWriter(stringWrite); 
35.         GridView1.AllowPaging=false;
36.         gridviewshow(str);  //重新绑定
37.         
38.         GridView1.RenderControl(htmlWrite); 
40.         Response.Write(stringWrite.ToString());
41.         Response.End();
42.         flag = false;  //可以解决导出时是否隐藏哪列的问题
43.         GridView1.AllowPaging=true;
44.         gridviewshow(str); //重新绑定
45.        
46.     }
47.     public override void VerifyRenderingInServerForm(Control control)
48.     {
49.         // Confirms that an HtmlForm control is rendered for
50.     } 
52. 在导出时改变Header
53. 在RowBound中
54.  if (e.Row.RowType == DataControlRowType.Header)
55.         {
57.             //***********************************************************
58.             GridViewRow row3 = new GridViewRow(-1, -1, DataControlRowType.Header, 
60. DataControlRowState.Normal);
61.             //for (int j = 0; j < 7; j++)
62.             //{
63.             TableCell cell30 = new TableCell();
64.             cell30.Text = "<b>Report:</b>";
65.             row3.Cells.AddAt(0, cell30);
67.             TableCell cell31 = new TableCell();
68.             cell31.Text = "New Loans By Deal";
69.             row3.Cells.AddAt(1, cell31);
71.             TableCell cell32 = new TableCell();
72.             cell32.Attributes["align"] = "right";
73.             cell32.Text = "<font style=/"text-align:right; font-
75. weight:bold;/">Date/Time:</font>";
76.             row3.Cells.AddAt(2, cell32);
77.             
80.             TableCell cell33 = new TableCell();
81.             cell33.Text = DateTime.Now.ToString("yyyy-MM-dd") + " " + 
83. DateTime.Now.ToString(@"HH:mm:ss");
84.             row3.Cells.AddAt(3, cell33);
86.             TableCell cell34 = new TableCell();
87.             cell34.Text = "";
88.             row3.Cells.AddAt(4, cell34);
90.             TableCell cell35 = new TableCell();
91.             cell35.Text = "";
92.             row3.Cells.AddAt(5, cell35);
94.             TableCell cell36 = new TableCell();
95.             cell36.Text = "";
96.             row3.Cells.AddAt(6, cell36);
98.             GridView2.Controls[0].Controls.AddAt(0, row3);
99. }