asp.net电子表格导出功能

最新推荐文章于 2022-03-09 19:35:31 发布

happyleo12

最新推荐文章于 2022-03-09 19:35:31 发布

阅读量261

点赞数

分类专栏： ASP.NET

本文链接：https://blog.csdn.net/happyleo12/article/details/52996057

版权

ASP.NET 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

cs文件后台代码段：

private void ExportDataTable(DataTable grd)
        {
            HttpContext.Current.Response.Clear();
            HttpContext.Current.Response.Buffer = true;
            HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
            HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment; filename=" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls");
            HttpContext.Current.Response.Write("<table border=1><tr bgcolor=#AAAAAA >");

            foreach (DataColumn item in grd.Columns)
            {
                HttpContext.Current.Response.Write("<th>" + item.ColumnName + "</th>");
            }

            HttpContext.Current.Response.Write("</tr>");

            foreach (DataRow row in grd.Rows)
            {
                string htmltable = "<tr>";
                for (int i = 0; i < grd.Columns.Count; i++)
                {
                    htmltable += "<td style='vnd.ms-excel.numberformat:@'>" + row[i].ToString() + "</td>";
                }
                htmltable += "</tr>";
                HttpContext.Current.Response.Write(htmltable);
            }
            HttpContext.Current.Response.Write("</table>");
            HttpContext.Current.Response.End();
        }