| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115 |
- <!DOCTYPE html>
- <html dir="ltr" mozdisallowselectionprint>
- <head>
- <meta charset="utf-8">
- <title>预览excel</title>
- <link rel="stylesheet" href="./excel/pluginsCss.css">
- <link rel="stylesheet" href="./excel/plugins.css">
- <link rel="stylesheet" href="./excel/luckysheet.css">
- <link rel="stylesheet" href="./excel/iconfont.css">
- <script src="./utils/flexible.js"></script>
- <script src="./utils/ui.js"></script>
- <script src="./utils/getQueryVariable.js"></script>
- <script src="./excel/plugin.js"></script>
- <script src="./excel/luckysheet.umd.js"></script>
- <script src="./excel/luckyexcel.umd.js"></script>
- <link rel="resource" type="application/l10n" href="./excel/viewer.properties">
- <link rel="stylesheet" href="./style/ui.css" />
- </head>
- <style type="text/css">
- * {
- padding: 0;
- margin: 0
- }
- body {
- height: 100vh;
- width: 100vw
- }
- #container {
- width: 100%;
- height: calc(100% - 10px);
- font-size: 18px
- }
- </style>
- <script>
- (async () => {
- var e = decodeURIComponent(getQueryVariable("file") || "");
- const loading = createLoading();
- loading.show();
- console.log("excel", e);
- LuckyExcel.transformExcelToLuckyByUrl(e, "测试.xlsl", (t, e) => {
- if (null == t.sheets || 0 === t.sheets.length) console.warn("暂不支持该文件预览"), loading.hide();
- else {
- var o = getQueryVariable("safeBottom"),
- l = (document.getElementById("container").style.height = `calc(100% - ${o}px)`, []);
- for (let e = 0; e < t.sheets.length; e++) l[e] = {
- name: t.sheets[e].name,
- index: t.sheets[e].index,
- order: t.sheets[e].order,
- status: t.sheets[e].status,
- config: t.sheets[e].config
- }, l[e].config.row = 10, 1 === parseInt(t.sheets[e].status) && (l[e].celldata = t
- .sheets[e].celldata), t.sheets[e].index, t.sheets[e].celldata;
- window?.luckysheet.destroy(), window?.luckysheet.create({
- lang: "zh",
- container: "container",
- allowUpdate: !0,
- showtoolbar: !1,
- showinfobar: !1,
- showstatisticBar: !0,
- sheetBottomConfig: !1,
- allowEdit: !1,
- enableAddRow: !1,
- enableAddCol: !1,
- sheetFormulaBar: !1,
- data: t.sheets,
- enableAddBackTop: !0,
- title: t.info.name,
- sheetRightClickConfig: {
- delete: !1,
- copy: !1,
- rename: !1,
- color: !1,
- hide: !1,
- move: !1
- },
- showsheetbarConfig: {
- add: !1
- },
- devicePixelRatio: window.devicePixelRatio,
- defaultFontSize: 20,
- cellRightClickConfig: {
- copy: !1,
- copyAs: !1,
- paste: !1,
- insertRow: !1,
- insertColumn: !1,
- deleteRow: !1,
- deleteColumn: !1,
- deleteCell: !1,
- hideRow: !1,
- hideColumn: !1,
- rowHeight: !1,
- columnWidth: !1,
- clear: !1,
- matrix: !1,
- sort: !1,
- filter: !1,
- chart: !1,
- image: !1,
- link: !1,
- data: !1,
- cellFormat: !1
- }
- });
- loading.hide();
- }
- })
- })()
- </script>
- <body id="body">
- <div id="container"></div>
- </body>
- </html>
|