upload_excel(e) { let fileReader = new FileReader(); fileReader.onload = async (event) => { var workbook = XLSX.read(event.target.result, { type: 'binary' }); console.log(workbook); let json = XLSX.utils.sheet_to_json(workbook.Sheets.Sheet1, { range: 1, dateNF: 'FMT 22' }); console.log(this); let data = json.map((temp) => { switch (temp['号牌品种']) { case '大型汽车': var type = '01'; break; case '挂车': var type = '15'; break; case '小型汽车': var type = '02'; break; } switch (temp['是否解决']) { case '未解决': var handle = '1'; break; case '已解决': var handle = '3'; break; } return { type: type, chepai: temp['号牌号码'], wf_time: this.formatDate(temp['守法工夫']), wf_address: temp['守法地点'], content: temp['违法行为'], handle: handle, pay_type: temp['缴款状态'] == '未交款' ? 0 : 1, }; }); let result = await create({ data: data }); if (result.err == 0) { this.tableRef.current.reload(); message.success(result.msg); } else { message.success(result.msg); } }; fileReader.readAsBinaryString(e.file); //二进制 }