在ReactJS中使用npm XLSX在工作簿中添加多个工作表

npm install xlsx

import XLSX from 'xlsx';

const workbook = XLSX.utils.book_new();

const worksheet1Data = [
  ['姓名', '年龄', '性别'],
  ['张三', 25, '男'],
  ['李四', 30, '女'],
];

const worksheet1 = XLSX.utils.aoa_to_sheet(worksheet1Data);

worksheet1['!name'] = '工作表1';

XLSX.utils.book_append_sheet(workbook, worksheet1, '工作表1');

const worksheet2Data = [
  ['商品', '价格'],
  ['苹果', 2.5],
  ['香蕉', 1.5],
  ['橙子', 3],
];

const worksheet2 = XLSX.utils.aoa_to_sheet(worksheet2Data);

worksheet2['!name'] = '工作表2';

XLSX.utils.book_append_sheet(workbook, worksheet2, '工作表2');

XLSX.writeFile(workbook, 'workbook.xlsx');