1.统计报表 加上车间名称的查询条件

loulijun2021

2023-11-02 e20c8cf7ad6d2a85817c5627fc9ee7c755884d5b

 src/components/UploadExcel/index.vue

@@ -13,6 +13,7 @@
      :disabled="disabled"
      type="primary"
      icon="el-icon-upload2"
      waves
      @click="handleUpload"
    >
      文件上传
@@ -22,8 +23,10 @@

<script>
import XLSX from 'xlsx'
import waves from '@/directive/waves'

export default {
  directives: { waves },
  props: {
    disabled: Boolean,
    beforeUpload: Function, // eslint-disable-line
@@ -81,14 +84,14 @@
        const reader = new FileReader()
        reader.onload = e => {
          const data = e.target.result
          const workbook = XLSX.read(data, { type: 'array' })
          const workbook = XLSX.read(data, { type: 'array', cellDates: true })
          let worksheet = []
          const header = []
          const results = []
          workbook.SheetNames.forEach((item, index) => {
            worksheet = workbook.Sheets[item]
            header.push(this.getHeaderRow(worksheet))
            results.push(XLSX.utils.sheet_to_json(worksheet))
            results.push(XLSX.utils.sheet_to_json(worksheet, { defval: null, raw: false }))
          })
          this.excelData.sheetName = workbook.SheetNames
          // console.log(header)