js后台系统CMS导出xls格式的excel文件

￡神魔★判官ぃ 2022-10-20 13:45 170阅读 0赞

decodeUtf8 = (arrayBuffer) => { 
        var result = ''
        var i = 0
        var c = 0
        var c2 = 0
        var c3 = 0
        var data = new Uint8Array(arrayBuffer)
        if (data.length > 100) { 
          return arrayBuffer
        }
        // If we have a BOM skip it
        if (data.length >= 3 && data[0] === 0xef && data[1] === 0xbb && data[2] === 0xbf) { 
          i = 3
        }
        // console.log('i====', i)
        while (i < data.length) { 
          c = data[i]
          // console.log('c====', c)
    
          if (c < 128) { 
            result += String.fromCharCode(c)
            i++
          } else if (c > 191 && c < 224) { 
            if (i + 1 >= data.length) { 
              // eslint-disable-next-line no-throw-literal
              throw 'UTF-8 Decode failed. Two byte character was truncated.'
            }
            c2 = data[i + 1]
            result += String.fromCharCode(((c & 31) << 6) | (c2 & 63))
            i += 2
          } else { 
            if (i + 2 >= data.length) { 
              // eslint-disable-next-line no-throw-literal
              throw 'UTF-8 Decode failed. Multi byte character was truncated.'
            }
            c2 = data[i + 1]
            c3 = data[i + 2]
            result += String.fromCharCode(((c & 15) << 12) | ((c2 & 63) << 6) | (c3 & 63))
            i += 3
          }
        }
        return result
      }
    
      handleDownload = (id) => { 
        const {  orgId } = this.state
        if (!orgId) { 
          return message.error('请选择导出的组织')
        }
        const url = `/partyApp/section/exportKpi?orgId=${ orgId}`
        const randomTime = Date.now() + Math.floor(Math.random() * 10000)
        const timeStamp = (url.includes('?') ? '&t=' : '?t=') + randomTime
        const requestUrl = process.env.ZQMB_HOST + url + timeStamp
        axios({ 
          method: 'get',
          responseType: 'arraybuffer',
          // data: JSON.stringify(params),
          url: requestUrl,
          headers: { 
            'msg.callback': '',
            'auth.sysid': process.env.ZQMB_SYSID,
            'auth.permit': process.env.ZQMB_PERMIT,
            'auth.token': window.AUTH_TOKEN
          }
        })
          .then(res => { 
            if (res && res.status === 200) { 
              const {  data, headers } = res
    
              let str = this.decodeUtf8(data)
              try { 
                let json = JSON.parse(str)
                if (json.code !== 1) { 
                  message.error(json.message)
                }
              } catch (e) { 
                const disposition = headers['content-disposition']
                const fileNames = disposition ? disposition.match(/filename=(.*)/)[1] : 'kpi.xls'
                let fileName = decodeURIComponent(fileNames).split('/')[1]
                if (!fileName) { 
                  fileName = decodeURI(fileNames)
                }
    
                let blob = new window.Blob([data], {  type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' })
                if (window.navigator.msSaveBlob) { 
                  // for ie 10 and later
                  try { 
                    let url = fileName
                    console.log(url) // IE 需要引用一下才能获取变量的值
                    window.navigator.msSaveBlob(blob, url)
                  } catch (e) { 
                    console.error(e)
                  }
                } else { 
                  const link = document.createElement('a')
                  const url = window.URL.createObjectURL(blob)
                  link.style.display = 'none'
                  link.href = url
                  link.setAttribute('download', fileName)
                  document.body.appendChild(link)
                  link.click()
                  document.body.removeChild(link)
                }
              }
            } else { 
              message.error('文件下载失败，请重试')
            }
          })
      }