javascript - 无法绑定 excel 列中的数组值，得到#NAME？在使用角度导出的 excel 中

Question

<!-- begin snippet: js hide: false console: true babel: false -->

  public exportExcel(
    fileName: string,
    header: string[],
    data: any[],
    sheetName: string
  ) {
    let arr: Array<any[]> = [];
    data = Array.of(data);
    arr[0] = header;

    for (let i = 1; i < data[0].length + 1; i++) {
      arr[i] = [];
      let temp = data[0];
      for (let obj of Object.values(temp[i - 1])) {
        arr[i].push(obj);
      }
    }

    const ws: XLSX.WorkSheet = XLSX.utils.aoa_to_sheet(arr);
    const wb: XLSX.WorkBook = XLSX.utils.book_new();
    XLSX.utils.book_append_sheet(wb, ws, sheetName);
    XLSX.writeFile(wb, fileName);

我正在尝试将 writingCompanyName 数组值导出到 excel 中的单列，当在控制台中测试时，我得到了正确的数组响应，但是在导出时我得到了 #NAME？请帮助找出我做错的地方

<!-- begin snippet: js hide: false console: true babel: false -->

JSON - 

writingCompanies: Array(2)
0:
writingCompanyId: 1
writingCompanyName: "test verbiage1"
__proto__: Object
1:
writingCompanyId: 2
writingCompanyName: "test verbiage2"
__proto__: Object
length: 2

标签： javascriptarraysangular