<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 .save:hover {
|
opacity: .8;
|
}
|
|
#luckysheet .save:active {
|
opacity: .7;
|
}
|
</style>
|
<template>
|
<div id="luckysheet"></div>
|
</template>
|
|
<script>
|
import { data } from 'jquery';
|
// import { data } from 'jquery';
|
export default {
|
props: ['data', 'execlTitle'],
|
data() {
|
return {}
|
},
|
mounted() {
|
this.$nextTick(() => {
|
this.templateWrite()
|
})
|
},
|
methods: {
|
templateWrite() {
|
var option = {}
|
if (this.data != null && this.data != '') {
|
option = JSON.parse(this.data)
|
} else {
|
let rowlen = {}
|
let columnlen = {}
|
for(let a = 0; a<60; 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: 60,
|
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: false, //百分比格式
|
numberDecrease: false, // '减少小数位数'
|
numberIncrease: false, // '增加小数位数
|
moreFormats: false, // '更多格式'
|
strikethrough: false, // '删除线 (Alt+Shift+5)'
|
underline: false, // '下划线 (Alt+Shift+6)'
|
italic: false, // '斜体 (Ctrl+I)'
|
textWrapMode: false, // '换行方式'
|
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 = '<button onClick="excelClosed()" class="save">保存</button>'
|
luckysheet.create(option)
|
}
|
}
|
}
|
</script>
|
