ExtAspNet从DataTable里导出Excel

2021-07-11 01:06

阅读：621

标签：file for tostring tab send net osi csharp app

 protected void btn_ToExcel_Click(object sender, EventArgs e)
    {
        Response.ClearContent();
        Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls");
        Response.ContentType = "application/excel";
        Response.Write(GetDataTableHtml((DataTable)ViewState["tt"]));
        Response.End();
    }


private string GetDataTableHtml(DataTable dt)
    {
        StringBuilder sb = new StringBuilder();
        sb.Append("

"); sb.Append(""); foreach (DataColumn column in dt.Columns) { sb.AppendFormat("", column.Caption); } sb.Append(""); foreach (DataRow row in dt.Rows) { sb.Append(""); for (int i = 0; i {0}", html); } sb.Append(""); } sb.Append("

{0}

"); return sb.ToString(); }

ExtAspNet从DataTable里导出Excel

标签：file for tostring tab send net osi csharp app

原文地址：http://www.cnblogs.com/tlnshuju/p/7087333.html

上一篇：学习11 网页插入图片标签

下一篇：css中三种定位详细介绍

文章来自：搜素材网的编程语言模块，转载请注明文章出处。
文章标题：ExtAspNet从DataTable里导出Excel
文章链接：http://soscw.com/essay/103481.html

亲，登录后才可以留言！

ExtAspNet从DataTable里导出Excel

评论

热门文章

推荐文章

最新文章

置顶文章