纵向扩展时保持样式

let sheet = spread.getSheetFromName('Sheet2')
let table1 = sheet.tables.findByName('gcTable0')
table1.expandBoundRows(true)

function copyTableStyle(sheet, table) {
  let range = table.dataRange();
  console.log(range);
  let startCol = table.expandBoundRows() ? -1 : range.col;
  let colCount = table.expandBoundRows() ? -1 : range.colCount;
  let tableCols = isTableArea(range);
  for (let i = 0; i < range.rowCount - 1; i++) {
    for (let j = 0; j < sheet.getColumnCount(); j++) {
      //判断是否在表格内
      if (tableCols.indexOf(j) == -1) {
        sheet.copyTo(
          range.row + i,
          j,
          range.row + i + 1,
          j,
          1,
          1,
          GC.Spread.Sheets.CopyToOptions.style
        );
      }
    }
  }
}

function isTableArea(range) {
  //生成表格列范围数组
  let cols = [];
  for (let i = 0; i < range.colCount; i++) {
    cols.push(range.col + i);
  }
  return cols;
}