From f6379a640d6c580582ecf01b6293a5ed334f428d Mon Sep 17 00:00:00 2001
From: loulijun2021 <1694218219@qq.com>
Date: 星期四, 14 九月 2023 17:37:12 +0800
Subject: [PATCH] 1.导入数据 正在修改bug
---
src/components/UploadExcel/index.vue | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diff --git a/src/components/UploadExcel/index.vue b/src/components/UploadExcel/index.vue
index 5f82c34..6c8bfc7 100644
--- a/src/components/UploadExcel/index.vue
+++ b/src/components/UploadExcel/index.vue
@@ -12,6 +12,7 @@
style="margin-left:16px;"
:disabled="disabled"
type="primary"
+ icon="el-icon-upload2"
@click="handleUpload"
>
鏂囦欢涓婁紶
@@ -80,14 +81,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)
--
Gitblit v1.9.3