{"id":316,"date":"2021-09-15T11:34:41","date_gmt":"2021-09-15T03:34:41","guid":{"rendered":"https:\/\/hisui.cn\/?p=316"},"modified":"2025-11-27T17:46:08","modified_gmt":"2025-11-27T09:46:08","slug":"%e4%b8%ad%e9%97%b4%e4%bb%b6%e8%b0%83%e7%94%a8excel%e6%89%93%e5%8d%b0%e9%97%ae%e9%a2%98","status":"publish","type":"post","link":"http:\/\/hisui.cn\/?p=316","title":{"rendered":"\u4e2d\u95f4\u4ef6\u8c03\u7528Excel\u6253\u5370\u95ee\u9898"},"content":{"rendered":"

\u4e2d\u95f4\u4ef6\u8c03\u7528Excel\u6253\u5370\u95ee\u9898<\/h2>\n
\n

\u4f7f\u7528\u3010\u533b\u4e3a\u5ba2\u6237\u7aef\u3011\u7a0b\u5e8f\u8c03\u7528Excel\u6253\u5370\u529f\u80fd\u65f6\uff0c\u8fd4\u56de\uff1a\u5904\u7406\u8bf7\u6c42\u5f02\u5e38\uff1aAutomation\u670d\u52a1\u5668\u4e0d\u80fd\u521b\u5efa\u5bf9\u8c61\u95ee\u9898<\/code>,\u662f\u56e0\u4e3aWPS\u5b89\u88c5\u662f\u5f53\u524d\u7528\u6237\u7ea7\u522b\u662f\u5b89\u88c5\uff0c\u6240\u4ee5\u9700\u8981\u4f7f\u7528\u5f53\u524d\u7528\u6237\u6743\u9650\u8c03\u7528\uff0c\u800c\u4e0d\u80fd\u4f7f\u7528Administrator\u8c03\u7528\u3002\u5904\u7406\u529e\u6cd5\u5982\u4e0b\uff1a<\/p>\n

\u4e00.\u67e5\u770b\u5f53\u524d\u6253\u5370\u7535\u8111\u7684\u3010\u533b\u4e3a\u5ba2\u6237\u7aef\u3011\u7684\u7248\u672c<\/h3>\n

\u786e\u4fdd\u5ba2\u6237\u7aef\u7684\u7248\u672c\u53f7\u4e3a1.0.0.30\u6216\u4ee5\u4e0a\u7248\u672c\u3002<\/p>\n

\u4e8c.\u63d2\u4ef6\u7ba1\u7406\u914d\u7f6e\u65b9\u6cd5<\/h3>\n

\u8fdb\u5165iMedical – demo\u7684\u5934\u83dc\u5355\u627e\u5230\u3010\u5f00\u53d1\u5de5\u5177\u7ba1\u7406\u3011\u754c\u9762\uff0c\u627e\u5230\u3010\u63d2\u4ef6\u7ba1\u7406Chrome\u3011\u914d\u7f6e\u754c\u9762,\u627e\u5230CmdShell\u8bb0\u5f55\uff0c\u4e3a\u5176\u589e\u52a0CurrentUserEvalJs\u65b9\u6cd5,\u5982\u4e0b\u56fe\uff1a
\n\"\u589e\u52a0\u65b9\u6cd5\"<\/p>\n

\u4e09.\u8c03\u7528\u6253\u5370\u65f6\u4fee\u6539<\/h3>\n

js\u4ee3\u7801\u4e2d\u8c03\u7528\u65b9\u6cd5\u4eceEvalJs<\/del>\u4fee\u6539\u6210CurrentUserEvalJs<\/code>\u65b9\u6cd5<\/p>\n

\/\/...\n\/\/ CmdShell.EvalJs(excelStr)\u4fee\u6539\u6210\u4e0b\u9762\u65b9\u6cd5\nCmdShell.CurrentUserEvalJs(excelStr);\n<\/code><\/pre>\n
\"\u4fee\u6539\u65b9\u6cd5\"<\/p>\n
\u4fee\u6539\u5b8c\u6210\u540e\uff0c\u518d\u6d4b\u8bd5\u6253\u5370\u6216\u5bfc\u51fa\u3002<\/p>\n
\u4f7f\u7528\u670d\u52a1\u5668\u6a21\u677f\u5bfc\u51fa\u65e0\u53cd\u5e94\u95ee\u9898<\/h2>\n
\u95ee\u9898\u8bf4\u660e\uff1a<\/p>\n
\n  \u4f7f\u7528\u4e2d\u95f4\u4ef6\u4ee3\u7801\uff0c\u5bfc\u51faExcel\u65e0\u53cd\u5e94\n<\/p><\/blockquote>\n
\u95ee\u9898\u89e3\u51b3\uff1a<\/p>\n
\n
    \n
  1. demo – \u914d\u7f6e\u7ba1\u7406 – \u6a21\u677f\u8def\u5f84\uff0c\u5982\u679c\u662fhttps\u5f00\u5934\uff0c\u5219\u8981\u4e3a\u6bcf\u53f0\u5ba2\u6237\u7aef\u5b89\u88c5https\u8bc1\u4e66\uff0c\u5426\u5219\u65e0\u53cd\u5e94<\/p>\n<\/li>\n
  2. \n
    \u4fee\u6539JS\u4ee3\u7801\uff0c\u4f7f\u7528JS\u6765\u5199\u6253\u5370\u7684\u6240\u6709\u5185\u5bb9\uff0c\u4e0d\u4f7f\u7528XLS\u6a21\u677f\u5bfc\u51fa<\/p>\n<\/li>\n<\/ol>\n<\/blockquote>\n
    9.0\u4ee5\u4e0a\u4e2d\u95f4\u4ef6\u8c03\u7528Excel\u6253\u5370\u6ca1\u6709\u53cd\u5e94<\/h2>\n
    \u89e3\u91ca\u4e0b\uff0c\u4e3a\u5565\u4e4b\u524d\u7684\u6709\u7684\u7535\u8111\u4e0d\u6210\u529f\u3002ResultSetType: ExcelPlugin\u4f7f\u7528\u4e86\u63d2\u4ef6\u3002\u7535\u8111\u5fc5\u987b\u5b89\u88c5Excel\u6216\u8005wps\u3002\u540c\u65f6\u53d7\u7528\u6237\u6743\u9650\u5f71\u54cd\u3002\u6709\u7684\u65f6\u5019\uff0c\u5fc5\u987b\u7535\u8111\u7ba1\u7406\u5458\uff0c\u624d\u80fd\u8fd0\u884c\u6210\u529f\u3002
    \n1\u3001\u9700\u8981\u6539\u4ee3\u7801\uff0c\u6539\u5b8c\u540e\uff0c\u4e0d\u9700\u8981\u6709excel\u6216\u8005wps\u4e5f\u80fd\u5bfc\u51fa
    \n2\u3001\u4e0d\u6539\u4ee3\u7801\uff0c\u9700\u8981\u53bb\u5b89\u88c5excel\u6216\u8005wsp\u5c31\u53ef\u4ee5\u5bfc\u51fa\u3002\u5f02\u5e38\u7684\u662f\u7535\u8111\u6743\u9650\u95ee\u9898<\/p>\n
    \u6539\u4ee3\u7801\uff1a<\/h3>\n
    \u6d4b\u8bd5\u4e0b\u6765 grid2excel \u5bfc\u51faExcel\u662f\u652f\u6301\u7684\u6700\u597d\u7684\u3002
    \n\u5bfc\u51fa\u9875\u9762\u7684\u4ea7\u54c1\u7ec4\u4fee\u6539\uff1a
    \ncsp\u5f15\u5165<\/p>\n
    <script type=\"text\/javascript\" src=\"..\/scripts_lib\/xlsx\/grid2excel.js\" charset=\"utf-8\"><\/script>\n<\/code><\/pre>\n
    js \u4ee3\u7801\uff1a\u4fee\u6539 hisui\u7684datagride\u7684id ‘#tDHCSSuserLogonLog’ filename: ‘\u7528\u6237\u767b\u5165\u65e5\u5fd7\u6c47\u603b\u6570\u636e’ :<\/p>\n
    grid2excel($('#tDHCSSuserLogonLog'), {\n    IE11IsLowIE: false, filename: '\u7528\u6237\u767b\u5165\u65e5\u5fd7\u6c47\u603b\u6570\u636e', allPage: true\n    , callback:\n        function (success, data) {\n            if (success) {\n                $.messager.popover({ msg: '\u5bfc\u51fa\u6210\u529f ', type: 'success' });\n            } else {\n                $.messager.popover({ msg: '\u5bfc\u51fa\u5931\u8d25 ', type: 'error' });\n            }\n            $.messager.progress('close');\n        }\n});\n<\/code><\/pre>\n
    \u5176\u4ed6\u95ee\u9898\u6bd4\u8f83\u8bb0\u5f55\uff1a
    \n* \u591a\u9875\u6570\u636e\uff0c\u9ed8\u8ba4\u53ea\u5bfc\u51fa\u4e86\uff0c\u67e5\u8be2\u7684\u7b2c\u4e00\u9875\u3002\u5c11\u4e86\u5176\u4ed6\u9875\u6570\u7684\u6570\u636e,\u95ee\u9898\u89e3\u51b3\u8bb0\u5f55\uff1a
    \n    \u53d1\u73b0\u8fd8\u662f\u53ea\u6709\u4e00\u9875\uff0c\u662f\u4ea7\u54c1\u7ec4\u7684datagride\u6ca1\u6709\u7ed1\u5b9aquery\u5230options\u3002
    \n    \u89e3\u51b3\u65b9\u6cd5\uff1acfg.customRows<\/code> \u4f7f\u7528\u8fd9\u4e2a\u53c2\u6570\uff0c\u5148\u6267\u884c\u4ed6\u4eec\u7684\u67e5\u8be2\u4ee3\u7801\uff0c\u518d\u628a\u6570\u636e\u5f53\u505a\u5165\u53c2\u9001\u8fdb\u6765<\/p>\n
    grid2excel($('#tDHCSSuserLogonLog'), {\n    customRows:data\n    IE11IsLowIE: false,\n    filename: '\u7528\u6237\u767b\u5165\u65e5\u5fd7\u6c47\u603b\u6570\u636e',\n    allPage: true....\n})\n<\/code><\/pre>\n