将DataTable导出为Excel

最新推荐文章于 2022-06-17 13:59:55 发布

weixin_30332241

最新推荐文章于 2022-06-17 13:59:55 发布

阅读量52

点赞数

CC 4.0 BY-SA版权

文章标签： ui

原文链接：http://www.cnblogs.com/EasyData/archive/2009/03/17/1414671.html

/// <summary>
/// 将DataTable中的数据导出到Excel文件中
/// </summary>
/// <param name="page">Web页面对象</param>
/// <param name="tab">包含被导出数据的DataTable对象</param>
/// <param name="FileName">Excel文件的名称</param>
public static void Export(System.Web.UI.Page page, System.Data.DataTable tab)
{
System.Web.HttpResponse httpResponse = page.Response;
System.Web.UI.WebControls.DataGrid dataGrid = new System.Web.UI.WebControls.DataGrid();
dataGrid.DataSource = tab.DefaultView;
dataGrid.AllowPaging = false;
dataGrid.HeaderStyle.BackColor = System.Drawing.ColorTranslator.FromHtml("#B5C7EF");
dataGrid.AlternatingItemStyle.BackColor = System.Drawing.ColorTranslator.FromHtml("#E0E0E0");
dataGrid.HeaderStyle.ForeColor = System.Drawing.ColorTranslator.FromHtml("#003399");
dataGrid.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
dataGrid.HeaderStyle.Font.Bold = true;
dataGrid.DataBind();

httpResponse.ClearContent();
httpResponse.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls");
httpResponse.ContentType = "application/excel";

System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);

dataGrid.RenderControl(htw);
page.Response.Write(sw.ToString());
page.Response.End();
}

转载于:https://www.cnblogs.com/EasyData/archive/2009/03/17/1414671.html