js导出excel

最新推荐文章于 2021-06-16 17:24:49 发布

编码之路就在脚下

最新推荐文章于 2021-06-16 17:24:49 发布

阅读量292

点赞数

分类专栏： js学习文章标签： js 导出excel

本文链接：https://blog.csdn.net/qq_16713463/article/details/88683426

版权

js学习专栏收录该内容

3 篇文章 0 订阅

订阅专栏

本篇教程介绍了jQuery教程如何导出Excel，希望阅读本篇文章以后大家有所收获，帮助大家对jQuery的理解更加深入。

！除IE 浏览器外！

<!DOCTYPE html>
<html>
<head>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <script type="text/javascript" src="jquery.min.js"></script>
    <script type="text/javascript">
        $(document).ready(function(){
            $('#wwo').click(function(){
                //data 需要导出的数据
                var data = [{userName:'lily',age:28,job:"teacher",city:"上海"},
                            {userName:'lucy',age:19,job:"doctor",city:"深圳"}];
                if(data == '')
                    return;
                //excel 表格输出顺序及标题
                var title=[{userName:'姓名'},{job:'职业'},{age:'年龄'},{city:'城市'}];
                toExcel("Report", data, title);
            });
        });
        //FileName 生成的Excel文件名称
        function toExcel(FileName, JSONData, ShowLabel) {
            //先转化json
            var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData) : JSONData;

            var excel = '<table>';

            //设置表头
            var row = "<tr align='left'>";//设置Excel的左居中
            for (var i = 0, l = ShowLabel.length; i < l; i++) {
                for (var key in ShowLabel[i]) {
                    row += "<td>" + ShowLabel[i][key] + '</td>';
                }
            }


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

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

                for (var y = 0; y < ShowLabel.length; y++) {
                    for(var k in ShowLabel[y]){
                        if (ShowLabel[y].hasOwnProperty(k)) {
                             rowData += "<td style='vnd.ms-excel.numberformat:@'>" + (arrData[i][k]===null? "" : arrData[i][k]) + "</td>";　　　　　　　　　　　　　　　　　 //vnd.ms-excel.numberformat:@ 输出为文本
                        }
                    }
                }

                excel += rowData + "</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.style = "visibility:hidden";
            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>