asp.net把datagrid数据导出到excel

[medal_kucao]

datagrid的数据是通过数据源绑定的，不是绑定dataset之类的数据容器,怎么把所有的数据导出到excel?

[ron8291]

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

[ChengKing]

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

[cpp2017]

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(); }

[medal_kucao]

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