如果知道合并区域,可以提前获取第一个值,然后合并后将其赋值。- sheet.setValue(1, 2, 3);
- sheet.setValue(3, 1, 5);
- var row = 0, rowCount = 5, col = 0, colCount = 5; //合并区域
- var firstvalue;
- var breaked = false;
- for (let i = row; i < rowCount; i++) {
- for (let j = col; j < colCount; j++) {
- if (sheet.getValue(i, j) !== null) {
- firstvalue = sheet.getValue(i, j);
- console.log(`sheet.getText(${i},${j})=${sheet.getValue(i, j)},${firstvalue}`)
- breaked = true;
- break;
- }
- }
- if (breaked) {
- break;
- }
- }
- sheet.addSpan(row, col, rowCount, colCount);
- sheet.setValue(row,col,firstvalue);
复制代码
|