import * as XLSX from 'xlsx' excel文档内容提取

import * as XLSX from 'xlsx';

const beforeCheckout = (file) => { reader.onload = (e) => { const data = e.target.result; const workbook = XLSX.read(data, { type: 'binary' }); const sheetName = workbook.SheetNames[0]; const worksheet = workbook.Sheets[sheetName]; const json = XLSX.utils.sheet_to_json(worksheet); console.log(json); console.log(json.length); setLoading(false); if (json.length == 0||json.length==1) { message.warning( { content: '文件为空，请重新上传！', className: ' formatError', style: { position: 'fixed', top: '22.6%', left: '44%' }, }, 2, ); return; } const strArry = json.map(item => { return Object.values(item).join(',') })

}
reader.readAsBinaryString(file);
}