没有一步到位的方法吧。
用一个循环一条一条读:
myDataGrid.Item[i].Cell[j]=Excel.Cell(i,j);

解决方案 »

  1.   

    http://blog.csdn.net/ChengKing/category/292667.aspx
      

  2.   

    public static void ExportExcel(DataGrid rp, string strFileName)
    {
     
    strFileName = System.Web.HttpUtility.UrlEncode(strFileName,System.Text.Encoding.UTF8);

     
     
    System.Web.HttpContext.Current.Response.Clear(); 
    System.Web.HttpContext.Current.Response.Buffer = true; 
    System.Web.HttpContext.Current.Response.Charset = "gb2312";
    System.Web.HttpContext.Current.Response.AppendHeader("Content-Disposition", "online; filename=" + strFileName + ".xls");
    System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
    System.Web.HttpContext.Current.Response.ContentType = "application/ms-excel";
     
    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);
     
    rp.RenderControl(oHtmlTextWriter); 
     
    rp = null;
    System.Web.HttpContext.Current.Response.Write(oStringWriter.ToString().Replace("<td","<td STYLE='MSO-NUMBER-FORMAT:\\@'"));
    System.Web.HttpContext.Current.Response.Buffer = false; 
    System.Web.HttpContext.Current.Response.End();
    }
      

  3.   

    类型“DataGridLinkButton”的控件“ExcelDataGrid_ctl19_ctl01”必须放在具有 runat=server 的窗体标记内。