From a06fc9ad238199d601ae86795188151f56fdd3fe Mon Sep 17 00:00:00 2001
From: licp <lichunping@guanfang.com.cn>
Date: 星期三, 27 十一月 2024 15:22:11 +0800
Subject: [PATCH] 修改样品出入库
---
src/components/tool/file-preview.vue | 29 +----------------------------
1 files changed, 1 insertions(+), 28 deletions(-)
diff --git a/src/components/tool/file-preview.vue b/src/components/tool/file-preview.vue
index 38ea63e..84c00c0 100644
--- a/src/components/tool/file-preview.vue
+++ b/src/components/tool/file-preview.vue
@@ -67,7 +67,6 @@
import VueOfficeExcel from '@vue-office/excel'
//寮曞叆鐩稿叧鏍峰紡
import '@vue-office/excel/lib/index.css'
-import * as XLSX from "xlsx";
export default {
components: {
VueOfficeDocx,
@@ -156,6 +155,7 @@
column:[]
}
obj.tableData = this.formatCSVToTable(m.content.replaceAll('null',' '))
+ // .replaceAll('MIN','=MIN').replaceAll('MAX','=MAX').replaceAll('AVERAGE','=AVERAGE')
for (let item in obj.tableData[0]) {
obj.column.push({
label: item,
@@ -165,11 +165,6 @@
return obj
})
this.csvList = arr
- // console.log(333,this.csvList)
- this.csvList.forEach(m=>{
- console.log(this.calculateFormulas(m.column,m.tableData))
- m.tableData = this.calculateFormulas(m.column,m.tableData)
- })
}).catch( err => {
console.log(err)
})
@@ -210,28 +205,6 @@
}
}
return result
- },
- /**
- * 璁＄畻琛ㄦ牸鍏紡
- *
- * @param tableHeaders 琛ㄥご鏁版嵁
- * @param tableData 琛ㄦ牸鏁版嵁
- */
- calculateFormulas(tableHeaders,tableData){
- // 鐢熸垚 Excel Sheet 鏍煎紡
- const sheetData = [tableHeaders.map(m=>m.label), ...tableData.map((row) => Object.values(row))];
- const worksheet = XLSX.utils.aoa_to_sheet(sheetData);
- // 璁＄畻鍏紡
- XLSX.utils.sheet_add_aoa(worksheet, [], { origin: -1 });
- const newSheetData = XLSX.utils.sheet_to_json(worksheet, { header: 1 });
- // 鏇存柊琛ㄥご鍜岃〃鏍兼暟鎹�
- tableData = newSheetData.slice(1).map((row) =>
- row.reduce((obj, value, index) => {
- obj[newSheetData[0][index]] = value;
- return obj;
- }, {})
- );
- return tableData
},
resetStyle(){
const elements = document.querySelectorAll('[style*="pt"]');
--
Gitblit v1.9.3