用下面代码循环设置下。如果您不使用导入导出功能的话可以看看Spread.Views。产品包里有包括的。
http://demo.gcpowertools.com.cn/spreadjs/views/#/demos/AutoMerge
- var start = 0, end = 0;
- var spanValue = sheet.getValue(0, 0);
- for(var i = 1; i < sheet.getRowCount(); i++){
- var newRowValue = sheet.getValue(i, 0);
- end = i;
- if(spanValue !== newRowValue){
- if(end - start > 1){
- sheet.addSpan(start, 0, end - start, 1);
- }
- start = end;
- spanValue = newRowValue;
- }
- if(!newRowValue){
- break;
- }
- }
复制代码 |