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

最近还在为这一功能的实现而苦恼,但是经过不断地思考以及查资料,终于找到了一款自己项目的解决方案。做出来的效果如图:
在这里插入图片描述
因为自己要做的表格是自定义样式的,不是规规整整的。所以花的时间有点久。不然推荐直接使用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
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值