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 | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/src/components/UploadExcel/index.vue b/src/components/UploadExcel/index.vue
index 0804349..6c8bfc7 100644
--- a/src/components/UploadExcel/index.vue
+++ b/src/components/UploadExcel/index.vue
@@ -81,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