upload_excel(e){让fileReader=newFileReader();fileReader.onload=async(event)=>{varworkbook=XLSX.read(event.target.result,{type:'binary'});控制台日志（工作簿）；让json=XLSX.utils.sheet_to_json(workbook.Sheets.Sheet1,{range:1,dateNF:'FMT22'});控制台日志（这个）；letdata=json.map((temp)=>{switch(temp['numberplatetype']){case'largecar':vartype='01';break;case'trailer':vartype='15';break;case'smallcar':vartype='02';break;}switch(temp['handledornot']){case'unhandled':varhandle='1';break;case'handled':varhandle='3';break;}return{type:type,chepai:temp['platenumber'],wf_time:this.formatDate(temp['违规时间']),wf_address:temp['非法位置'],content:temp['非法行为'],handle:handle,pay_type:temp['支付状态']=='未支付'?0：1，}；});letresult=awaitcreate({data:data});如果(result.err==0){this.tableRef.current.reload();message.success(result.msg);}else{message.success(result.msg);}};fileReader.readAsBinaryString(e.file);//二进制}
