DataTable 导出到Excel 的简单实现（非NPOI）

最新推荐文章于 2024-05-15 16:51:54 发布

lennie_1112

最新推荐文章于 2024-05-15 16:51:54 发布

阅读量544

点赞数

分类专栏：日常记录

本文链接：https://blog.csdn.net/qq_28522783/article/details/80428254

版权

日常记录专栏收录该内容

23 篇文章 0 订阅

订阅专栏

        /// <summary>
        /// 导出Excel Datatable版本
        /// </summary>
        public static void ExportByWeb()
        {
            DataTable dt = new DataTable("cart");
            DataColumn dc1 = new DataColumn("prizename");
            DataColumn dc2 = new DataColumn("point");
            DataColumn dc3 = new DataColumn("number");
            DataColumn dc4 = new DataColumn("totalpoint");
            DataColumn dc5 = new DataColumn("prizeid");
            dt.Columns.Add(dc1);
            dt.Columns.Add(dc2);
            dt.Columns.Add(dc3);
            dt.Columns.Add(dc4);
            dt.Columns.Add(dc5); 
            for (int j = 0; j < 10; j++)
            {
                DataRow dr = dt.NewRow();
                dr["prizename"] = "从飒飒的阿斯达";
                dr["point"] = "从飒飒的阿斯达从飒飒的阿斯达从飒飒的阿斯达从飒飒的阿斯达从飒飒的阿斯达从飒飒的阿斯达从飒飒的阿斯达从飒飒的阿斯达从飒飒的阿斯达";
                dr["number"] = "123123123";
                dr["totalpoint"] = "0啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊01";
                dr["prizeid"] = "001";
                dt.Rows.Add(dr);
            }
            HttpResponse resp = System.Web.HttpContext.Current.Response;
            string ExcelName = DateTime.Now.ToString("yyyyMMddHHmmss");//文件名
            resp.ContentEncoding = Encoding.UTF8;
            resp.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(ExcelName, Encoding.UTF8) + ".xls");
            DataRow[] myRow = dt.Select();
            int k = 0;
            int cl = dt.Columns.Count;
            StringBuilder sb = new StringBuilder();
            sb.Append("<html><head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" /></head><body>");
            sb.Append("<table><tr style='Gray 1px solid;text-align:center'>");
            for (int x = 0; x < cl; x++)
            {
                sb.Append("<td   bgcolor='#ABCDC1' style='vnd.ms-excel.numberformat:@;width:200px' >" + dt.Columns[x].ColumnName + "</td>");//列名
            }
            sb.Append("</tr>");

            foreach (DataRow row in myRow)
            {
                sb.Append("<tr>");
                for (k = 0; k < cl; k++)
                {
                    if (k == (cl - 1))
                        sb.Append("<td style='vnd.ms-excel.numberformat:@;width:200px'>" + row[k].ToString() + "</td></tr>");
                    else
                    {
                        if (k == 2)
                            sb.Append("<td style='vnd.ms-excel.numberformat:@;width:200px'>" + " " + row[k].ToString() + "</td>");
                        else
                            sb.Append("<td style='vnd.ms-excel.numberformat:@;width:200px' >" + row[k].ToString() + "</td>");
                    }
                }
            }
            sb.Append("</table></body></html>");
            resp.Write(sb.ToString());
            resp.End();
        }

//vnd.ms-excel.numberformat 导出Ecxel 格式
<td style="vnd.ms-excel.numberformat:@;"><s:property value="accountCode" /></td>

//1）文本：vnd.ms-excel.numberformat:@
//2）日期：vnd.ms-excel.numberformat:yyyy/mm/dd
//3）数字：vnd.ms-excel.numberformat:#,##0.00
//4）货币：vnd.ms-excel.numberformat:￥#,##0.00
//5）百分比：vnd.ms-excel.numberformat: #0.00%

<fmt:formatNumber value="${(money / lastMoney - 1) * 100 }" pattern="#.##%" minFractionDigits="2" />

<fmt:formatNumber value="${n_balance}" pattern="#.##" minFractionDigits="2"/>

导出的简单效果图，可用作平时测试用，实际项目中，推荐使用NPOI进行操作

lennie_1112

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
DataTable 导出到Excel 的简单实现（非NPOI）

/// &amp;amp;amp;amp;lt;summary&amp;amp;amp;amp;gt; /// 导出Excel Datatable版本 /// &amp;amp;amp;amp;lt;/summary&amp;amp;amp;amp;gt; public static void NewExportExcelScore() { DataTable dt = n
复制链接

扫一扫

专栏目录