我是这样封装了一个多行表头的方法,能帮着看一下 怎么修改,能够两次都调用这么方法吗?export function bindMultiTableColumn(sheet,header,rowCount){
rowCount=rowCount||2;
let colHeader = SpreadNS.SheetArea.colHeader;
sheet.setRowCount(rowCount, colHeader);
let addSpanColumn=0;
let count=0;
header.forEach((item,index)=>{
sheet.setValue(0,count,item.displayName, colHeader);
sheet.bindColumn(count, item);
if(item.children&&item.children.length>0){
item.children.forEach((item1,index1)=>{
sheet.setValue(1, count+index1, item1.displayName, colHeader);
sheet.bindColumn(count+index1, item1);
})
}
if(item.addSpanRow){
sheet.addSpan(0,count,item.addSpanRow,1,colHeader)
}
if(item.addSpanColumn){
sheet.addSpan(0,count,1,item.addSpanColumn,colHeader)
count=count+item.addSpanColumn
}else {
count++;
}
})
sheet.setColumnCount(count);
//设置表单保护
sheet.protectionOption({
allowResizeColumns: false, //不允许用户改变列宽
});
} |