js导出excel

最新推荐文章于 2021-12-28 10:36:28 发布

nathan_Shao

最新推荐文章于 2021-12-28 10:36:28 发布

阅读量408

点赞数

分类专栏：前端文章标签： js

本文链接：https://blog.csdn.net/yan5136970/article/details/76718515

版权

前端专栏收录该内容

3 篇文章 0 订阅

订阅专栏

本文介绍了一种使用JavaScript将数据导出为Excel表格的方法。通过构造特定的HTML结构并利用浏览器特性完成文件下载，实现了将JSON数据转换为Excel文件的功能。文章详细展示了如何设置单元格格式，并提供了完整的代码示例。

摘要由CSDN通过智能技术生成

//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"/>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <script type="text/javascript" src="js/jquery-1.11.1.min.js"></script>
    <script type="text/javascript">
        $(document).ready(function(){
            $('#wwo').click(function(){ //, {"value":"日期", "type":"ROW_HEADER_HEADER", "datatype":"string"}
                var data = {"title":[{"value":"集团", "type":"ROW_HEADER_HEADER", "datatype":"string"}],"data":[[{"value":"好好", "type":"ROW_HEADER"}, {"value":"08/24", "type":"ROW_HEADER","datatype":"string"}]]};
                if(data == '')
                    return;
                JSONToExcelConvertor(data.data, "Report", data.title);
            });
        });

        function JSONToExcelConvertor(JSONData, FileName, ShowLabel) {
            //先转化json
            var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData) : JSONData;

            var excel = '<table>';

            excel += '<tr><td colspan="2">集团</td></tr>';

   excel += '<tr><td style="vnd.ms-excel.numberformat:@;">08/24</td><td style="vnd.ms-excel.numberformat:@;">好好</td></tr>' ;
            //设置表头
            //var row = "<tr>";
            //for (var i = 0, l = ShowLabel.length; i < l; i++) {
             //   row += "<td colspan='2'>" + ShowLabel[i].value + '</td>';
            //}



            //换行
            //excel += row + "</tr>";

            //设置数据
            //for (var i = 0; i < arrData.length; i++) {
             //   var row = "<tr>";

             //   for (var index in arrData[i]) {
             //       var value = arrData[i][index].value === "." ? "" : arrData[i][index].value;
              //      row += '<td style="vnd.ms-excel.numberformat:@;">' + value + '</td>';
              // }

             //   excel += row + "</tr>";
            //}

            excel += "</table>";

            var excelFile = "<html xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:x='urn:schemas-microsoft-com:office:excel' xmlns='http://www.w3.org/TR/REC-html40'>";
            excelFile += '<meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8">';
            excelFile += '<meta http-equiv="content-type" content="application/vnd.ms-excel';
            excelFile += '; charset=UTF-8">';
            excelFile += "<head>";
            excelFile += "";
            excelFile += "</head>";
            excelFile += "<body>";
            excelFile += excel;
            excelFile += "</body>";
            excelFile += "</html>";


            var uri = 'data:application/vnd.ms-excel;charset=utf-8,' + encodeURIComponent(excelFile);

            var link = document.createElement("a");
            link.href = uri;

            link.download = FileName + ".xls";

            document.body.appendChild(link);
            link.click();
            document.body.removeChild(link);
        }
    </script>
</head>
<body>
    <input type="button" id="wwo" value="导出" />
</body>
</html>