自定义区域模板

var score = [
  { class: "A班", name: "小明", cn: 88, ma: 69, en: 77 },
  { class: "A班", name: "小红", cn: 90, ma: 87, en: 80 },
  { class: "B班", name: "小张", cn: 60, ma: 68, en: 71 },
  { class: "B班", name: "小焦", cn: 95, ma: 88, en: 79 },
  { class: "C班", name: "小绿", cn: 57, ma: 66, en: 68 },
  { class: "C班", name: "小菊", cn: 79, ma: 69, en: 71 },
];

for (var i = 0; i < score.length; i++) {
  var data = score[i];
  var source = new GC.Spread.Sheets.Bindings.CellBindingSource(data);

  sheet.setDataSource(source);

  sheet.copyTo(
    1,
    1,
    7 * (i + 1) - i,
    1,
    5,
    4,
    1 | 2 | 4 | 8 | 16 | 32 | 64 | 128 | 512 | 1024
  );
}

sheet.deleteRows(1, 6);