ZhuJiaHao
/
zdqy_firm_former


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143
							<!DOCTYPE html>
<html lang="zh-CN">
<head>
  <meta charset="utf-8">
  <link rel='stylesheet' href='lib/luckysheet/plugins/css/pluginsCss.css' />
  <link rel='stylesheet' href='lib/luckysheet/plugins/plugins.css' />
  <link rel='stylesheet' href='lib/luckysheet/css/luckysheet.css' />
  <link rel='stylesheet' href='lib/luckysheet/assets/iconfont/iconfont.css' />
  <script src="lib/luckysheet/plugins/js/plugin.js"></script>
  <script src="lib/luckysheet/luckysheet.umd.js"></script>
  <style>
    body, html {
      margin: 0;
      padding: 0;
      width: 100%;
      height: 100%;
      overflow: hidden;
    }
    #luckysheet {
      margin: 0;
      padding: 0;
      width: 100%;
      height: 100%;
    }
  </style>
</head>
<body>
  <div id="luckysheet"></div>
  <script>
    let isInitialized = false
    
    window.addEventListener('message', function(event) {
      const { type, data, readonly } = event.data
      
      if (type === 'init' && !isInitialized) {
        luckysheet.create({
          container: 'luckysheet',
          lang: 'zh', // 设置中文语言，工具栏提示为中文
          // 控制顶部工具栏显示：
          // - readonly=true (查阅模式): showtoolbar=false 隐藏工具栏
          // - readonly=false (添加/编辑模式): showtoolbar=true 显示工具栏
          showtoolbar: !readonly,
          showinfobar: false,
          showsheetbar: true,
          // 控制是否允许增加行/列
          enableAddRow: !readonly,
          enableAddCol: !readonly,
          userInfo: false,
          // 状态栏设置（包含缩放控制）：
          // - showstatisticBar: true 显示状态栏（包含缩放控制）
          showstatisticBar: true,
          // 控制编辑栏显示：
          // - readonly=true: sheetFormulaBar=false 隐藏编辑栏
          // - readonly=false: sheetFormulaBar=true 显示编辑栏
          sheetFormulaBar: !readonly,
          allowEdit: !readonly,
          // 启用缩放控制 - 优化配置
          showtoolbarConfig: {
            zoom: true,  // 启用缩放控制，包括右下角的缩放组件
          },
          // 缩放比例配置
          zoomRatio: {
            default: 100,  // 默认缩放比例
            max: 400,      // 最大缩放比例
            min: 10        // 最小缩放比例
          },
          // 显示行号列标
          showRowBar: true,
          showColumnBar: true,
          // 单元格右键菜单
          cellRightClickConfig: {
            copy: true,
            paste: true,
            insertRow: !readonly,
            insertColumn: !readonly,
            deleteRow: !readonly,
            deleteColumn: !readonly,
            hideRow: !readonly,
            hideColumn: !readonly,
            rowHeight: !readonly,
            columnWidth: !readonly
          },
          data: data || [{ name: 'Sheet1', color: '', status: 1, order: 0, data: [[{ v: '' }]] }],
          hook: {}
        })
        isInitialized = true
      } else if (type === 'getData') {
        const data = luckysheet.getAllSheets()
        event.source.postMessage({ type: 'dataResult', data: data }, event.origin)
      } else if (type === 'setData') {
        luckysheet.destroy()
        isInitialized = false
        luckysheet.create({
          container: 'luckysheet',
          lang: 'zh',
          showtoolbar: !readonly,
          showinfobar: false,
          showsheetbar: true,
          enableAddRow: !readonly,
          enableAddCol: !readonly,
          userInfo: false,
          showstatisticBar: true,
          sheetFormulaBar: !readonly,
          allowEdit: !readonly,
          // 启用缩放控制 - 优化配置
          showtoolbarConfig: {
            zoom: true,  // 启用缩放控制，包括右下角的缩放组件
          },
          // 缩放比例配置
          zoomRatio: {
            default: 100,  // 默认缩放比例
            max: 400,      // 最大缩放比例
            min: 10        // 最小缩放比例
          },
          // 显示行号列标
          showRowBar: true,
          showColumnBar: true,
          // 单元格右键菜单
          cellRightClickConfig: {
            copy: true,
            paste: true,
            insertRow: !readonly,
            insertColumn: !readonly,
            deleteRow: !readonly,
            deleteColumn: !readonly,
            hideRow: !readonly,
            hideColumn: !readonly,
            rowHeight: !readonly,
            columnWidth: !readonly
          },
          data: data,
          hook: {}
        })
        isInitialized = true

      }
    })
    
    // 通知父页面已准备好
    window.parent.postMessage({ type: 'ready' }, '*')
  </script>
</body>
</html>