Lodash

引用外部文件 Lodash.js 。

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

async function run() {
  await Excel.run(async (context) => {
    const obj = _.zipObject(["a", "b"], [1, 2]);
    console.log(obj);
  });
}

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

https://appsforoffice.microsoft.com/lib/1/hosted/office.js
https://appsforoffice.microsoft.com/lib/1/hosted/office.d.ts
https://cdn.jsdelivr.net/npm/lodash@4.17.23/lodash.min.js

区域 A1:B4 输入内容。

A	B
部门	姓名
销售	张三
技术	李四
技术	王五

对二维数组进行处理。

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

async function run() {
  await Excel.run(async (context) => {
    const sheet = context.workbook.worksheets.getActiveWorksheet();
    const rg = sheet.getUsedRange().load("values");
    await context.sync();

    const rgValues = rg.values;
    const [header, ...body] = rgValues;
    const obj = [];
    for (let i of body) {
      obj.push(_.zipObject(header, i));
    }
    console.log(obj);
  });
}

Lodash ​

Lodash