(C#)asp.net(DataSet)导出Excel文件

1. public override void VerifyRenderingInServerForm(Control control)
2.     {
3.         //OverRide　为了使导出成Excel可行！
4.     }
5.     protected void CSVDownload_Click(object sender, EventArgs e)
6.     {
7.         Response.Clear();
9.         DataSet dsAnalysis1;
10.         dsAnalysis1 = creatdataset();
11.         GridView2.DataSource = dsAnalysis1.Tables[0].DefaultView;
12.         GridView2.DataBind();
13.         this.GridView2.Visible = true;
14.          Response.Clear();
16.         Response.Charset = "GB2312";
18.         Response.AddHeader("content-disposition", "attachment; filename=" + CSVfilename + "");
20.         Response.ContentEncoding = System.Text.Encoding.UTF8;
22.         Response.ContentType = "application/vnd.ms-excel.numberformat:@";
24.         System.IO.StringWriter stringWrite = new System.IO.StringWriter();
26.         System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
28.         GridView2.AllowPaging = false;
29.         GridView2.RenderControl(htmlWrite);
30.         stringWrite.ToString().Replace(",", "~");
31.         Response.Write(stringWrite.ToString().Replace(",", "~"));
32.         GridView2.Visible = false;
33.         Response.End();

1.     }
3.     protected void GridView2_RowDataBound(object sender, GridViewRowEventArgs e)
4.     {
5.         if (e.Row.RowType == DataControlRowType.DataRow)
6.         {
7.             for (int i = 0; i < e.Row.Cells.Count; i++)
8.             {
9.                 e.Row.Cells[i].Attributes.Add("style", "vnd.ms-excel.numberformat: @");
10.             }
11.         }
12.     }