{"id":28031,"date":"2024-11-24T10:09:18","date_gmt":"2024-11-24T02:09:18","guid":{"rendered":"https:\/\/fwq.ai\/blog\/28031\/"},"modified":"2024-11-24T10:09:18","modified_gmt":"2024-11-24T02:09:18","slug":"%e5%a6%82%e4%bd%95%e7%94%a8%e5%89%8d%e7%ab%af%e5%ae%9e%e7%8e%b0%e5%8f%af%e7%bc%96%e8%be%91%e7%9a%84excel%e5%af%bc%e5%87%ba%e6%96%b9%e6%a1%88%ef%bc%9f","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/28031\/","title":{"rendered":"\u5982\u4f55\u7528\u524d\u7aef\u5b9e\u73b0\u53ef\u7f16\u8f91\u7684Excel\u5bfc\u51fa\u65b9\u6848\uff1f"},"content":{"rendered":"

\"\u5982\u4f55\u7528\u524d\u7aef\u5b9e\u73b0\u53ef\u7f16\u8f91\u7684Excel\u5bfc\u51fa\u65b9\u6848\uff1f\u63d2\u56fe\"<\/p>\n

\u5c01\u88c5\u524d\u7aefexcel\u5bfc\u51fa\u65b9\u6848\uff0c\u5b9e\u73b0\u5355\u5143\u683c\u7f16\u8f91<\/strong><\/p>\n

\u5728\u524d\u7aef\u5f00\u53d1\u4e2d\uff0c\u5bfc\u51faExcel\u8868\u683c\u7684\u9700\u6c42\u5341\u5206\u5e38\u89c1\u3002\u57fa\u4e8eXSLX\u5e93\u7684\u5bfc\u51fa\u65b9\u6848\u867d\u7136\u7b80\u5355\u6613\u7528\uff0c\u4f46\u96be\u4ee5\u6ee1\u8db3\u590d\u6742\u7684\u6837\u5f0f\u5b9a\u5236\u548c\u5355\u5143\u683c\u7f16\u8f91\u9700\u6c42\u3002\u672c\u6587\u5c06\u4ecb\u7ecd\u4e00\u79cd\u5c01\u88c5\u524d\u7aefExcel\u5bfc\u51fa\u65b9\u6848\u7684\u65b9\u5f0f\uff0c\u5b9e\u73b0\u5355\u5143\u683c\u7f16\u8f91\u7684\u53ef\u884c\u6027\u3002<\/p>\n

\u5c01\u88c5\u601d\u8def<\/strong><\/p>\n

\u6784\u5efaExcel\u548c\u8868\u683c\u5143\u7d20\u4e4b\u95f4\u7684\u5173\u8054\uff0c\u4f7f\u7528new Blob()\u6784\u9020\u51fd\u6570\u4f5c\u4e3a\u6865\u6881\u3002\u8be5\u601d\u8def\u7c7b\u4f3c\u4e8e\u4ee5\u4e0b\u793a\u4f8b\uff1a<\/p>\n

<!DOCTYPE html>\n<html lang=\"en\">\n\n<head>\n  <meta charset=\"UTF-8\">\n  <title>HTML Table Example<\/title>\n<\/head>\n\n<body>\n  <table border=\"1\">\n    <colgroup>\n      <col width=\"100\" \/>\n      <col width=\"150\" \/>\n      <col width=\"200\" \/>\n    <\/colgroup>\n    <thead>\n      <th style=\"background-color: pink\">\u59d3\u540d<\/th>\n      <th style=\"background-color: pink\">\u5e74\u9f84<\/th>\n      <th style=\"background-color: pink\">\u804c\u4f4d<\/th>\n    <\/thead>\n    <tbody>\n      <tr>\n        <td>\u5f20\u4e09<\/td>\n        <td>28<\/td>\n        <td>\u5de5\u7a0b\u5e08<\/td>\n      <\/tr>\n      <tr>\n        <td>\u674e\u56db<\/td>\n        <td>35<\/td>\n        <td>\u533b\u751f<\/td>\n      <\/tr>\n      <tr>\n        <td>\u738b\u4e94<\/td>\n        <td>22<\/td>\n        <td>\u5b66\u751f<\/td>\n      <\/tr>\n    <\/tbody>\n  <\/table>\n\n  <script>\n    \/\/ \u83b7\u53d6table\u5143\u7d20  \n    var tableElement = document.querySelector('table');\n\n    \/\/ \u83b7\u53d6table\u5143\u7d20\u7684domString\u8868\u793a  \n    var tableDomString = tableElement.outerHTML;\n    const blob = new Blob([tableDomString], { type: \"application\/vnd.ms-excel\" });\n    \/\/ \u521b\u5efa\u4e00\u4e2a <a> \u5143\u7d20\u7528\u4e8e\u4e0b\u8f7d Excel \u6587\u4ef6\n    const a = document.createElement(\"a\");\n    a.href = URL.createObjectURL(blob);\n    a.download = 'test2' + '.xlsx'; \/\/ \u8bbe\u7f6e\u4e0b\u8f7d\u6587\u4ef6\u7684\u540d\u79f0\n    \/\/ \u89e6\u53d1\u70b9\u51fb\u4e0b\u8f7d\n    a.click();\n    a.remove();\n  <\/script>\n<\/body>\n\n<\/html><\/pre>\n
 \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
\u8be5\u65b9\u6848\u53ef\u4ee5\u751f\u6210\u6b63\u786e\u7684Excel\u6587\u4ef6\uff0c\u4f46\u65e0\u6cd5\u5b9e\u73b0\u5355\u5143\u683c\u7f16\u8f91\u3002<\/p>\n
\u7acb\u5373\u5b66\u4e60<\/span>\u201c\u201d\uff1b<\/p>\n
\u53ef\u7f16\u8f91\u5355\u5143\u683c<\/strong><\/p>\n
\u8981\u5b9e\u73b0\u5355\u5143\u683c\u7f16\u8f91\uff0c\u63a8\u8350\u4f7f\u7528ExcelJS\u5e93\u3002\u8fd9\u662f\u4e00\u4e2a\u529f\u80fd\u5f3a\u5927\u7684Excel\u5904\u7406\u5e93\uff0c\u53ef\u4ee5\u8f7b\u677e\u5730\u5b9e\u73b0\u5355\u5143\u683c\u6dfb\u52a0\u3001\u4fee\u6539\u7b49\u64cd\u4f5c\u3002<\/p>\n
\u4f8b\u5982\uff0c\u4ee5\u4e0b\u4ee3\u7801\u53ef\u4ee5\u5411Excel\u5de5\u4f5c\u8868\u4e2d\u6dfb\u52a0\u4e00\u884c\uff1a<\/p>\n
const worksheet = workbook.addWorksheet('My Sheet');\nworksheet.addRow(['A1', 'B1', 'C1']);<\/pre>\n
 \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
\u66f4\u591a\u5173\u4e8eExcelJS\u5e93\u7684\u7528\u6cd5\uff0c\u8bf7\u53c2\u8003\u5b98\u65b9\u6587\u6863\u3002<\/p>\n
\u603b\u7ed3<\/strong><\/p>\n
\u672c\u6587\u4ecb\u7ecd\u4e86\u4e00\u79cd\u5c01\u88c5\u524d\u7aefExcel\u5bfc\u51fa\u65b9\u6848\u7684\u65b9\u6cd5\uff0c\u5e76\u63d0\u51fa\u4e86\u4f7f\u7528ExcelJS\u5e93\u5b9e\u73b0\u5355\u5143\u683c\u7f16\u8f91\u7684\u5efa\u8bae\u3002<\/p>\n
\u4ee5\u4e0a\u5c31\u662f\u5982\u4f55\u7528\u524d\u7aef\u5b9e\u73b0\u53ef\u7f16\u8f91\u7684Excel\u5bfc\u51fa\u65b9\u6848\uff1f\u7684\u8be6\u7ec6\u5185\u5bb9\uff0c\u66f4\u591a\u8bf7\u5173\u6ce8\u7c73\u4e91\u5176\u5b83\u76f8\u5173\u6587\u7ae0\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5c01\u88c5\u524d\u7aefexcel\u5bfc\u51fa\u65b9\u6848\uff0c\u5b9e\u73b0\u5355\u5143\u683c\u7f16\u8f91 \u5728\u524d\u7aef\u5f00\u53d1\u4e2d\uff0c\u5bfc\u51faExcel\u8868\u683c\u7684\u9700\u6c42\u5341\u5206\u5e38\u89c1\u3002\u57fa\u4e8eXSLX\u5e93\u7684\u5bfc\u51fa\u65b9\u6848\u867d\u7136\u7b80\u5355\u6613\u7528\uff0c\u4f46\u96be\u4ee5\u6ee1\u8db3\u590d\u6742\u7684\u6837\u5f0f\u5b9a\u5236\u548c\u5355\u5143\u683c\u7f16\u8f91\u9700\u6c42\u3002\u672c\u6587\u5c06\u4ecb\u7ecd\u4e00\u79cd\u5c01\u88c5\u524d\u7aefExcel\u5bfc\u51fa\u65b9\u6848\u7684\u65b9\u5f0f\uff0c\u5b9e\u73b0\u5355\u5143\u683c\u7f16\u8f91\u7684\u53ef\u884c\u6027\u3002 \u5c01\u88c5\u601d\u8def \u6784\u5efaExcel\u548c\u8868\u683c\u5143\u7d20\u4e4b\u95f4\u7684\u5173\u8054\uff0c\u4f7f\u7528new Blob()\u6784\u9020\u51fd\u6570\u4f5c\u4e3a\u6865\u6881\u3002\u8be5\u601d\u8def\u7c7b\u4f3c\u4e8e\u4ee5\u4e0b\u793a\u4f8b\uff1a <!DOCTYPE html> <html lang=”en”> <head> <meta charset=”UTF-8″> <title>HTML Table Example<\/title> <\/head> <body> <table border=”1″> <colgroup> <col width=”100″ \/> <col width=”150″ \/> <col width=”200″ \/> <\/colgroup> <thead> <th style=”background-color: pink”>\u59d3\u540d<\/th> <th style=”background-color: pink”>\u5e74\u9f84<\/th> <th style=”background-color: pink”>\u804c\u4f4d<\/th> <\/thead> <tbody> <tr> <td>\u5f20\u4e09<\/td> <td>28<\/td> <td>\u5de5\u7a0b\u5e08<\/td> <\/tr> <tr> <td>\u674e\u56db<\/td> <td>35<\/td> <td>\u533b\u751f<\/td> <\/tr> <tr> <td>\u738b\u4e94<\/td> <td>22<\/td> […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-28031","post","type-post","status-publish","format-standard","hentry","category-16"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/28031","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/comments?post=28031"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/28031\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=28031"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=28031"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=28031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}