不规则表格如何导出到excel?

不规则表格如何导出到excel?

function exp(){
var a=[
{“bumen”:“研发部”,“zhiwu”:“经理”,“chuqDays”:33,“bingjDays”:34,
“chucDays”:35,“totalHours”:55,“jierHours”:44,“zhugyj”:“32434”,“tingldyj”:“545”,
“rsYuebaomxList”:[{“xiangm”:1,“neirong”:2,“jindu”:3},{“xiangm”:2,“neirong”:2,“jindu”:3},
{“xiangm”:3,“neirong”:4,“jindu”:5}
]
},
{“bumen”:“公关部”,“zhiwu”:“主任”,“chuqDays”:35,“bingjDays”:22,
“chucDays”:5,“totalHours”:15,“jierHours”:44,“zhugyj”:“3佛挡杀佛4”,“tingldyj”:“5方法5”,
“rsYuebaomxList”:[{“xiangm”:1,“neirong”:2,“jindu”:3},{“xiangm”:2,“neirong”:9,“jindu”:3},
{“xiangm”:3,“neirong”:93,“jindu”:33}
]
}
]
var start = “”;
for (var i = 0; i < a.length; i++) {
console.log(a[i].rsYuebaomxList.length)
var nrStart=a[i].rsYuebaomxList[0];
var jdStart=a[i].rsYuebaomxList[0];
var centerForNR=’’;
var centerForJD=’’;
//第n个人的开头学习
centerForNR=’’ +
‘学习情况’ +
‘’+nrStart.xiangm+’’ +
‘’+nrStart.neirong+’’ +
‘’+nrStart.jindu+’’ +
‘’
centerForJD=’ ’ +
‘工作情况’ +
‘’+jdStart.xiangm+’’ +
‘’+jdStart.neirong+’’ +
‘’+jdStart.jindu+’’ +
‘’
for (var j = 1; j <a[i][“rsYuebaomxList”].length; j++) {
centerForNR +=
‘’+
‘’ + a[i].rsYuebaomxList[j].xiangm + ‘’ +
‘’ + a[i].rsYuebaomxList[j].neirong + ‘’ +
‘’ + a[i].rsYuebaomxList[j].jindu + ‘’+
‘’

                        centerForJD +=
                            '<tr>'+
                            '<td>' + a[i].rsYuebaomxList[j].xiangm + '</td>' +
                            '<td>' + a[i].rsYuebaomxList[j].neirong + '</td>' +
                            ' <td>' + a[i].rsYuebaomxList[j].jindu + '</td>'+
                            '</tr>'

                    }
                    start += ' <table style="width: 2000px;height: 600px;" border="1">' +
                        '        <tr>' +
                        '            <td  colspan="4"><h2>月工作纪实</h2></td>' +
                        '        </tr>' +
                        '        <tr>' +
                        '            <td  colspan="2">部门:'+a[i].bumen+'</td>' +
                        '            <td >职务:'+a[i].zhiwu+'</td>' +
                        '            <td>'+new Date()+'</td>' +
                        '        </tr>' +
                        '        <tr>' +
                        '            <th width="70px">项目</th>' +
                        '            <th width="70px">序号</th>' +
                        '            <th>内容</th>' +
                        '            <th>进度</th>' +
                        '        </tr>'
                    start=start+(centerForNR)+(centerForJD);
                    start+=
                        '<td>考勤情况</td>' +
                        '<td colspan="3">出勤<span>&nbsp;'+a[i].chuqDays+'&nbsp;天,</span>病事假<span>&nbsp;'+a[i].bingjDays+'&nbsp;天,</span>出差<span>&nbsp;'+a[i].chucDays+'&nbsp;天,</span>休假<span>&nbsp;'+a[i].chucDays+'&nbsp;天</span></td>' +
                        '</tr>' +
                        '<tr>' +
                        '<td>加班情况</td>' +
                        '<td colspan="3">共加班<span>&nbsp;'+a[i].totalHours+'&nbsp;小时,</span>其中周末和节假日&nbsp;'+a[i].jierHours+'&nbsp;小时</span></td>' +
                        '</tr>' +
                        '<tr>' +
                        '<td>主管领导意见</td>' +
                        '<td colspan="3"><span>'+a[i].zhugyj+'</span></td>' +
                        '</tr>' +
                        '<tr>' +
                        '<td>厅领导意见</td>' +
                        '<td colspan="3"><span>'+a[i].tingldyj+'</span></td>' +
                        '</tr>' +
                        '</table>'
                }

                $(".table2excel").append(start).table2excel({
                    exclude: ".noExl",
                    name: "月报信息",
                    // columns: 10,//指定不导出列  实例：columns: "0,1,2,3",下标从0开始，代表不导出第一列--第四列
                    filename: "统计汇总",
                    fileext: ".xls",
                    exclude_img: true,
                    exclude_links: true,
                    exclude_inputs: true
                });
                $(".table2excel").empty();

}

导出到excel的样子如下，每条数据代表一个人:

目前实现的是导出的数据都处于同一表格，后续会不同的数据处于不同的sheet。