excel.html 3.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115
  1. <!DOCTYPE html>
  2. <html dir="ltr" mozdisallowselectionprint>
  3. <head>
  4. <meta charset="utf-8">
  5. <title>预览excel</title>
  6. <link rel="stylesheet" href="./excel/pluginsCss.css">
  7. <link rel="stylesheet" href="./excel/plugins.css">
  8. <link rel="stylesheet" href="./excel/luckysheet.css">
  9. <link rel="stylesheet" href="./excel/iconfont.css">
  10. <script src="./utils/flexible.js"></script>
  11. <script src="./utils/ui.js"></script>
  12. <script src="./utils/getQueryVariable.js"></script>
  13. <script src="./excel/plugin.js"></script>
  14. <script src="./excel/luckysheet.umd.js"></script>
  15. <script src="./excel/luckyexcel.umd.js"></script>
  16. <link rel="resource" type="application/l10n" href="./excel/viewer.properties">
  17. <link rel="stylesheet" href="./style/ui.css" />
  18. </head>
  19. <style type="text/css">
  20. * {
  21. padding: 0;
  22. margin: 0
  23. }
  24. body {
  25. height: 100vh;
  26. width: 100vw
  27. }
  28. #container {
  29. width: 100%;
  30. height: calc(100% - 10px);
  31. font-size: 18px
  32. }
  33. </style>
  34. <script>
  35. (async () => {
  36. var e = decodeURIComponent(getQueryVariable("file") || "");
  37. const loading = createLoading();
  38. loading.show();
  39. console.log("excel", e);
  40. LuckyExcel.transformExcelToLuckyByUrl(e, "测试.xlsl", (t, e) => {
  41. if (null == t.sheets || 0 === t.sheets.length) console.warn("暂不支持该文件预览"), loading.hide();
  42. else {
  43. var o = getQueryVariable("safeBottom"),
  44. l = (document.getElementById("container").style.height = `calc(100% - ${o}px)`, []);
  45. for (let e = 0; e < t.sheets.length; e++) l[e] = {
  46. name: t.sheets[e].name,
  47. index: t.sheets[e].index,
  48. order: t.sheets[e].order,
  49. status: t.sheets[e].status,
  50. config: t.sheets[e].config
  51. }, l[e].config.row = 10, 1 === parseInt(t.sheets[e].status) && (l[e].celldata = t
  52. .sheets[e].celldata), t.sheets[e].index, t.sheets[e].celldata;
  53. window?.luckysheet.destroy(), window?.luckysheet.create({
  54. lang: "zh",
  55. container: "container",
  56. allowUpdate: !0,
  57. showtoolbar: !1,
  58. showinfobar: !1,
  59. showstatisticBar: !0,
  60. sheetBottomConfig: !1,
  61. allowEdit: !1,
  62. enableAddRow: !1,
  63. enableAddCol: !1,
  64. sheetFormulaBar: !1,
  65. data: t.sheets,
  66. enableAddBackTop: !0,
  67. title: t.info.name,
  68. sheetRightClickConfig: {
  69. delete: !1,
  70. copy: !1,
  71. rename: !1,
  72. color: !1,
  73. hide: !1,
  74. move: !1
  75. },
  76. showsheetbarConfig: {
  77. add: !1
  78. },
  79. devicePixelRatio: window.devicePixelRatio,
  80. defaultFontSize: 20,
  81. cellRightClickConfig: {
  82. copy: !1,
  83. copyAs: !1,
  84. paste: !1,
  85. insertRow: !1,
  86. insertColumn: !1,
  87. deleteRow: !1,
  88. deleteColumn: !1,
  89. deleteCell: !1,
  90. hideRow: !1,
  91. hideColumn: !1,
  92. rowHeight: !1,
  93. columnWidth: !1,
  94. clear: !1,
  95. matrix: !1,
  96. sort: !1,
  97. filter: !1,
  98. chart: !1,
  99. image: !1,
  100. link: !1,
  101. data: !1,
  102. cellFormat: !1
  103. }
  104. });
  105. loading.hide();
  106. }
  107. })
  108. })()
  109. </script>
  110. <body id="body">
  111. <div id="container"></div>
  112. </body>
  113. </html>