您好,
经过验证,赋值行的时候,需要对行的格式进行复制。
可以参考以下代码- function setStyleToInsertRowsInSpan(sheet, spans, insertRow, count, sheetArea) {
- for (var i = 0, len = spans.length; i < len; i++) {
- var span = spans[i];
- if (insertRow > span.row && insertRow < span.row + span.rowCount) {
- var firstCellStyle = sheet.getStyle(span.row, span.col, sheetArea);
- if (firstCellStyle) {
- for (var row = insertRow; row < insertRow + count; row++) {
- for (var col = span.col; col < span.col + span.colCount; col++) {
- sheet.setStyle(row, col, firstCellStyle, sheetArea);
- }
- }
- }
- }
- }
- }
复制代码 |