如何在React中将Excel电子表格转换为CSV文件？

npm install xlsx csv

import * as XLSX from 'xlsx';
import { CSVLink } from 'react-csv';

const readExcel = (file) => {
  const reader = new FileReader();
  reader.onload = (e) => {
    const data = new Uint8Array(e.target.result);
    const workbook = XLSX.read(data, { type: 'array' });
    const worksheet = workbook.Sheets[workbook.SheetNames[0]];
    const jsonData = XLSX.utils.sheet_to_json(worksheet, { header: 1 });
    // 处理jsonData，进行CSV文件转换或其他操作
  };
  reader.readAsArrayBuffer(file);
};

const convertToCSV = (jsonData) => {
  const csvData = jsonData.map((row) => row.join(',')).join('\n');
  const csvContent = `data:text/csv;charset=utf-8,${encodeURIComponent(csvData)}`;
  return (
    <CSVLink data={csvContent} filename="data.csv">
      Download CSV
    </CSVLink>
  );
};

const handleFileUpload = (e) => {
  const file = e.target.files[0];
  readExcel(file);
};

render() {
  return (
    <div>
      <input type="file" onChange={handleFileUpload} />
      {this.state.jsonData && convertToCSV(this.state.jsonData)}
    </div>
  );
}