aasp.net 中Excel 导出

public string  OutPutExcel(System.Web.UI.Page page,DataTable myTable, string strTitle)
  {
   strMeno="";
   try
   {
    page.Response.Buffer= false;
    page.Response.Charset="UTF-8";
    page.Response.AppendHeader("Content-Disposition","attachment;filename="+ strTitle.Trim() +".xls");
    page.Response.ContentEncoding=System.Text.Encoding.GetEncoding("UTF-8");
    page.Response.ContentType ="application/ms-excel";
    System.IO.StringWriter   oSW   =   new   System.IO.StringWriter();
    HtmlTextWriter   oHW   =   new   HtmlTextWriter(oSW);
    DataGrid   dg   =   new   DataGrid();
    dg.DataSource = myTable;
    dg.ShowHeader = true;
    dg.HeaderStyle.BackColor=System.Drawing.Color.FromName("#D6DFF7");
    dg.HeaderStyle.HorizontalAlign=HorizontalAlign.Left;//标题居左对齐
    dg.HeaderStyle.Font.Bold=true;//标题字体加粗
    dg.HeaderStyle.Font.Size=FontUnit.XSmall;
    dg.DataBind();
    dg.RenderControl(oHW);
    page.Response.Write(oSW.ToString());
    page.Response.End();
   }
   catch(Exception Err)
   {
    strMeno=Err.Message;
    return strMeno;
   } 
   return strMeno;
  }