使用XLSL在JavaScript/TypeScript导出xlsx文件

1.引入xlsx

npm i xlsx

2.代码实现

import * as XLSX from 'xlsx';
export const download = (data: Array<string[]>, filename: string, type: string = 'xlsx') => {
  // 生成工作表和工作簿
  const worksheet = XLSX.utils.aoa_to_sheet(data);
  const workbook = XLSX.utils.book_new();

  // 1. 获取每列最大字符串长度
  const maxColumnLengths = data[0].map((_: string, colIndex: number) =>
   data.reduce((max, row) => Math.max(max, row[colIndex].toString().length + 20), 0)
  );

  // 2. 动态设置列宽度
  const columnProps = maxColumnLengths.map((len: number) => ({
   wch: Math.min(len + 10 > 15 ? len + 2 : 15, 100),
  }));
  worksheet['!cols'] = columnProps;

  // 创建工作表
  XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');
  XLSX.writeFile(workbook, `${filename}.${type}`, { compression: true });
};

3.示例

download(
  [
   ['测试1', '测试2'],
   ['测试1-1', '测试2-1'],
   ['测试1-2', '测试2-2'],
   ['测试1-3', '测试2-1'],
   ['测试1-4', '测试2-4'],
  ],
  '测试'
)