如何在angular4中设置XLSX工作表的列宽

npm install xlsx --save

import * as XLSX from 'xlsx';

setColumnWidth() {
  const worksheet: XLSX.WorkSheet = XLSX.utils.aoa_to_sheet([
    ['Column 1', 'Column 2', 'Column 3'], // 表头
    ['Data 1', 'Data 2', 'Data 3'], // 数据行
  ]);

  const columnWidths = [
    { wch: 15 }, // 列1的宽度为15
    { wch: 20 }, // 列2的宽度为20
    { wch: 25 }, // 列3的宽度为25
  ];

  worksheet['!cols'] = columnWidths;

  const workbook: XLSX.WorkBook = XLSX.utils.book_new();
  XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');

  const excelBuffer: any = XLSX.write(workbook, { bookType: 'xlsx', type: 'array' });
  this.saveAsExcelFile(excelBuffer, 'example');
}

saveAsExcelFile(buffer: any, fileName: string): void {
  const data: Blob = new Blob([buffer], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' });
  const url: string = window.URL.createObjectURL(data);
  const link: HTMLAnchorElement = document.createElement('a');
  link.href = url;
  link.download = fileName + '.xlsx';
  link.click();
  window.URL.revokeObjectURL(url);
}

<button (click)="setColumnWidth()">设置列宽</button>