XLSX+ANT Upload实现从EXCEL导入数据操作

import { Button, Table, Upload, Icon} from 'antd';
 <Upload
                 				   onChange={(e) => {
                                        this.onFileChange(e);
                                    }}
                                    beforeUpload={() => false}
                                    accept={'.xls, .xlsx'}
                                >
                                    <Button>
                                        <Icon type="download" />{tableImportBtnTxt}
                                    </Button>
                                </Upload>

  onFileChange = (e) => {
        const { tableOnImportItems } = this.props;
        // debugger
        const file = e.file;
        let reader = new FileReader();
        reader.onload = (e) => {
            let data = e.target.result;
            let workbook = XLSX.read(data, { type: 'binary' });
            if (tableOnImportItems) {
                tableOnImportItems(workbook);
            }
        };
        reader.readAsBinaryString(file);
    };

 migrateLeadCommons = (workbook, callback) => {
        let sheet = workbook.Sheets.线索池;
        if (!sheet) {
            alert('sheet is null');
            callback();
            return;
        }

        let jsons = [];
        let i = 12;
        while (true) {
            if (!sheet['A' + i] || sheet['A' + i] === '') break;

            let json = {};
            json.valid = 1;
            if (sheet['A' + i]) json.name = sheet['A' + i].v;
            if (sheet['B' + i]) json.company = sheet['B' + i].v;
            if (sheet['C' + i]) json.dept = sheet['C' + i].v;
            if (sheet['D' + i]) json.title = sheet['D' + i].v;
            if (sheet['E' + i]) json.mobile = sheet['E' + i].v;
            if (sheet['F' + i]) json.wechat = sheet['F' + i].v;
            if (sheet['G' + i]) json.country = sheet['G' + i].v;
            if (sheet['H' + i]) json.province = sheet['H' + i].v;
            if (sheet['I' + i]) json.city = sheet['I' + i].v;
            if (sheet['J' + i]) json.area = sheet['J' + i].v;
            if (sheet['K' + i]) json.address = sheet['K' + i].v;
            if (sheet['L' + i]) json.zipcode = sheet['L' + i].v;
            if (sheet['M' + i]) json.comment = sheet['M' + i].v;
            jsons.push(json);
            i++;
        }

//	批量存储操作
        ERPUtil.handleMultiObjects(jsons, this.createOneLeadCommon, {}, callback);
    };
    
    tableOnImportItems = (workbook) => {
        this.migrateLeadCommons(workbook, data => {
            this.showSuccessMessage('批量导入完成')
        });
    };