//React tsx
import * as XLSX from 'xlsx';
const handleFileChange = (event: any) => {
const reader = new FileReader();
reader.onload = (e: any) => {
const data = new Uint8Array(e.target.result);
const workbook = XLSX.read(data, {type: 'array'});
const firstSheetName = workbook.SheetNames[0];
const worksheet = workbook.Sheets[firstSheetName];
const jsonData = XLSX.utils.sheet_to_json(worksheet);
console.log(jsonData); // 这里你可以处理jsonData,例如显示在表格中等
};
reader.readAsArrayBuffer(event.target.files[0]);
};
<input type="file" onChange={handleFileChange} />
使用xlsx插件,导入文件,页面显示
最新推荐文章于 2024-07-08 16:22:29 发布