区域

选中区域 A1:C2 。

document.getElementById("run").addEventListener("click", run);

async function run() {
  await Excel.run(async (context) => {
    const sheet = context.workbook.worksheets.getActiveWorksheet();
    sheet.getCell(0, 0).getResizedRange(1, 2).select();

    await context.sync();
  });
}

<button id="run">运行</button>

区域 A1:C1 填充数字。

document.getElementById("run").addEventListener("click", run);

async function run() {
  await Excel.run(async (context) => {
    const sheet = context.workbook.worksheets.getActiveWorksheet();
    sheet.getCell(0, 0).getResizedRange(0, 2).values = [[1, 2, 3]];

    await context.sync();
  });
}

<button id="run">运行</button>

A	B	C
1	2	3

区域 A1:C2 填充数字，使用双循环写入单元格。

document.getElementById("run").addEventListener("click", run);

async function run() {
  await Excel.run(async (context) => {
    const sheet = context.workbook.worksheets.getActiveWorksheet();
    const rows = 2;
    const cols = 3;
    let start = 1;
    for (let i = 0; i < rows ; i ++) {
      for (let j = 0; j < cols ; j ++) {
        sheet.getCell(i, j).values = [[start]];
        start ++;
      }
    }

    await context.sync();
  });
}

<p>简单例子</p>
<button id="run">填充数字</button>

A	B	C
1	2	3
4	5	6

区域 A1:C2 填充数字，使用单循环写入单元格。

document.getElementById("run").addEventListener("click", run);

async function run() {
  await Excel.run(async (context) => {
    const sheet = context.workbook.worksheets.getActiveWorksheet();
    const rows = 2;
    const cols = 3;
    for (let i = 0; i < rows * cols; i ++) {
      sheet.getCell(Math.floor(i / cols), i % cols).values = [[i + 1]]
    }

    await context.sync();
  });
}

<p>简单例子</p>
<button id="run">填充数字</button>

A	B	C
1	2	3
4	5	6

区域 A1:C2 填充数字，使用单循环写入行。

document.getElementById("run").addEventListener("click", run);

function range(start, end, step) {
  const result = [];
  for (let i = start; i < end; i += step) {
    result.push(i);
  }
  return result;
}

async function run() {
  await Excel.run(async (context) => {
    const sheet = context.workbook.worksheets.getActiveWorksheet();
    const rows = 2;
    const cols = 3;
    let start = 1;
    for (let i = 0; i < rows; i++) {
      let end = start + cols;
      sheet.getCell(i, 0).getResizedRange(0, cols - 1).values = [range(start, end, 1)];
      start = end;
    }

    await context.sync();
  });
}

<p>简单例子</p>
<button id="run">填充数字</button>

A	B	C
1	2	3
4	5	6