【Angular】Excelのダウンロード機能を実装してみた！

$ npm install xlsx

import * as XLSX from 'xlsx';

.
.
.

download() {
  const header = [
    "ウンコ",
    "ウンコ数"
  ];

  const data = [
    [
      "大きいウンコ",
      1
    ],
    [
      "小さいウンコ",
      2
    ]
  ];

  // ヘッダを先頭に追加
  data.unshift(header);

  // aoa_to_sheetはデータが配列の配列の場合に使う
  const workSheet: XLSX.WorkSheet = XLSX.utils.aoa_to_sheet(data);
  const workBook: XLSX.WorkBook = XLSX.utils.book_new();
  
  XLSX.utils.book_append_sheet(workBook, workSheet, 'sheet1');
  XLSX.writeFile(workBook, 'unko.xlsx');
}