From 10d13c202497ac0499767c2e4bb250086b293310 Mon Sep 17 00:00:00 2001 From: gaoluyang <2820782392@qq.com> Date: 星期六, 15 二月 2025 16:36:37 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/lims_new_20250213' into lims_new_20250213 --- src/components/Excel/luckysheet.vue | 144 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 144 insertions(+), 0 deletions(-) diff --git a/src/components/Excel/luckysheet.vue b/src/components/Excel/luckysheet.vue new file mode 100644 index 0000000..4e5cc32 --- /dev/null +++ b/src/components/Excel/luckysheet.vue @@ -0,0 +1,144 @@ +<style scoped> +#luckysheet { + margin: 0px; + padding: 0px; + position: absolute; + width: 100%; + height: 100%; + left: 0px; + top: 0px; +} +</style> +<style> +#luckysheet .save { + width: 50px; + height: 26px; + color: #fff; + background-color: #3a7bfa; + border-radius: 4px; + border-color: transparent; + cursor: pointer; +} +#luckysheet .returnView { + width: 50px; + height: 26px; + background-color: #fff; + border: 1px solid #dcdfe6; + color: #606266; + border-radius: 4px; + margin-right: 12px; + cursor: pointer; +} + +#luckysheet .save_i { + margin-right: 20px; + font-size: 20px; + cursor: help; +} + +#luckysheet .save:hover { + opacity: 0.8; +} + +#luckysheet .save:active { + opacity: 0.7; +} +</style> +<template> + <div id="luckysheet"></div> +</template> + +<script> +// import { data } from 'jquery'; +export default { + props: ["data", "execlTitle"], + data() { + return {}; + }, + mounted() { + this.$nextTick(() => { + this.templateWrite(); + }); + }, + methods: { + templateWrite() { + var option = {}; + console.log(2222, this.data); + if (this.data != null && this.data != "") { + option = JSON.parse(this.data); + console.log(11111, option); + } else { + let rowlen = {}; + let columnlen = {}; + for (let a = 0; a < 50; a++) { + rowlen["" + a] = 40; + } + for (let a = 0; a < 26; a++) { + columnlen["" + a] = 100; + } + option = { + data: [ + { + name: "妯℃澘", + order: "0", + config: { + rowlen: rowlen, + columnlen: columnlen, + }, + }, + ], + row: 50, + column: 26, + }; + } + option.title = this.execlTitle; + (option.container = "luckysheet"), + (option.lang = "zh"), + (option.showsheetbar = false), + (option.defaultFontSize = 14); + (option.showstatisticBarConfig = { + view: false, + }), + (option.enableAddRow = false), + (option.enableAddBackTop = false), + (option.showtoolbarConfig = { + chart: false, // '鍥捐〃' + pivotTable: false, //'鏁版嵁閫忚琛�' + protection: false, // '宸ヤ綔琛ㄤ繚鎶�' + dataVerification: false, // '鏁版嵁楠岃瘉' + frozenMode: false, // '鍐荤粨鏂瑰紡' + currencyFormat: false, //璐у竵鏍煎紡 + percentageFormat: true, //鐧惧垎姣旀牸寮� + numberDecrease: true, // '鍑忓皯灏忔暟浣嶆暟' + numberIncrease: true, // '澧炲姞灏忔暟浣嶆暟 + moreFormats: true, // '鏇村鏍煎紡' + strikethrough: false, // '鍒犻櫎绾� (Alt+Shift+5)' + underline: false, // '涓嬪垝绾� (Alt+Shift+6)' + italic: false, // '鏂滀綋 (Ctrl+I)' + textWrapMode: true, // '鎹㈣鏂瑰紡' + textRotateMode: false, // '鏂囨湰鏃嬭浆鏂瑰紡' + conditionalFormat: false, // '鏉′欢鏍煎紡' + splitColumn: false, // '鍒嗗垪' + }), + (option.cellRightClickConfig = { + copyAs: false, // 澶嶅埗涓� + hideRow: false, // 闅愯棌閫変腑琛屽拰鏄剧ず閫変腑琛� + hideColumn: false, // 闅愯棌閫変腑鍒楀拰鏄剧ず閫変腑鍒� + sort: false, // 鎺掑簭閫夊尯 + filter: false, // 绛涢�夐�夊尯 + chart: false, // 鍥捐〃鐢熸垚 + image: false, // 鎻掑叆鍥剧墖 + matrix: false, // 鐭╅樀鎿嶄綔閫夊尯 + data: false, // 鏁版嵁楠岃瘉 + cellFormat: false, // 璁剧疆鍗曞厓鏍兼牸寮� + }), + (option.myFolderUrl = this.LOCATIONVUE + "/"), + // option.functionButton = '<i class="save_i el-icon-info" title="绯荤粺鏀寔鐨勫彉閲忥細
鏍峰搧缂栧彿
鏍峰搧鍨嬪彿
搴忓彿
妫�楠岄」
妫�楠屽瓙椤�
璁惧鍚嶇О
璁惧缂栫爜
鍗曚綅
瑕佹眰鍊�
璇曢獙鏂规硶 | 妫�娴嬫柟娉�
鏈�缁堝��
缁撹
璁$畻鍊�
妫�楠屽��"></i><button onClick="excelExport()" class="save">瀵煎嚭</button><button onClick="excelClosed()" class="save">淇濆瓨</button>' + (option.functionButton = + '<i class="save_i el-icon-info" title="绯荤粺鏀寔鐨勫彉閲忥細
鏍峰搧缂栧彿
鏍峰搧鍨嬪彿
搴忓彿
妫�楠岄」
妫�楠屽瓙椤�
璁惧鍚嶇О
璁惧缂栫爜
鍗曚綅
瑕佹眰鍊�
璇曢獙鏂规硶 | 妫�娴嬫柟娉�
鏈�缁堝��
缁撹
璁$畻鍊�
妫�楠屽��"></i><button onClick="returnView()" class="returnView">鍙栨秷</button><button onClick="excelClosed()" class="save">淇濆瓨</button>'); + console.log(luckysheet); + luckysheet.create(option); + }, + }, +}; +</script> -- Gitblit v1.9.3