主要代码是在colInfo中,分别获取计划时间和完成时间,然后设置列头为两行,进行合并单元格。- const data = [
- {
- "PATIENT_ID": "932418",
- "PATIENT_NAME": "张茂堃",
- "AGE": "25岁",
- "jiaGong":{planTime:'2021-01-01',finishTime:'2021-01-02'}
- }, {
- "PATIENT_ID": "932418",
- "PATIENT_NAME": "张茂堃",
- "AGE": "25岁",
- "jiaGong":{planTime:'2021-01-01',finishTime:'2021-01-02'}
- }
- ]
- var colInfos = [
- { name: 'PATIENT_ID', displayName: '病人ID', size: 70, visible: false },
- { name: 'PATIENT_NAME', displayName: '姓名', size: 60,pageBread: false },
- { name: 'AGE', displayName: '年龄', size: 120 },
- { displayName: '计划时间', size: 60 ,value:function (item){
- return item.jiaGong.planTime
- }},
- { displayName: '完成时间', size: 60 ,value:function (item){
- return item.jiaGong.finishTime
- }},
- ];
- sheet.autoGenerateColumns = false;
- sheet.bindColumns(colInfos)
- sheet.setDataSource(data);
- sheet.setRowCount(2,GC.Spread.Sheets.SheetArea.colHeader)
- sheet.addSpan(0, 0, 2, 1, GC.Spread.Sheets.SheetArea.colHeader);
- sheet.setValue(0, 0, "", GC.Spread.Sheets.SheetArea.colHeader);
- sheet.addSpan(0, 1, 2, 1, GC.Spread.Sheets.SheetArea.colHeader);
- sheet.setValue(0, 1, "姓名", GC.Spread.Sheets.SheetArea.colHeader);
- sheet.addSpan(0, 2, 2, 1, GC.Spread.Sheets.SheetArea.colHeader)
- sheet.setValue(0,2,"年龄",GC.Spread.Sheets.SheetArea.colHeader);
- sheet.addSpan(0, 3, 1, 2, GC.Spread.Sheets.SheetArea.colHeader);
- sheet.setValue(0,3, '加工',GC.Spread.Sheets.SheetArea.colHeader);
复制代码 最后实现效果为:
|