62,074
社区成员
发帖
与我相关
我的任务
分享
public void ExportToExcel(string Filename, GridView gridview, Page page)
{
gridview.EnableViewState = false;
gridview.AllowSorting = false;
gridview.AllowPaging = false;
//在这里把你不要的字段隐藏
DataTable temp = 这里的datatable是所有的数据,你取出来赋给temp
gridview.DataSource = temp;//重新绑定所有数据
gridview.DataBind();
page.Response.Clear();
page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
page.Response.AppendHeader("content-disposition", "attachment;filename=\"" + System.Web.HttpUtility.UrlEncode(Filename + DateTime.Now.ToShortDateString(), System.Text.Encoding.UTF8) + ".xls\"");
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gridview.RenderControl(htw);
page.Response.Write(sw.ToString());
page.Response.End();
}