2020-09-14

king

2020-09-14 76427d51a079a5fd1f45bf7188249e7a4647ae05

 src/tabviews/zshare/actionList/excelInbutton/excelin/index.jsx

@@ -42,12 +42,17 @@
        const workbook = XLSX.read(result, { type: 'binary' })

        let errors = null
        let sheetName = btn.verify.sheet

        if (!workbook.Sheets.hasOwnProperty(btn.verify.sheet)) {
        if (Object.keys(workbook.Sheets).length === 1) {
          sheetName = Object.keys(workbook.Sheets)[0]
        }

        if (!workbook.Sheets.hasOwnProperty(sheetName)) {
          errors = 'notexit'
        } else if (range === 1) {
          let header = XLSX.utils.sheet_to_json(workbook.Sheets[btn.verify.sheet], {header: columns})[0]
          
          let header = XLSX.utils.sheet_to_json(workbook.Sheets[sheetName], {header: columns})[0]

          if (!header) {
            errors = 'empty'
          } else {
@@ -67,11 +72,11 @@
        let data = []

        if (!errors) {
          data = XLSX.utils.sheet_to_json(workbook.Sheets[btn.verify.sheet], {header: columns, range: (range)})
          data = XLSX.utils.sheet_to_json(workbook.Sheets[sheetName], {header: columns, range: (range)})
        }

        // 最终获取到并且格式化后的 json 数据
        this.props.returndata(data, errors)
        this.props.returndata(data, errors, sheetName)
        this.setState({
          excelId: '',
        }, () => {
@@ -89,7 +94,7 @@
        })
        notification.warning({
          top: 92,
          message: '文件解析错误，请检查文件格式！',
          message: '文件解析错误！',
          duration: 5
        })
        // 错误传递