李林
2024-03-13 eb2f43c595f6e0602c74ba8516b6324ffcab3e59
src/components/tool/excel.vue
@@ -33,10 +33,11 @@
</template>
<script>
// import { data } from 'jquery';
   export default {
      props: ['data','title'],
      data() {
         return {
            data: {}
         }
      },
      mounted() {
@@ -46,43 +47,50 @@
      },
      methods: {
         templateWrite() {
            $(function() {
               //配置项
               var options = {
                  container: 'luckysheet',
                  title: "模板编制",
                  lang: "zh",
                  showsheetbar: false,
                  showstatisticBarConfig: {
                     view: false
                  },
                  data: [{
                     name: '模板',
                     order: '0'
                  }],
                  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>'
               }
               luckysheet.create(options)
            })
            if(this.data!=null&&this.data!=''){
               let option = JSON.parse(this.data)
               option.title = this.title
               luckysheet.create(option)
            }else{
               $(function() {
                  //配置项
                  var options = {
                     container: 'luckysheet',
                     title: this.title,
                     lang: "zh",
                     showsheetbar: false,
                     showstatisticBarConfig: {
                        view: false
                     },
                     data: [{
                        name: '模板',
                        order: '0'
                     }],
                     enableAddRow: false,
                     row: 100,
                     column: 26,
                     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>'
                  }
                  luckysheet.create(options)
               })
            }
         }
      }
   }