通过DataGrid导出xml文件流到Excel

#region DateGrid导出Excel文件
  private void ExportExcle()
  {   
   System.Xml.XmlDataDocument datadoc = new System.Xml.XmlDataDocument();
   datadoc.LoadXml("xml文件流");   
   //如果需要过滤节点，请在这里处理
   System.Xml.XmlNode node = datadoc.SelectSingleNode("/ICBCACSS/resultset");  
   if( node1 == null )
   {    return;
   }   

   System.Xml.XmlNodeReader reader = new System.Xml.XmlNodeReader(datadoc);
   System.Data.DataSet ds = new System.Data.DataSet();
   ds.ReadXml(reader);
   DataGrid1.DataSource = ds.Tables[0].DefaultView;
   DataGrid1.DataBind();
   Response.Clear();
   Response.Buffer = true;
   Response.Charset = "UTF-8";
   Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");
   Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");
   Response.ContentType = "application/ms-excel";
   this.EnableViewState = false;
   System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("zh-CN", true);
   System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
   System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
   this.DataGrid1.RenderControl(oHtmlTextWriter);
   Response.Write(oStringWriter.ToString());
   Response.End(); 
  }
  #endregion 

HTML里:

<asp:datagrid id="DataGrid1"  runat="server" AutoGenerateColumns="False">

<Columns>
     <asp:TemplateColumn HeaderText="数据日期">
      <ItemTemplate>
       <%#DataBinder.Eval(Container.DataItem,"此处为对应节点名")%>
      </ItemTemplate>
     </asp:TemplateColumn>

<asp:TemplateColumn HeaderText="与上同理">

 ......

 </asp:TemplateColumn>

</Columns>
</asp:datagrid>