我有这个React代码,也可以在这里https://stackblitz.com/edit/react-excel-to-json-parser检查代码。当我单击按钮“处理触发器”而不上传文件时。该应用程序中断了如何处理警报错误,用户必须上传文件或禁用按钮“Process Triggers”,直到用户上传文件。
import React, { Component } from 'react';
import { Fabric } from 'office-ui-fabric-react/lib/Fabric';
import { DefaultButton } from 'office-ui-fabric-react/lib/Button';
import XLSX from 'xlsx';
import { make_cols } from './MakeColumns';
import { SheetJSFT } from './types';
class ExcelReader extends Component {
constructor(props) {
super(props);
this.state = {
file: {},
data: [],
cols: []
}
this.handleFile = this.handleFile.bind(this);
this.handleChange = this.handleChange.bind(this);
}
handleChange(e) {
const files = e.target.files;
if (files && files[0]) this.setState({ file: files[0] });
};
handleFile() {
/* Boilerplate to set up FileReader */
const reader = new FileReader();
const rABS = !!reader.readAsBinaryString;
reader.onload = (e) => {
/* Parse data */
const bstr = e.target.result;
const wb = XLSX.read(bstr, { type: rABS ? 'binary' : 'array', bookVBA : true });
/* Get first worksheet */
const wsname = wb.SheetNames[0];
const ws = wb.Sheets[wsname];
/* Convert array of arrays */
const data = XLSX.utils.sheet_to_json(ws);
/* Update state */
this.setState({ data: data, cols: make_cols(ws['!ref']) }, () => {
console.log(JSON.stringify(this.state.data, null, 2));
});
};
if (rABS) {
reader.readAsBinaryString(this.state.file);
} else {
reader.readAsArrayBuffer(this.state.file);
};
}
render() {
return (
<div>
<label htmlFor="file">Upload an excel to Process Triggers</label>
<br />
<input type="file" className="form-control" id="file" accept={SheetJSFT} onChange={this.handleChange} />
<br />
<input type='submit'
value="Process Triggers"
onClick={this.handleFile} />
</div>
)
}
}
export default ExcelReader;
``
最佳答案
将handleFile()代码放入尝试捕获块
handleFile() {
try {
/* Boilerplate to set up FileReader */
const reader = new FileReader();
const rABS = !!reader.readAsBinaryString;
reader.onload = (e) => {
/* Parse data */
const bstr = e.target.result;
const wb = XLSX.read(bstr, { type: rABS ? 'binary' : 'array', bookVBA : true });
/* Get first worksheet */
const wsname = wb.SheetNames[0];
const ws = wb.Sheets[wsname];
/* Convert array of arrays */
const data = XLSX.utils.sheet_to_json(ws);
/* Update state */
this.setState({ data: data, cols: make_cols(ws['!ref']) }, () => {
console.log(JSON.stringify(this.state.data, null, 2));
});
};
if (rABS) {
reader.readAsBinaryString(this.state.file);
} else {
reader.readAsArrayBuffer(this.state.file);
};
} catch(err) {
console.log(err);
}
}