最近还在为这一功能的实现而苦恼,但是经过不断地思考以及查资料,终于找到了一款自己项目的解决方案。做出来的效果如图:
因为自己要做的表格是自定义样式的,不是规规整整的。所以花的时间有点久。不然推荐直接使用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就可以了。格式问题有大佬想改改代码的话超级欢迎。