利用js把异步加载的表格导出为excel多sheet的那一种

最新推荐文章于 2023-07-06 18:20:28 发布
最新推荐文章于 2023-07-06 18:20:28 发布
阅读量897 收藏 1
点赞数
文章标签： javascript excel
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/han_xiao_xiao/article/details/105483593
版权

最近还在为这一功能的实现而苦恼，但是经过不断地思考以及查资料，终于找到了一款自己项目的解决方案。做出来的效果如图：
在这里插入图片描述
因为自己要做的表格是自定义样式的，不是规规整整的。所以花的时间有点久。不然推荐直接使用jquery的插件table2excel.js，可以直接把表格样式带过来。但是考虑到多sheet，我不太知道应该改那一块的源码。所以就放弃了这一条路，用js完成了多sheet的功能。但是效果如图，就没有样式，例如文字居中，合并单元格都没有过来。因此其实有待优化，但是基本功能已经出来了。
废话不多说了，上代码。我们这个太复杂了，主要是后端传过来的json很复杂。所以呵呵。
html代码：

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>ExportTablesToExcel</title>
    <link rel="stylesheet" href="layui/css/layui.css">
    <script src="js/jquery-2.1.0.min.js"></script>
    <script src="js/table2excel.js"></script>
</head>
<style>
    table{
        display: none;
    }
</style>
<body>
    <div id="table_content">
    </div>
    <button type="button" class="layui-btn layui-btn-normal exportToExcel">导出</button>
</body>
<script>
    var machine_count = "";
   $(function() {
       $.ajax({
           url:"json/new_zongxiang(1).json",
           type:"get",
           datatype:'json',
           success:function(data){
               var every_data = data.data;
               machine_count = data.data[0].count; 
               var recv_time= [];
               var recv_time_new= [];
               var machine_name= [];
               var amplitude = [];
               var amplitude_new = [];
               var pulse = [];
               var pulse_new = [];
               var average = [];
               var average_new =[];
               var data_level = [];
               var data_level_new = [];

               data.data.forEach(v => {
                   recv_time.push(v.recv_time);
                 });
               data.data.forEach(v => {
                   v.data.forEach(a =>{
                       machine_name.push(a.data.machine_name) ;
                       amplitude.push(a.data.amplitude);
                       average.push(a.data.average);
                       pulse.push(a.data.pulse);
                       data_level.push(a.data.data_level);
                   })
               
                 });
           for( var i = 0;i<machine_count;i++){
               var html = [];
               html[i] = "";
                   amplitude_new = getSubArray(every_data.length,machine_count,amplitude,i);
                   average_new = getSubArray(every_data.length,machine_count,average,i);
                   pulse_new = getSubArray(every_data.length,machine_count,pulse,i);
                   data_level_new = getSubArray(every_data.length,machine_count,data_level,i);
                   html[i] += '<table class="table2excel" id="datas'+i+'" data-tableName="Test Table 1" >';
                   html[i] += '<colgroup><col width="15%"><col width="15%"><col width="15%"><col width="15%"><col width="15%"><col width="15%"></colgroup>';
                   html[i] +='<th style="text-align:center; width:100px"  colspan="6" >开关柜属性</th>';
                   html[i] +='<tr><td  style="text-align:center;" colspan="2">开关室</th><td colspan="4"></td></tr>';
                   html[i] += '<tr><td  style="text-align:center;" colspan="2">开关柜编号</th><td colspan="4" id="machine_name">'+machine_name[i]+'</td></tr>';
                   html[i] += '<tr><td  style="text-align:center;" colspan="2">开关柜型号</th><td colspan="4"></td></tr>';
                   html[i] += '<tr><td  style="text-align:center;" colspan="2">电压等级</th><td colspan="4"></td></tr>';
                   html[i] += '<tr><td  style="text-align:center;" colspan="2">生产厂家</th><td colspan="4"></td></tr>';
                   html[i] += '<tr><td  style="text-align:center;" colspan="2">投运日期</th><td colspan="4"></td></tr>';
                   html[i] += '<th  style="text-align:center;" colspan="6">TEV监测数据</th>';
                   html[i] += '<tr><th style="text-align:center;">时间</th><th style="text-align:center;">最大放电幅值(dB)</th><th style="text-align:center;">平均放电幅值(dB)</th><th style="text-align:center;">放电脉冲数</th><th style="text-align:center;">噪声阈值(dB)</th><th style="text-align:center;">预警等级</th></tr>';
                   $.each(every_data, function(j, ooo) {
                   html[i] += '<tr><td style="text-align:center;" id="time">'+every_data[j].recv_time+'</td>';
                   html[i] += '<td style="text-align:center;" id="amplitude">'+amplitude_new[j]+'</td>';
                   html[i] += ' <td style="text-align:center;" id="average">'+average_new[j]+'</td>';
                   html[i] += '<td style="text-align:center;" id="pulse">'+pulse_new[j]+'</td>';
                   html[i] += ' <td style="text-align:center;"></td>';
                   html[i] += '<td style="text-align:center;" id="data_level">'+getContent(data_level_new[j])+'</td></tr>';
                   })	
                   html[i] += '</table>';
                   $("#table_content").append(html[i]);
           }
           
           }
           })
           function getSubArray(date_count,machine_count,total_data,i){
               var datas = [];
               for(var j = 0 ; j < date_count ; j++ ){
               datas.push(total_data[i+machine_count*j])
               }
               return datas
          }
           function getContent(num) {
               if(num == 0){
                   return "正常"
               }else if(num == 1){
                   return "关注"
               }else if(num == 2){
                   return "预警"
               }
       }

       $(".exportToExcel").click(function(e){  
           var table_id = [];
           var sheet_name = [];
           //alert(machine_count)
           for(var i = 0;i<machine_count;i++){
               table_id.push("datas"+i);
               sheet_name.push("开关柜编号"+(i+1));
           }
           tablesToExcel(table_id, sheet_name, "开关柜信息.xls", "Excel");
           
      
       });
       
                })
</script>  
</html>

table2excel.js代码如下：



            //导出excel包含多个sheet
            //tables:tableId的数组;wsbames:sheet的名字数组;wbname:工作簿名字;appname:Excel
            function tablesToExcel(tables, wsnames, wbname, appname){

                var uri = 'data:application/vnd.ms-excel;base64,'
                , tmplWorkbookXML = '<?xml version="1.0"?><?mso-application progid="Excel.Sheet"?><Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">'
                + '<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"><Author>Axel Richter</Author><Created>{created}</Created></DocumentProperties>'
                + '<Styles>'
                + '<Style ss:ID="Currency"><NumberFormat ss:Format="Currency"></NumberFormat></Style>'
                + '<Style ss:ID="Date"><NumberFormat ss:Format="Medium Date"></NumberFormat></Style>'
                + '</Styles>'
                + '{worksheets}</Workbook>'
                , tmplWorksheetXML = '<Worksheet ss:Name="{nameWS}"><Table>{rows}</Table></Worksheet>'
                , tmplCellXML = '<Cell{attributeStyleID}{attributeFormula}><Data ss:Type="{nameType}">{data}</Data></Cell>'
                , base64 = function(s) { return window.btoa(unescape(encodeURIComponent(s))) }
                    , format = function(s, c) { return s.replace(/{(\w+)}/g, function(m, p) { return c[p]; }) }

                var ctx = "";
                var workbookXML = "";
                var worksheetsXML = "";
                var rowsXML = "";

                for (var i = 0; i < tables.length; i++) {
                    if (!tables[i].nodeType) tables[i] = document.getElementById(tables[i]);

                //           控制要导出的行数
                for (var j = 0; j < tables[i].rows.length; j++) {
                        rowsXML += '<Row>';

                        for (var k = 0; k < tables[i].rows[j].cells.length; k++) {
                            var dataType = tables[i].rows[j].cells[k].getAttribute("data-type");
                            var dataStyle = tables[i].rows[j].cells[k].getAttribute("data-style");
                            var dataValue = tables[i].rows[j].cells[k].getAttribute("data-value");
                            dataValue = (dataValue)?dataValue:tables[i].rows[j].cells[k].innerHTML;
                            var dataFormula = tables[i].rows[j].cells[k].getAttribute("data-formula");
                            dataFormula = (dataFormula)?dataFormula:(appname=='Calc' && dataType=='DateTime')?dataValue:null;
                            ctx = {  attributeStyleID: (dataStyle=='Currency' || dataStyle=='Date')?' ss:StyleID="'+dataStyle+'"':''
                                    , nameType: (dataType=='Number' || dataType=='DateTime' || dataType=='Boolean' || dataType=='Error')?dataType:'String'
                                    , data: (dataFormula)?'':dataValue
                                    , attributeFormula: (dataFormula)?' ss:Formula="'+dataFormula+'"':''
                                    };
                            rowsXML += format(tmplCellXML, ctx);
                        }
                        rowsXML += '</Row>'
                }
                    ctx = {rows: rowsXML, nameWS: wsnames[i] || 'Sheet' + i};
                    worksheetsXML += format(tmplWorksheetXML, ctx);
                    rowsXML = "";
                }

                ctx = {created: (new Date()).getTime(), worksheets: worksheetsXML};
                workbookXML = format(tmplWorkbookXML, ctx);

                //       查看后台的打印输出
                //console.log(workbookXML);

                var link = document.createElement("A");
                link.href = uri + base64(workbookXML);
                link.download = wbname || 'Workbook.xls';
                link.target = '_blank';
                document.body.appendChild(link);
                link.click();
                document.body.removeChild(link);
                }

json格式如下：

{
    "code": 0,
    "msg": "success",
    "count": 440,
    "data": [
        {
            "recv_time": "2020-03-14",
            "count": 20,
            "data": [
                {
                    "data": {
                        "sensor_id": 1,
                        "battery": 3900,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 50,
                        "data_level": 2,
                        "machine_name": "1号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 2,
                        "battery": 3901,
                        "amplitude": 56,
                        "average": 55,
                        "pulse": 51,
                        "data_level": 2,
                        "machine_name": "2号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 3,
                        "battery": 3902,
                        "amplitude": 57,
                        "average": 55,
                        "pulse": 52,
                        "data_level": 2,
                        "machine_name": "3号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 4,
                        "battery": 3903,
                        "amplitude": 58,
                        "average": 55,
                        "pulse": 53,
                        "data_level": 2,
                        "machine_name": "4号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 5,
                        "battery": 3904,
                        "amplitude": 59,
                        "average": 55,
                        "pulse": 54,
                        "data_level": 2,
                        "machine_name": "5号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 6,
                        "battery": 3905,
                        "amplitude": 60,
                        "average": 55,
                        "pulse": 55,
                        "data_level": 2,
                        "machine_name": "6号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 7,
                        "battery": 3906,
                        "amplitude": 61,
                        "average": 55,
                        "pulse": 56,
                        "data_level": 2,
                        "machine_name": "7号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 8,
                        "battery": 3907,
                        "amplitude": 62,
                        "average": 55,
                        "pulse": 57,
                        "data_level": 2,
                        "machine_name": "8号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 9,
                        "battery": 3908,
                        "amplitude": 63,
                        "average": 55,
                        "pulse": 58,
                        "data_level": 2,
                        "machine_name": "9号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 10,
                        "battery": 3909,
                        "amplitude": 64,
                        "average": 55,
                        "pulse": 59,
                        "data_level": 2,
                        "machine_name": "10号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 11,
                        "battery": 3910,
                        "amplitude": 65,
                        "average": 55,
                        "pulse": 60,
                        "data_level": 2,
                        "machine_name": "11号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 12,
                        "battery": 3911,
                        "amplitude": 66,
                        "average": 55,
                        "pulse": 61,
                        "data_level": 2,
                        "machine_name": "12号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 13,
                        "battery": 3912,
                        "amplitude": 67,
                        "average": 55,
                        "pulse": 62,
                        "data_level": 2,
                        "machine_name": "13号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 14,
                        "battery": 3913,
                        "amplitude": 68,
                        "average": 55,
                        "pulse": 63,
                        "data_level": 2,
                        "machine_name": "14号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 15,
                        "battery": 3914,
                        "amplitude": 69,
                        "average": 55,
                        "pulse": 64,
                        "data_level": 2,
                        "machine_name": "15号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 16,
                        "battery": 3915,
                        "amplitude": 70,
                        "average": 55,
                        "pulse": 65,
                        "data_level": 2,
                        "machine_name": "16号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 17,
                        "battery": 3916,
                        "amplitude": 71,
                        "average": 55,
                        "pulse": 66,
                        "data_level": 2,
                        "machine_name": "17号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 18,
                        "battery": 3917,
                        "amplitude": 72,
                        "average": 55,
                        "pulse": 67,
                        "data_level": 2,
                        "machine_name": "18号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 19,
                        "battery": 3918,
                        "amplitude": 73,
                        "average": 55,
                        "pulse": 68,
                        "data_level": 2,
                        "machine_name": "19号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 20,
                        "battery": 3919,
                        "amplitude": 74,
                        "average": 55,
                        "pulse": 69,
                        "data_level": 2,
                        "machine_name": "20机器"
                    }
                }
            ]
        },
        {
            "recv_time": "2020-03-15",
            "count": 20,
            "data": [
                {
                    "data": {
                        "sensor_id": 1,
                        "battery": 3898,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 51,
                        "data_level": 2,
                        "machine_name": "1号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 2,
                        "battery": 3899,
                        "amplitude": 43,
                        "average": 55,
                        "pulse": 52,
                        "data_level": 2,
                        "machine_name": "2号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 3,
                        "battery": 3900,
                        "amplitude": 44,
                        "average": 55,
                        "pulse": 53,
                        "data_level": 2,
                        "machine_name": "3号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 4,
                        "battery": 3901,
                        "amplitude": 45,
                        "average": 55,
                        "pulse": 54,
                        "data_level": 2,
                        "machine_name": "4号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 5,
                        "battery": 3902,
                        "amplitude": 46,
                        "average": 55,
                        "pulse": 55,
                        "data_level": 2,
                        "machine_name": "5号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 6,
                        "battery": 3903,
                        "amplitude": 47,
                        "average": 55,
                        "pulse": 56,
                        "data_level": 2,
                        "machine_name": "6号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 7,
                        "battery": 3904,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 57,
                        "data_level": 2,
                        "machine_name": "7号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 8,
                        "battery": 3905,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 58,
                        "data_level": 2,
                        "machine_name": "8号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 9,
                        "battery": 3906,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 59,
                        "data_level": 2,
                        "machine_name": "9号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 10,
                        "battery": 3907,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 60,
                        "data_level": 2,
                        "machine_name": "10号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 11,
                        "battery": 3908,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 61,
                        "data_level": 2,
                        "machine_name": "11号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 12,
                        "battery": 3909,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 62,
                        "data_level": 2,
                        "machine_name": "12号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 13,
                        "battery": 3910,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 63,
                        "data_level": 2,
                        "machine_name": "13号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 14,
                        "battery": 3911,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 64,
                        "data_level": 2,
                        "machine_name": "14号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 15,
                        "battery": 3912,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 65,
                        "data_level": 2,
                        "machine_name": "15号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 16,
                        "battery": 3913,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 66,
                        "data_level": 2,
                        "machine_name": "16号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 17,
                        "battery": 3914,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 67,
                        "data_level": 2,
                        "machine_name": "17号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 18,
                        "battery": 3915,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 68,
                        "data_level": 2,
                        "machine_name": "18号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 19,
                        "battery": 3916,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 69,
                        "data_level": 2,
                        "machine_name": "19号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 20,
                        "battery": 3917,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 70,
                        "data_level": 2,
                        "machine_name": "20机器"
                    }
                }
            ]
        },
        {
            "recv_time": "2020-03-16",
            "count": 20,
            "data": [
                {
                    "data": {
                        "sensor_id": 1,
                        "battery": 3894,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 54,
                        "data_level": 2,
                        "machine_name": "1号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 2,
                        "battery": 3895,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 55,
                        "data_level": 2,
                        "machine_name": "2号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 3,
                        "battery": 3896,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 56,
                        "data_level": 2,
                        "machine_name": "3号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 4,
                        "battery": 3897,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 57,
                        "data_level": 2,
                        "machine_name": "4号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 5,
                        "battery": 3898,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 58,
                        "data_level": 2,
                        "machine_name": "5号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 6,
                        "battery": 3899,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 59,
                        "data_level": 2,
                        "machine_name": "6号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 7,
                        "battery": 3900,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 60,
                        "data_level": 2,
                        "machine_name": "7号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 8,
                        "battery": 3901,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 61,
                        "data_level": 2,
                        "machine_name": "8号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 9,
                        "battery": 3902,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 62,
                        "data_level": 2,
                        "machine_name": "9号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 10,
                        "battery": 3903,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 63,
                        "data_level": 2,
                        "machine_name": "10号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 11,
                        "battery": 3904,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 64,
                        "data_level": 2,
                        "machine_name": "11号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 12,
                        "battery": 3905,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 65,
                        "data_level": 2,
                        "machine_name": "12号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 13,
                        "battery": 3906,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 66,
                        "data_level": 2,
                        "machine_name": "13号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 14,
                        "battery": 3907,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 67,
                        "data_level": 2,
                        "machine_name": "14号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 15,
                        "battery": 3908,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 68,
                        "data_level": 2,
                        "machine_name": "15号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 16,
                        "battery": 3909,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 69,
                        "data_level": 2,
                        "machine_name": "16号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 17,
                        "battery": 3910,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 70,
                        "data_level": 2,
                        "machine_name": "17号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 18,
                        "battery": 3911,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 71,
                        "data_level": 2,
                        "machine_name": "18号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 19,
                        "battery": 3912,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 72,
                        "data_level": 2,
                        "machine_name": "19号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 20,
                        "battery": 3913,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 73,
                        "data_level": 2,
                        "machine_name": "20机器"
                    }
                }
            ]
        },
        {
            "recv_time": "2020-03-17",
            "count": 20,
            "data": [
                {
                    "data": {
                        "sensor_id": 1,
                        "battery": 3886,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 60,
                        "data_level": 2,
                        "machine_name": "1号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 2,
                        "battery": 3887,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 61,
                        "data_level": 2,
                        "machine_name": "2号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 3,
                        "battery": 3888,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 62,
                        "data_level": 2,
                        "machine_name": "3号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 4,
                        "battery": 3889,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 63,
                        "data_level": 2,
                        "machine_name": "4号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 5,
                        "battery": 3890,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 64,
                        "data_level": 2,
                        "machine_name": "5号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 6,
                        "battery": 3891,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 65,
                        "data_level": 2,
                        "machine_name": "6号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 7,
                        "battery": 3892,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 66,
                        "data_level": 2,
                        "machine_name": "7号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 8,
                        "battery": 3893,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 67,
                        "data_level": 2,
                        "machine_name": "8号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 9,
                        "battery": 3894,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 68,
                        "data_level": 2,
                        "machine_name": "9号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 10,
                        "battery": 3895,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 69,
                        "data_level": 2,
                        "machine_name": "10号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 11,
                        "battery": 3896,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 70,
                        "data_level": 2,
                        "machine_name": "11号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 12,
                        "battery": 3897,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 71,
                        "data_level": 2,
                        "machine_name": "12号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 13,
                        "battery": 3898,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 72,
                        "data_level": 2,
                        "machine_name": "13号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 14,
                        "battery": 3899,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 73,
                        "data_level": 2,
                        "machine_name": "14号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 15,
                        "battery": 3900,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 74,
                        "data_level": 2,
                        "machine_name": "15号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 16,
                        "battery": 3901,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 75,
                        "data_level": 2,
                        "machine_name": "16号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 17,
                        "battery": 3902,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 76,
                        "data_level": 2,
                        "machine_name": "17号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 18,
                        "battery": 3903,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 77,
                        "data_level": 2,
                        "machine_name": "18号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 19,
                        "battery": 3904,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 78,
                        "data_level": 2,
                        "machine_name": "19号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 20,
                        "battery": 3905,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 79,
                        "data_level": 2,
                        "machine_name": "20机器"
                    }
                }
            ]
        },
        {
            "recv_time": "2020-03-18",
            "count": 20,
            "data": [
                {
                    "data": {
                        "sensor_id": 1,
                        "battery": 3879,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 71,
                        "data_level": 2,
                        "machine_name": "1号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 2,
                        "battery": 3880,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 72,
                        "data_level": 2,
                        "machine_name": "2号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 3,
                        "battery": 3881,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 73,
                        "data_level": 2,
                        "machine_name": "3号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 4,
                        "battery": 3882,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 74,
                        "data_level": 2,
                        "machine_name": "4号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 5,
                        "battery": 3883,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 75,
                        "data_level": 2,
                        "machine_name": "5号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 6,
                        "battery": 3884,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 76,
                        "data_level": 2,
                        "machine_name": "6号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 7,
                        "battery": 3885,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 77,
                        "data_level": 2,
                        "machine_name": "7号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 8,
                        "battery": 3886,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 78,
                        "data_level": 2,
                        "machine_name": "8号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 9,
                        "battery": 3887,
                        "amplitude": 55,
                        "average": 55,
                        "pulse": 79,
                        "data_level": 2,
                        "machine_name": "9号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 10,
                        "battery": 3888,
                        "amplitude": 56,
                        "average": 55,
                        "pulse": 80,
                        "data_level": 2,
                        "machine_name": "10号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 11,
                        "battery": 3889,
                        "amplitude": 56,
                        "average": 55,
                        "pulse": 81,
                        "data_level": 2,
                        "machine_name": "11号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 12,
                        "battery": 3890,
                        "amplitude": 56,
                        "average": 55,
                        "pulse": 82,
                        "data_level": 2,
                        "machine_name": "12号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 13,
                        "battery": 3891,
                        "amplitude": 56,
                        "average": 55,
                        "pulse": 83,
                        "data_level": 2,
                        "machine_name": "13号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 14,
                        "battery": 3892,
                        "amplitude": 56,
                        "average": 55,
                        "pulse": 84,
                        "data_level": 2,
                        "machine_name": "14号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 15,
                        "battery": 3893,
                        "amplitude": 56,
                        "average": 55,
                        "pulse": 85,
                        "data_level": 2,
                        "machine_name": "15号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 16,
                        "battery": 3894,
                        "amplitude": 56,
                        "average": 55,
                        "pulse": 86,
                        "data_level": 2,
                        "machine_name": "16号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 17,
                        "battery": 3895,
                        "amplitude": 56,
                        "average": 55,
                        "pulse": 87,
                        "data_level": 2,
                        "machine_name": "17号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 18,
                        "battery": 3896,
                        "amplitude": 56,
                        "average": 55,
                        "pulse": 88,
                        "data_level": 2,
                        "machine_name": "18号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 19,
                        "battery": 3897,
                        "amplitude": 56,
                        "average": 55,
                        "pulse": 89,
                        "data_level": 2,
                        "machine_name": "19号机器"
                    }
                },
                {
                    "data": {
                        "sensor_id": 20,
                        "battery": 3898,
                        "amplitude": 56,
                        "average": 55,
                        "pulse": 90,
                        "data_level": 2,
                        "machine_name": "20机器"
                    }
                }
            ]
        }
    ]
}

主要是自己记忆不好，想总结一下。哈哈 ，可以直接运行，再导个jquery.js就可以了。格式问题有大佬想改改代码的话超级欢迎。

极端~
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
js导出excel表格并生成多sheet
bangweixiao1238的博客
09-10 4223
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>ExportTablesToExcel</title> <script src="js/echarts.js"></scr...
js导出excel表格并生成多个工作区sheet（更改列宽）
weixin_42064877的博客
12-02 1814
【代码】js导出excel表格并生成多sheet（更改列宽）
tableExport表格导出插件jqgrid中文修正版
07-24
tableExport 中文修正+jqgrid修正 表格导出插件，本插件在前人修正的基础上针对几个问题进行了修改，20170722修正以下问题：1.解决jqgrid无法获取表头问题;2.jqgrid开头有一空行问题;3.部分格式导出无扩展名问题;4.但xml中文还是乱码,ppt输出不对；5.注意参数大小写问题，必须一致,因此将所有参数名改成了小写。
sheet.js实现多个html的表格分为多个sheet导出为一个excel
weixin_42032770的博客
02-21 1944
一个页面上有多个tab，希望导出数据的时候，按tab分一下sheet工作表，导出为一整个xlsx文件。
js表格导出excel，含多个sheet
weixin_45892846的博客
11-03 3525
1. 首先安装 npm install xlsx --save //如果报错请下载最新版本 //比如 npm install xlsx@0.14.5 --save 或者更高 2. 在组件中引用xlsx import XLSX from 'xlsx'; 3.提供导出按钮，编写导出方法 <el-button type="success" size="mini" @click="btnClickExport">导出</el-button> 4.js部分 .
XLSX.js实现多sheet页导出，并设置行样式
最新发布
zuo0407的博客
07-06 1394
【代码】XLSX.js实现多sheet页导出，并设置行样式。
html单页面导出到excel
11-16
在IT领域，将HTML单页面的数据导出到Excel是一种常见的需求，特别是在数据分析、报表生成或者数据备份时。本文将深入探讨这个主题，介绍如何实现HTML到Excel的转换，并分享一个可以处理大量数据（如40000条）且响应...
Html Web模拟Excel电子表格
12-19
在现代Web开发中，模拟Excel电子表格已经成为一种常见的需求，特别是在数据处理、在线协作和数据分析等领域。本项目利用HTML、JavaScript（JS）以及可能的扩展库（如ExtJS）来实现这一功能，使得用户能够在浏览器...
Ext Grid导出Excel
03-17
4. **创建BLOB对象**：将构造好的Excel数据转换为Binary Large Object（BLOB），这是在浏览器环境中生成二进制文件的一种方法。 5. **提供下载**：通过创建一个隐藏的`<a>`标签或者利用`window.location.href`，将...
Ext解决题目(内存分页+导出Excel)
10-21
一种常见的方式是使用`Ext.util.JSONP`或第三方库如`SheetJS`（又名`xlsx`），将数据转换为CSV或Excel文件格式。用户点击导出按钮时，可以触发一个函数，该函数获取当前表格显示的数据，将其格式化为Excel格式，并...
JavaScript 实现 Excel数据导出 支持多个Sheet页导出
09-20
纯JavaScript实现json格式数据导出到Excel文件,支持多个Sheet页导出
excel导出的js
12-03
超级方便的数据导出 js 这个都可以卖钱了
javascript excel导出多张工作表
01-29
javascript怎么导出多张工作表，并进行数据导入，可以兼容ie,firefox,google
JS导出多个标签页的Excel
08-28
Js导出Excel的一个工具类，支持一个Excel多个标签页。自动生成文件，只需要在页面构造出Table，然后传递相关参数即可
[js]导出excel0积分0积分0积分0积分0积分
03-14
在JavaScript（JS）环境中，将数据导出为Excel文件是一种常见的需求，特别是在Web应用程序中，用户可能需要将表格数据下载到本地以便进一步处理或存储。本文将深入探讨如何使用JavaScript实现这一功能，主要关注以下...
tableexport 可以导出多个表格到一个excel文件吗_商品批量发布/编辑操作手册 （Excel管理商品告别单个手工操作）...
weixin_39882394的博客
12-11 462
我们在调研中发现，很多商家朋友在商品上新/发布/编辑环节需要耗费大量的时间和精力，网页端单个商品的操作方式太过单一，很多商家提出了批量操作的诉求和建议。因此我们推出了商品批量发布/编辑功能，使用excel文件可以进行批量操作。以下是具体的操作步骤。 本期只支持商品批量发布为草稿，草稿补充完整信息后才可上架。一期暂时开放男女装和3C类目，其他类目后续会逐步开放。1. 商品发布进入商品管理页面，在官方...
node+exceljs+stream流异步导出excel表格
qq_16706711的博客
04-03 2524
第一次写博客有点慌 前段时间公司需要做个异步导出excel的功能 点击导出按钮后端返回数据前端通过node+exceljs把数据转为excel表格同时弹出弹框，支持翻页，弹框主要信息是一个列表，包括excel表名，如果导出完成了就有个下载表格，没有完成有个手动中断按钮，点击手动中断停止导出，添加导出失败，手动中断信息 刚开始用的是直接读取excel文件然后在里面写数据 核心伪代码如下 const ...
基于js-xlsx、xlsx-style、XLSX-Style-Utils实现纯前端导出多个Sheet的excel文件（含样式）
ChuChuChuZzz的博客
02-19 3989
文章目录一、需要的开源包二、使用步骤1.引入库2.构造数据3.生成Sheet4.生成Workbook5.修改样式6.导出三、转换函数四、参考资料 一、需要的开源包 SheetJS的 js-xlsx，可以去github上下载源码：https://github.com/SheetJS/js-xlsx ，全文件xlsx.full.min.js或者核心文件xlsx.core.min.js都可以 XLSX-Style，核心文件xlsxStyle.core.min.js可以从XLSX-Style-Utils的源码中
JAVA根据传入的数据个数异步导出同样多列的Excel表格
06-01
你可以使用Java中的线程池来实现异步导出同样多列的Excel表格。以下是一个示例代码： ``` public void exportExcel(List<List<String>> dataList) { ExecutorService executorService = Executors.newFixedThreadPool(dataList.size()); for (int i = 0; i < dataList.size(); i++) { List<String> data = dataList.get(i); executorService.submit(() -> { Workbook workbook = new XSSFWorkbook(); Sheet sheet = workbook.createSheet("Sheet" + (i + 1)); Row header = sheet.createRow(0); for (int j = 0; j < data.size(); j++) { header.createCell(j).setCellValue("列" + (j + 1)); } Row dataRow = sheet.createRow(1); for (int j = 0; j < data.size(); j++) { dataRow.createCell(j).setCellValue(data.get(j)); } try { FileOutputStream outputStream = new FileOutputStream("path/to/excel" + (i + 1) + ".xlsx"); workbook.write(outputStream); workbook.close(); } catch (IOException e) { e.printStackTrace(); } }); } executorService.shutdown(); } ``` 这里使用了一个线程池来异步执行导出Excel表格的任务。线程池的大小与数据列表的大小相同，每个任务都会创建一个工作簿和工作表，并将数据写入到表格中。最后，每个任务都会将表格写入到磁盘上。你可以根据自己的需求修改代码。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值