From 6ef9e5189ac1888b8c4c504d5c5d3f431807ff56 Mon Sep 17 00:00:00 2001
From: spring <2396852758@qq.com>
Date: 星期六, 15 三月 2025 11:57:40 +0800
Subject: [PATCH] 修改电路试验单位
---
src/components/tool/file-preview.vue | 41 ++++++++++-------------------------------
1 files changed, 10 insertions(+), 31 deletions(-)
diff --git a/src/components/tool/file-preview.vue b/src/components/tool/file-preview.vue
index 38ea63e..08d1757 100644
--- a/src/components/tool/file-preview.vue
+++ b/src/components/tool/file-preview.vue
@@ -1,10 +1,10 @@
<template>
<div>
<div v-if="isImage">
- <img :src="fileUrl" alt="Image Preview" />
+ <img :src="imgUrl" alt="Image Preview" />
</div>
<div v-if="isPdf">
- <object :data="fileUrl" type="application/pdf" width="100%" height="600px">
+ <object :data="fileUrl" type="application/pdf" width="100%" height="750px">
<p>鎮ㄧ殑娴忚鍣ㄤ笉鏀寔 PDF 棰勮銆�<a :href="fileUrl">涓嬭浇 PDF 鏂囦欢</a></p>
</object>
</div>
@@ -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,
@@ -96,11 +95,17 @@
transformData: (workbookData) => {return workbookData}, //灏嗚幏鍙栧埌鐨別xcel鏁版嵁杩涜澶勭悊涔嬪悗涓旀覆鏌撳埌椤甸潰涔嬪墠锛屽彲閫氳繃transformData瀵瑰嵆灏嗘覆鏌撶殑鏁版嵁鍙婃牱寮忚繘琛屼慨鏀癸紝姝ゆ椂姣忎釜鍗曞厓鏍肩殑text鍊煎氨鏄嵆灏嗘覆鏌撳埌椤甸潰涓婄殑鍐呭
},
csvList:[],//csv鏂囦欢鏁版嵁
+ imgUrl:''
}
},
computed: {
isImage() {
- return /\.(jpg|jpeg|png|gif)$/i.test(this.fileUrl);
+ let state = /\.(jpg|jpeg|png|gif)$/i.test(this.fileUrl)
+ this.imgUrl = this.fileUrl
+ if(state){
+ this.imgUrl = this.fileUrl.replaceAll('word', 'img')
+ }
+ return state;
},
isPdf() {
return /\.pdf$/i.test(this.fileUrl);
@@ -156,6 +161,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 +171,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 +211,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