js转excel插件

// 引入 SheetJS 库
import * as XLSX from '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 文件
XLSX.writeFile(workbook, 'example.xlsx');

const blob = new Blob([s2ab(XLSX.write(workbook, { type: 'binary', bookType: 'xlsx' }))], { type: 'application/octet-stream' });
const url = URL.createObjectURL(blob);
const a = document.createElement('a');
a.href = url;
a.download = 'example.xlsx';
document.body.appendChild(a);
a.click();
document.body.removeChild(a);
URL.revokeObjectURL(url);

function s2ab(s) {
  const buf = new ArrayBuffer(s.length);
  const view = new Uint8Array(buf);
  for (let i = 0; i < s.length; i++) view[i] = s.charCodeAt(i) & 0xFF;
  return buf;
}