{"id":2340,"date":"2023-08-12T14:47:02","date_gmt":"2023-08-12T06:47:02","guid":{"rendered":"http:\/\/xinyixx.com\/?p=2340"},"modified":"2023-08-12T14:47:39","modified_gmt":"2023-08-12T06:47:39","slug":"python26","status":"publish","type":"post","link":"https:\/\/www.xinyixx.com\/index.php\/2023\/08\/12\/python26\/","title":{"rendered":"python\u7a0b\u5e8f26\uff1a\u5199\u4e00\u4e2a\u63d0\u53d6word\u6240\u6709\u8868\u683c\u7684\u7a0b\u5e8f"},"content":{"rendered":"<p>\u5de5\u4f5c\u4e0a\u7684\u9700\u8981\uff0c\u81ea\u5df1\u987b\u63d0\u53d6\u4e00\u4e2a\u5927\u578bword\u5185\u6240\u6709\u8868\u683c\u81f3\u6bcf\u4e2aexcel\u4e2d\uff0c\u8fd9\u91cc\u6211\u5728\u4e4b\u524d\u7684\u6587\u7ae0\u4e2d\u63d0\u53ca\u5230\u5173\u4e8epython\u5904\u7406excel\u548cword\u7684\u6a21\u5757\uff0c\u53c2\u8003\u6211\u8fd9\u4e00\u7bc7\u6587\u7ae0\uff1a<a href=\"http:\/\/xinyixx.com\/index.php\/2023\/06\/11\/python13\/\">python\u7a0b\u5e8f13\uff1a\u4e00\u4e2a\u4eceexcel\u63d0\u53d6\u6570\u636e\u7684\u7a0b\u5e8f | \u9ad8\u6cbb\u4e2d\u7684\u4e2a\u4eba\u7a7a\u95f4 (xinyixx.com)<\/a>\u3002<\/p>\n\n\n\n<p>\u548c\u4e4b\u524d\u4e00\u6837\uff0c\u5982\u679c\u6ca1\u6709\u76f8\u5e94\u6a21\u5757\u7684\u8bdd\u9700\u8981\u624b\u52a8\u7528<code>pip install<\/code>\u5bfc\u5165\u76f8\u5bf9\u4e8e\u7684\u6a21\u5757\u3002<\/p>\n\n\n\n<p>\u4e0b\u9762\u662f\u7a0b\u5e8f\u6e90\u7801\uff0c\u5173\u952e\u7684\u4e2d\u6587\u6ce8\u91ca\u5df2\u5217\u51fa:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">import os\nimport docx\nimport openpyxl\nfrom tkinter import filedialog\nfrom tkinter import Tk\n\n# \u9009\u62e9\u8981\u5904\u7406\u7684Word\u6587\u4ef6\nroot = Tk()\nroot.withdraw()\ndocx_path = filedialog.askopenfilename(filetypes=[('Word\u6587\u6863', '*.docx')])\n\n# \u9009\u62e9\u5bfc\u51faExcel\u6587\u4ef6\u7684\u8def\u5f84\nroot = Tk()\nroot.withdraw()\nexcel_folder = filedialog.askdirectory()\n\n# \u521b\u5efaExcel\u6587\u4ef6\u5939\nif not os.path.exists(excel_folder):\n    os.makedirs(excel_folder)\n\n# \u6253\u5f00Word\u6587\u4ef6\ndoc = docx.Document(docx_path)\n\n# \u904d\u5386Word\u6587\u4ef6\u4e2d\u7684\u8868\u683c\nfor table in doc.tables:\n    # \u83b7\u53d6\u8868\u683c\u524d\u4e00\u884c\u7684\u6587\u672c\u4f5c\u4e3aExcel\u6587\u4ef6\u540d\n    table_name = table.rows[0].cells[0].text.strip()\n\n    # \u521b\u5efa\u65b0\u7684Excel\u6587\u4ef6\u5e76\u6253\u5f00\u5de5\u4f5c\u7c3f\n    wb = openpyxl.Workbook()\n    ws = wb.active\n\n    # \u5c06\u8868\u683c\u6570\u636e\u590d\u5236\u5230Excel\u5de5\u4f5c\u8868\u4e2d\n    for i, row in enumerate(table.rows):\n        for j, cell in enumerate(row.cells):\n            cell_text = cell.text.strip()\n            ws.cell(row=i+1, column=j+1, value=cell_text)\n\n    # \u4fdd\u5b58Excel\u6587\u4ef6\n    excel_path = os.path.join(excel_folder, f'{table_name}.xlsx')\n    wb.save(excel_path)\n<\/pre>\n\n\n\n<p>\u6211\u4eec\u5728pycharm\u91cc\u540c\u65f6\u6309ctrl+shift+F10\uff0c\u8fd0\u884c\u6d4b\u8bd5\u4e00\u4e0b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><noscript><img decoding=\"async\" width=\"960\" height=\"540\" src=\"http:\/\/xinyixx.com\/wp-content\/uploads\/2023\/08\/image-65.png\" alt class=\"wp-image-2345\" srcset=\"https:\/\/www.xinyixx.com\/wp-content\/uploads\/2023\/08\/image-65.png 960w, https:\/\/www.xinyixx.com\/wp-content\/uploads\/2023\/08\/image-65-300x169.png 300w, https:\/\/www.xinyixx.com\/wp-content\/uploads\/2023\/08\/image-65-768x432.png 768w\" sizes=\"(max-width: 960px) 100vw, 960px\"><\/noscript><img decoding=\"async\" width=\"960\" height=\"540\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20960%20540%22%3E%3C%2Fsvg%3E\" alt class=\"wp-image-2345 lazyload\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20960%20540%22%3E%3C%2Fsvg%3E 960w\" sizes=\"(max-width: 960px) 100vw, 960px\" data-srcset=\"https:\/\/www.xinyixx.com\/wp-content\/uploads\/2023\/08\/image-65.png 960w, https:\/\/www.xinyixx.com\/wp-content\/uploads\/2023\/08\/image-65-300x169.png 300w, https:\/\/www.xinyixx.com\/wp-content\/uploads\/2023\/08\/image-65-768x432.png 768w\" data-src=\"http:\/\/xinyixx.com\/wp-content\/uploads\/2023\/08\/image-65.png\"><\/figure>\n\n\n\n<p>\u8c03\u7528\u4e86windows\u7684\u7cfb\u7edf\u6a21\u5757\uff0c\u53ef\u4ee5\u81ea\u7531\u9009\u62e9\u67d0\u4e00\u8def\u5f84\u4e0b\u7684word\u683c\u5f0f\u6587\u6863\uff0c\u8fd9\u91cc\u6211\u9009\u62e9\u4e86\u67d0\u4e00\u8ba1\u7b97\u4e66\uff0c\u7136\u540e\u70b9\u51fb\u6253\u5f00\u3002\u968f\u540e\u5f39\u51fa\u9009\u62e9\u8f93\u51fa\u7684\u6587\u4ef6\u5939\uff0c\u53ef\u4ee5\u5728\u7a97\u53e3\u5185\u76f4\u63a5\u65b0\u5efa\u4e00\u4e2a\uff0c\u8fd9\u91cc\u6211\u65b0\u5efa\u4e86\u540d\u5b57\u4e3a13\u7684\u6587\u4ef6\u5939\uff0c<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><noscript><img decoding=\"async\" width=\"960\" height=\"540\" src=\"http:\/\/xinyixx.com\/wp-content\/uploads\/2023\/08\/image-66.png\" alt class=\"wp-image-2346\" srcset=\"https:\/\/www.xinyixx.com\/wp-content\/uploads\/2023\/08\/image-66.png 960w, https:\/\/www.xinyixx.com\/wp-content\/uploads\/2023\/08\/image-66-300x169.png 300w, https:\/\/www.xinyixx.com\/wp-content\/uploads\/2023\/08\/image-66-768x432.png 768w\" sizes=\"(max-width: 960px) 100vw, 960px\"><\/noscript><img decoding=\"async\" width=\"960\" height=\"540\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20960%20540%22%3E%3C%2Fsvg%3E\" alt class=\"wp-image-2346 lazyload\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20960%20540%22%3E%3C%2Fsvg%3E 960w\" sizes=\"(max-width: 960px) 100vw, 960px\" data-srcset=\"https:\/\/www.xinyixx.com\/wp-content\/uploads\/2023\/08\/image-66.png 960w, https:\/\/www.xinyixx.com\/wp-content\/uploads\/2023\/08\/image-66-300x169.png 300w, https:\/\/www.xinyixx.com\/wp-content\/uploads\/2023\/08\/image-66-768x432.png 768w\" data-src=\"http:\/\/xinyixx.com\/wp-content\/uploads\/2023\/08\/image-66.png\"><\/figure>\n\n\n\n<p>\u9009\u62e9\u540e\u7a0b\u5e8f\u5c31\u6267\u884c\u5b8c\u6bd5\u5c06word\u5185\u7684\u6240\u6709\u8868\u683c\u5bfc\u51fa\u523013\u7684\u6587\u4ef6\u5939\u5185\u4e86\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><noscript><img decoding=\"async\" src=\"http:\/\/xinyixx.com\/wp-content\/uploads\/2023\/08\/1691803324925.png\" alt class=\"wp-image-2347\" style=\"width:490px;height:664px\" width=\"490\" height=\"664\" srcset=\"https:\/\/www.xinyixx.com\/wp-content\/uploads\/2023\/08\/1691803324925.png 707w, https:\/\/www.xinyixx.com\/wp-content\/uploads\/2023\/08\/1691803324925-221x300.png 221w\" sizes=\"(max-width: 490px) 100vw, 490px\"><\/noscript><img decoding=\"async\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20490%20664%22%3E%3C%2Fsvg%3E\" alt class=\"wp-image-2347 lazyload\" style=\"width:490px;height:664px\" width=\"490\" height=\"664\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20490%20664%22%3E%3C%2Fsvg%3E 490w\" sizes=\"(max-width: 490px) 100vw, 490px\" data-srcset=\"https:\/\/www.xinyixx.com\/wp-content\/uploads\/2023\/08\/1691803324925.png 707w, https:\/\/www.xinyixx.com\/wp-content\/uploads\/2023\/08\/1691803324925-221x300.png 221w\" data-src=\"http:\/\/xinyixx.com\/wp-content\/uploads\/2023\/08\/1691803324925.png\"><\/figure>\n\n\n\n<p>\u8fd9\u5c31\u5f97\u5230\u4e86\u81ea\u5df1\u9700\u8981\u7684\u8868\u683c\u4fe1\u606f\uff0c\u5982\u679c\u5bf9\u4f60\u6709\u6240\u5e2e\u52a9\uff0c\u81ea\u5df1\u53ef\u4ee5\u7528\u6e90\u7801\u5728\u672c\u5730\u8bd5\u8bd5\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5de5\u4f5c\u4e0a\u7684\u9700\u8981\uff0c\u81ea\u5df1\u987b\u63d0\u53d6\u4e00\u4e2a\u5927\u578bword\u5185\u6240\u6709\u8868\u683c\u81f3\u6bcf\u4e2aexcel\u4e2d\uff0c\u8fd9\u91cc\u6211\u5728\u4e4b\u524d\u7684\u6587\u7ae0\u4e2d\u63d0\u53ca\u5230\u5173\u4e8epytho [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[14,10],"tags":[71,69,77],"class_list":["post-2340","post","type-post","status-publish","format-standard","hentry","category-teacher","category-coding","tag-python","tag-learning","tag-coding","entry"],"_links":{"self":[{"href":"https:\/\/www.xinyixx.com\/index.php\/wp-json\/wp\/v2\/posts\/2340","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.xinyixx.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xinyixx.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xinyixx.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xinyixx.com\/index.php\/wp-json\/wp\/v2\/comments?post=2340"}],"version-history":[{"count":0,"href":"https:\/\/www.xinyixx.com\/index.php\/wp-json\/wp\/v2\/posts\/2340\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.xinyixx.com\/index.php\/wp-json\/wp\/v2\/media?parent=2340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xinyixx.com\/index.php\/wp-json\/wp\/v2\/categories?post=2340"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xinyixx.com\/index.php\/wp-json\/wp\/v2\/tags?post=2340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}