js导出execl大文件

// 安装 xlsx 库: npm install xlsx
const XLSX = require('xlsx');

// 示例数据
const data = [
  ['Name', 'Age', 'Email'],
  ['Alice', 30, 'alice@example.com'],
  ['Bob', 25, 'bob@example.com'],
  // 更多数据...
];

// 创建工作簿和工作表
const worksheet = XLSX.utils.aoa_to_sheet(data);
const workbook = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');

// 生成 Excel 文件并触发下载
const excelBuffer = XLSX.write(workbook, {
  bookType: 'xlsx',
  type: 'array'
});

const blob = new Blob([excelBuffer], { type: 'application/octet-stream' });
const url = window.URL.createObjectURL(blob);
const a = document.createElement('a');
a.href = url;
a.download = 'data.xlsx';
document.body.appendChild(a);
a.click();
document.body.removeChild(a);
window.URL.revokeObjectURL(url);