📄 export.js
字号:
function AllAreaWord() { if (document.all("tab").rows.length == 0) { alert("\u6ca1\u6709\u5185\u5bb9\u53ef\u5bfc\uff01"); return; } try { var oWD = new ActiveXObject("Word.Application"); } catch (e) { alert("\u65e0\u6cd5\u8c03\u7528Office\u5bf9\u8c61\uff0c\u8bf7\u786e\u4fdd\u60a8\u7684\u673a\u5668\u5df2\u5b89\u88c5\u4e86Office\u5e76\u5df2\u5c06\u672c\u7cfb\u7edf\u7684\u7ad9\u70b9\u540d\u52a0\u5165\u5230IE\u7684\u4fe1\u4efb\u7ad9\u70b9\u5217\u8868\u4e2d\uff01"); return; } var oDC = oWD.Documents.Add("", 0, 1); var oRange = oDC.Range(0, 1); var sel = document.body.createTextRange(); sel.moveToElementText(tab); //tab 为导出数据所在的表格ID sel.select(); sel.execCommand("Copy"); oRange.Paste(); oWD.Application.Visible = true;}function AutomateExcel() { var elTable = document.getElementById("tab"); //outtable 为导出数据所在的表格ID; var oRangeRef = document.body.createTextRange(); oRangeRef.moveToElementText(elTable); oRangeRef.execCommand("Copy"); try { var appExcel = new ActiveXObject("Excel.Application"); } catch (e) { alert("\u65e0\u6cd5\u8c03\u7528Office\u5bf9\u8c61\uff0c\u8bf7\u786e\u4fdd\u60a8\u7684\u673a\u5668\u5df2\u5b89\u88c5\u4e86Office\u5e76\u5df2\u5c06\u672c\u7cfb\u7edf\u7684\u7ad9\u70b9\u540d\u52a0\u5165\u5230IE\u7684\u4fe1\u4efb\u7ad9\u70b9\u5217\u8868\u4e2d\uff01"); return; } appExcel.Visible = true; appExcel.Workbooks.Add().Worksheets.Item(1).Paste(); appExcel = null;}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -