value
2024-04-26 361ad4ba15d552592ace39d7886f3fe2531f46da
src/components/tool/excel.vue
@@ -10,7 +10,7 @@
   }
</style>
<style>
   #luckysheet .save{
   #luckysheet .save {
      width: 50px;
      height: 26px;
      color: #fff;
@@ -19,12 +19,12 @@
      border-color: transparent;
      cursor: pointer;
   }
   #luckysheet .save:hover{
   #luckysheet .save:hover {
      opacity: .8;
   }
   #luckysheet .save:active{
   #luckysheet .save:active {
      opacity: .7;
   }
</style>
@@ -33,11 +33,12 @@
</template>
<script>
import { data } from 'jquery';
   // import { data } from 'jquery';
   export default {
      props: ['data', 'execlTitle'],
      data() {
         return {
            data: {}
         }
         return {}
      },
      mounted() {
         this.$nextTick(() => {
@@ -46,44 +47,76 @@
      },
      methods: {
         templateWrite() {
            $(function() {
               //配置项
               var options = {
                  container: 'luckysheet',
                  title: "模板编制",
                  lang: "zh",
                  showsheetbar: false,
                  showstatisticBarConfig: {
                     view: false
                  },
            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'
                     order: '0',
                     config: {
                        rowlen: rowlen,
                        columnlen: columnlen
                     }
                  }],
                  enableAddRow: false,
                  row: 100,
                  enableAddBackTop: false,
                  showtoolbarConfig: {
                     chart: false, // '图表'
                     pivotTable: false,  //'数据透视表'
                     protection:false, // '工作表保护'
                  },
                  cellRightClickConfig: {
                     copyAs: false, // 复制为
                     hideRow: false, // 隐藏选中行和显示选中行
                     hideColumn: false, // 隐藏选中列和显示选中列
                     sort: false, // 排序选区
                     filter: false, // 筛选选区
                     chart: false, // 图表生成
                     image: false, // 插入图片
                     matrix: false, // 矩阵操作选区
                  },
                  myFolderUrl: 'http://127.0.0.1/',
                  functionButton: '<button onClick="excelClosed()" class="save">保存</button>'
                  row: 60,
                  column: 26
               }
               luckysheet.create(options)
            })
            }
            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: true, // '减少小数位数'
               numberIncrease: true, // '增加小数位数
               moreFormats: false, // '更多格式'
               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 = '<button onClick="excelClosed()" class="save">保存</button>'
            luckysheet.create(option)
         }
      }
   }
</script>
</script>