Sheet 页之间数据绑定

let rows = sheet.getRowCount();
for (let i = 0; i + 2 < rows; i++) {
  sheet.setTag(i + 2, -1, `${i}`);
}

var selections = sheet.getSelections();
if (!selections || selections.length === 0) {
  return;
}
for (let i = 0; i < selections.length; i++) {
  row = selections[i].row;
  col = selections[i].col;
  if (col === -1 && row !== -1) {
    selects.push(parseInt(sheet.getTag(row, col)));
  }
}
let templateConfigData = [];
for (let i = 0; i < selects.length; i++) {
  templateConfigData.push(dataSource[selects[i]]);
}

let data1 = { dataSource1: templateConfigData };
let sheet1 = spread.getSheetFromName("Sheet2");
let table1 = sheet1.tables.all()[0];
table1.autoGenerateColumns(false);
table1.setColumnFormula(0, `SUBTOTAL(109,[数量])`);
sheet1.defaults.rowHeight = 50; // table.set
var tableColumnNew1 = new spreadNS.Tables.TableColumn();
tableColumnNew1.dataField("quantity");
tableColumnNew1.name("数量");
var tableColumnNew2 = new spreadNS.Tables.TableColumn();
tableColumnNew2.dataField("unitPrice");
tableColumnNew2.name("单价");
table1.bindColumns([tableColumnNew1, tableColumnNew2]);
table1.bindingPath("dataSource1");

let dataSource2 = new spreadNS.Bindings.CellBindingSource(data1);
spread.getSheet(1).setDataSource(dataSource2);