jsxlsx中文文档

npm install xlsx

import * as XLSX from 'xlsx';

function handleFile(e) {
  const file = e.target.files[0];
  const reader = new FileReader();
  reader.onload = function(e) {
    const data = new Uint8Array(e.target.result);
    const workbook = XLSX.read(data, { type: 'array' });
    const sheetName = workbook.SheetNames[0];
    const worksheet = workbook.Sheets[sheetName];
    const jsonData = XLSX.utils.sheet_to_json(worksheet);
    console.log(jsonData);
  };
  reader.readAsArrayBuffer(file);
}

function exportExcel() {
  const data = [
    { name: '张三', age: 25, city: '北京' },
    { name: '李四', age: 30, city: '上海' },
  ];

  const worksheet = XLSX.utils.json_to_sheet(data);
  const workbook = XLSX.utils.book_new();
  XLSX.utils.book_append_sheet(workbook, worksheet, "人员信息");
  XLSX.writeFile(workbook, "人员信息表.xlsx");
}

const worksheet = XLSX.utils.json_to_sheet(data);
worksheet['A1'].s = {
  font: { bold: true, color: { rgb: "FF0000" } },
  fill: { fgColor: { rgb: "FFFF00" } },
};

const stream = XLSX.stream.to_json(worksheet, { raw: true });
stream.on('data', row => {
  console.log(row);
});
stream.on('end', () => {
  console.log('处理完成');
});