{"id":340,"date":"2025-03-31T18:00:18","date_gmt":"2025-03-31T10:00:18","guid":{"rendered":"https:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/"},"modified":"2025-03-31T18:00:18","modified_gmt":"2025-03-31T10:00:18","slug":"python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8","status":"publish","type":"post","link":"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/","title":{"rendered":"python\u81ea\u52a8\u5316\u529e\u516c\u2014\u2014python\u64cd\u4f5cExcel\u3001Word\u3001PDF\u96c6\u5408\u5927\u5168"},"content":{"rendered":"<div class=\"article_content clearfix\" id=\"article_content\">\n <link href=\"https:\/\/csdnimg.cn\/release\/blogv2\/dist\/mdeditor\/css\/editerView\/kdoc_html_views-1a98987dfd.css\" rel=\"stylesheet\"\/>\n <link href=\"https:\/\/csdnimg.cn\/release\/blogv2\/dist\/mdeditor\/css\/editerView\/ck_htmledit_views-704d5b9767.css\" rel=\"stylesheet\"\/>\n<div class=\"markdown_views prism-atom-one-dark\" id=\"content_views\">\n  <svg style=\"display: none;\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n   <path d=\"M5,0 0,2.5 5,5z\" id=\"raphael-marker-block\" stroke-linecap=\"round\" style=\"-webkit-tap-highlight-color: rgba(0, 0, 0, 0);\">\n   <\/path>\n  <\/svg><\/p>\n<blockquote>\n<p>\n    \u672c\u6587\u662f\u9274\u4e8e\u6709\u4e9b\u7c89\u4e1d\u7684\u5de5\u4f5c\u9700\u6c42\uff0c\u6709\u65f6\u5019\u9700\u8981\u9047\u5230\u8fd9\u4e9b\u6587\u4ef6\u7684\u5904\u7406\u3002\u56e0\u6b64\uff0c\u6211\u5199\u4e86\u4e00\u4e2a\u6587\u7ae0\u96c6\u5408\uff0c\u4f9b\u5927\u5bb6\u53c2\u8003\uff0c\u6574\u7bc7\u6587\u7ae0\u5df2\u7ecf\u6574\u7406\u6210\u4e66\u518c\u3002\ud83d\udc47\ud83d\udc47\ud83d\udc47<br \/>\n    <br \/>\n    <font color=\"red\" face=\"\u5fae\u8f6f\u96c5\u9ed1\" size=\"3\"><br \/>\n     <a href=\"https:\/\/item.jd.com\/13199681.html\" rel=\"nofollow\"><br \/>\n      \u6233\u6211\u9886\u53d6\u300aPython\u81ea\u52a8\u5316\u5927\u5168\u300b<br \/>\n     <\/a><br \/>\n    <\/font><br \/>\n    <br \/>\n    <font color=\"red\" face=\"\u5fae\u8f6f\u96c5\u9ed1\" size=\"3\"><br \/>\n     <a href=\"https:\/\/item.jd.com\/13199681.html\" rel=\"nofollow\"><br \/>\n      \u6233\u6211\u9886\u53d6\u300aPython\u81ea\u52a8\u5316\u5927\u5168\u300b<br \/>\n     <\/a><br \/>\n    <\/font><br \/>\n    <br \/>\n    <font color=\"red\" face=\"\u5fae\u8f6f\u96c5\u9ed1\" size=\"3\"><br \/>\n     <a href=\"https:\/\/item.jd.com\/13199681.html\" rel=\"nofollow\"><br \/>\n      \u6233\u6211\u9886\u53d6\u300aPython\u81ea\u52a8\u5316\u5927\u5168\u300b<br \/>\n     <\/a><br \/>\n    <\/font><br \/>\n    \n   <\/p>\n<\/blockquote>\n<h5>\n   <a id=\"_7\"><br \/>\n   <\/a><br \/>\n   \u76ee\u5f55<br \/>\n  <\/h5>\n<p>\n   <a href=\"#jump1\" rel=\"nofollow\"><br \/>\n    \u7ae0\u8282\u4e00\uff1apython\u4f7f\u7528openpyxl\u64cd\u4f5cexcel<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump2\" rel=\"nofollow\"><br \/>\n    1\u3001openpyxl\u5e93\u4ecb\u7ecd<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump2\" rel=\"nofollow\"><br \/>\n    2\u3001python\u600e\u4e48\u6253\u5f00\u53ca\u8bfb\u53d6\u8868\u683c\u5185\u5bb9\uff1f<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump3\" rel=\"nofollow\"><br \/>\n    1\uff09Excel\u8868\u683c\u8ff0\u8bed<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump4\" rel=\"nofollow\"><br \/>\n    2\uff09\u6253\u5f00Excel\u8868\u683c\u5e76\u83b7\u53d6\u8868\u683c\u540d\u79f0<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump5\" rel=\"nofollow\"><br \/>\n    3\uff09\u901a\u8fc7sheet\u540d\u79f0\u83b7\u53d6\u8868\u683c<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump6\" rel=\"nofollow\"><br \/>\n    4\uff09\u83b7\u53d6\u8868\u683c\u7684\u5c3a\u5bf8\u5927\u5c0f<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump7\" rel=\"nofollow\"><br \/>\n    5\uff09\u83b7\u53d6\u8868\u683c\u5185\u67d0\u4e2a\u683c\u5b50\u7684\u6570\u636e<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump8\" rel=\"nofollow\"><br \/>\n    \u2460 sheet[\u201cA1\u201d]\u65b9\u5f0f<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump9\" rel=\"nofollow\"><br \/>\n    \u2461 sheet.cell(row=, column=)\u65b9\u5f0f<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump10\" rel=\"nofollow\"><br \/>\n    6\uff09\u83b7\u53d6\u67d0\u4e2a\u683c\u5b50\u7684\u884c\u6570\u3001\u5217\u6570\u3001\u5750\u6807<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump11\" rel=\"nofollow\"><br \/>\n    7\uff09\u83b7\u53d6\u4e00\u7cfb\u5217\u683c\u5b50<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump12\" rel=\"nofollow\"><br \/>\n    \u2460 sheet[]\u65b9\u5f0f<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump13\" rel=\"nofollow\"><br \/>\n    \u2461 .iter_rows()\u65b9\u5f0f<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump14\" rel=\"nofollow\"><br \/>\n    \u2462 sheet.rows()<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump15\" rel=\"nofollow\"><br \/>\n    3\u3001python\u5982\u4f55\u5411excel\u4e2d\u5199\u5165\u67d0\u4e9b\u5185\u5bb9\uff1f<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump16\" rel=\"nofollow\"><br \/>\n    1\uff09\u4fee\u6539\u8868\u683c\u4e2d\u7684\u5185\u5bb9<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump17\" rel=\"nofollow\"><br \/>\n    \u2460 \u5411\u67d0\u4e2a\u683c\u5b50\u4e2d\u5199\u5165\u5185\u5bb9\u5e76\u4fdd\u5b58<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump18\" rel=\"nofollow\"><br \/>\n    \u2461 .append()\uff1a\u5411\u8868\u683c\u4e2d\u63d2\u5165\u884c\u6570\u636e<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump19\" rel=\"nofollow\"><br \/>\n    \u2462 \u5728python\u4e2d\u4f7f\u7528excel\u51fd\u6570\u516c\u5f0f(\u5f88\u6709\u7528)<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump20\" rel=\"nofollow\"><br \/>\n    \u2463 .insert_cols()\u548c.insert_rows()\uff1a\u63d2\u5165\u7a7a\u884c\u548c\u7a7a\u5217<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump21\" rel=\"nofollow\"><br \/>\n    \u2464 .delete_rows()\u548c.delete_cols()\uff1a\u5220\u9664\u884c\u548c\u5217<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump22\" rel=\"nofollow\"><br \/>\n    \u2465 .move_range()\uff1a\u79fb\u52a8\u683c\u5b50<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump23\" rel=\"nofollow\"><br \/>\n    \u2466 .create_sheet()\uff1a\u521b\u5efa\u65b0\u7684sheet\u8868\u683c<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump24\" rel=\"nofollow\"><br \/>\n    \u2467 .remove()\uff1a\u5220\u9664\u67d0\u4e2asheet\u8868<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump25\" rel=\"nofollow\"><br \/>\n    \u2468 .copy_worksheet()\uff1a\u590d\u5236\u4e00\u4e2asheet\u8868\u5230\u53e6\u5916\u4e00\u5f20excel\u8868<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump26\" rel=\"nofollow\"><br \/>\n    \u2469 sheet.title\uff1a\u4fee\u6539sheet\u8868\u7684\u540d\u79f0<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump27\" rel=\"nofollow\"><br \/>\n    \u246a \u521b\u5efa\u65b0\u7684excel\u8868\u683c\u6587\u4ef6<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump28\" rel=\"nofollow\"><br \/>\n    \u246b sheet.freeze_panes\uff1a\u51bb\u7ed3\u7a97\u53e3<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump29\" rel=\"nofollow\"><br \/>\n    \u246c sheet.auto_filter.ref\uff1a\u7ed9\u8868\u683c\u6dfb\u52a0\u201c\u7b5b\u9009\u5668\u201d<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump30\" rel=\"nofollow\"><br \/>\n    4\u3001\u6279\u91cf\u8c03\u6574\u5b57\u4f53\u548c\u6837\u5f0f<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump31\" rel=\"nofollow\"><br \/>\n    1\uff09\u4fee\u6539\u5b57\u4f53\u6837\u5f0f<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump32\" rel=\"nofollow\"><br \/>\n    2\uff09\u83b7\u53d6\u8868\u683c\u4e2d\u683c\u5b50\u7684\u5b57\u4f53\u6837\u5f0f<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump33\" rel=\"nofollow\"><br \/>\n    3\uff09\u8bbe\u7f6e\u5bf9\u9f50\u6837\u5f0f<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump34\" rel=\"nofollow\"><br \/>\n    4\uff09\u8bbe\u7f6e\u8fb9\u6846\u6837\u5f0f<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump35\" rel=\"nofollow\"><br \/>\n    5\uff09\u8bbe\u7f6e\u586b\u5145\u6837\u5f0f<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump36\" rel=\"nofollow\"><br \/>\n    6\uff09\u8bbe\u7f6e\u884c\u9ad8\u548c\u5217\u5bbd<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump37\" rel=\"nofollow\"><br \/>\n    7\uff09\u5408\u5e76\u5355\u5143\u683c<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump38\" rel=\"nofollow\"><br \/>\n    \u7ae0\u8282\u4e8c\uff1apython\u4f7f\u7528PyPDF2\u548cpdfplumber\u64cd\u4f5cpdf<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump39\" rel=\"nofollow\"><br \/>\n    1\u3001PyPDF2\u548cpdfplumber\u5e93\u4ecb\u7ecd<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump40\" rel=\"nofollow\"><br \/>\n    2\u3001python\u63d0\u53d6PDF\u6587\u5b57\u5185\u5bb9<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump41\" rel=\"nofollow\"><br \/>\n    1\uff09\u5229\u7528pdfplumber\u63d0\u53d6\u6587\u5b57<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump42\" rel=\"nofollow\"><br \/>\n    2\uff09\u5229\u7528pdfplumber\u63d0\u53d6\u8868\u683c\u5e76\u5199\u5165excel<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump43\" rel=\"nofollow\"><br \/>\n    3\u3001PDF\u5408\u5e76\u53ca\u9875\u9762\u7684\u6392\u5e8f\u548c\u65cb\u8f6c<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump44\" rel=\"nofollow\"><br \/>\n    1\uff09\u5206\u5272\u53ca\u5408\u5e76pdf<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump45\" rel=\"nofollow\"><br \/>\n    \u2460 \u5408\u5e76pdf<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump46\" rel=\"nofollow\"><br \/>\n    \u2461 \u62c6\u5206pdf<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump47\" rel=\"nofollow\"><br \/>\n    2\uff09\u65cb\u8f6c\u53ca\u6392\u5e8fpdf<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump48\" rel=\"nofollow\"><br \/>\n    \u2460 \u65cb\u8f6cpdf<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump49\" rel=\"nofollow\"><br \/>\n    \u2461 \u6392\u5e8fpdf<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump50\" rel=\"nofollow\"><br \/>\n    4\u3001pdf\u6279\u91cf\u52a0\u6c34\u5370\u53ca\u52a0\u5bc6\u3001\u89e3\u5bc6<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump51\" rel=\"nofollow\"><br \/>\n    1\uff09\u6279\u91cf\u52a0\u6c34\u5370<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump52\" rel=\"nofollow\"><br \/>\n    2\uff09\u6279\u91cf\u52a0\u5bc6\u3001\u89e3\u5bc6<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump53\" rel=\"nofollow\"><br \/>\n    \u2460 \u52a0\u5bc6pdf<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump54\" rel=\"nofollow\"><br \/>\n    \u2461 \u89e3\u5bc6pdf\u5e76\u4fdd\u5b58\u4e3a\u672a\u52a0\u5bc6\u7684pdf<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump55\" rel=\"nofollow\"><br \/>\n    \u7ae0\u8282\u4e09\uff1apython\u4f7f\u7528python-docx\u64cd\u4f5cword<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump56\" rel=\"nofollow\"><br \/>\n    1\u3001python-docx\u5e93\u4ecb\u7ecd<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump57\" rel=\"nofollow\"><br \/>\n    2\u3001Python\u8bfb\u53d6Word\u6587\u6863\u5185\u5bb9<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump58\" rel=\"nofollow\"><br \/>\n    1\uff09word\u6587\u6863\u7ed3\u6784\u4ecb\u7ecd<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump59\" rel=\"nofollow\"><br \/>\n    2\uff09python-docx\u63d0\u53d6\u6587\u5b57\u548c\u6587\u5b57\u5757\u513f<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump60\" rel=\"nofollow\"><br \/>\n    \u2460 python-docx\u63d0\u53d6\u6587\u5b57<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump61\" rel=\"nofollow\"><br \/>\n    \u2461 python-docx\u63d0\u53d6\u6587\u5b57\u5757\u513f<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump62\" rel=\"nofollow\"><br \/>\n    3\uff09\u5229\u7528Python\u5411Word\u6587\u6863\u5199\u5165\u5185\u5bb9<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump63\" rel=\"nofollow\"><br \/>\n    \u2460 \u6dfb\u52a0\u6bb5\u843d<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump64\" rel=\"nofollow\"><br \/>\n    \u2461 \u6dfb\u52a0\u6587\u5b57\u5757\u513f<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump65\" rel=\"nofollow\"><br \/>\n    \u2462 \u6dfb\u52a0\u4e00\u4e2a\u5206\u9875<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump66\" rel=\"nofollow\"><br \/>\n    \u2463 \u6dfb\u52a0\u56fe\u7247<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump67\" rel=\"nofollow\"><br \/>\n    \u2464 \u6dfb\u52a0\u8868\u683c<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump68\" rel=\"nofollow\"><br \/>\n    \u2465 \u63d0\u53d6word\u8868\u683c\uff0c\u5e76\u4fdd\u5b58\u5728excel\u4e2d(\u5f88\u91cd\u8981)<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump69\" rel=\"nofollow\"><br \/>\n    3\u3001\u5229\u7528Python\u8c03\u6574Word\u6587\u6863\u6837\u5f0f<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump70\" rel=\"nofollow\"><br \/>\n    1\uff09\u4fee\u6539\u6587\u5b57\u5b57\u4f53\u6837\u5f0f<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump71\" rel=\"nofollow\"><br \/>\n    2\uff09\u4fee\u6539\u6bb5\u843d\u6837\u5f0f<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump72\" rel=\"nofollow\"><br \/>\n    \u2460 \u5bf9\u9f50\u6837\u5f0f<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump73\" rel=\"nofollow\"><br \/>\n    \u2461 \u884c\u95f4\u8ddd\u8c03\u6574<br \/>\n   <\/a><br \/>\n   <br \/>\n   <a href=\"#jump74\" rel=\"nofollow\"><br \/>\n    \u2462 \u6bb5\u524d\u4e0e\u6bb5\u540e\u95f4\u8ddd<br \/>\n   <\/a>\n  <\/p>\n<h4>\n   <a id=\"pythonopenpyxlexcelspan_idjump1span_84\"><br \/>\n   <\/a><br \/>\n   \u7ae0\u8282\u4e00\uff1apython\u4f7f\u7528openpyxl\u64cd\u4f5cexcel<br \/>\n   <span id=\"jump1\"><br \/>\n   <\/span><br \/>\n  <\/h4>\n<h5>\n   <a id=\"1openpyxl_span_idjump75span_85\"><br \/>\n   <\/a><br \/>\n   1\u3001openpyxl\u5e93\u4ecb\u7ecd<br \/>\n   <span id=\"jump75\"><br \/>\n   <\/span><br \/>\n  <\/h5>\n<ul>\n<li>\n    openpyxl\u6700\u597d\u7528\u7684python\u64cd\u4f5cexcel\u8868\u683c\u5e93\uff0c\u4e0d\u63a5\u53d7\u53cd\u9a73\uff1b\n   <\/li>\n<li>\n    openpyxl\u5b98\u7f51\u94fe\u63a5\uff1a<br \/>\n    <a href=\"https:\/\/openpyxl.readthedocs.io\/en\/stable\/\" rel=\"nofollow\"><br \/>\n     openpyxl\u5b98\u7f51<br \/>\n    <\/a>\n   <\/li>\n<li>\n    openpyxl\u53ea\u652f\u6301\u3010.xlsx \/ .xlsm \/ .xltx \/ .xltm\u3011\u683c\u5f0f\u7684\u6587\u4ef6\uff1b\n   <\/li>\n<\/ul>\n<h5>\n   <a id=\"2pythonspan_idjump2span_89\"><br \/>\n   <\/a><br \/>\n   2\u3001python\u600e\u4e48\u6253\u5f00\u53ca\u8bfb\u53d6\u8868\u683c\u5185\u5bb9\uff1f<br \/>\n   <span id=\"jump2\"><br \/>\n   <\/span><br \/>\n  <\/h5>\n<h6>\n   <a id=\"1Excelspan_idjump3span_90\"><br \/>\n   <\/a><br \/>\n   1\uff09Excel\u8868\u683c\u8ff0\u8bed<br \/>\n   <span id=\"jump3\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<p>\n   \u8fd9\u91cc\u9700\u8981\u5927\u5bb6\u4ed4\u7ec6\u67e5\u770b\u56fe\u4e2d\u7684\u6bcf\u4e00\u9879\u5185\u5bb9\uff0c\u77e5\u9053\u4ec0\u4e48\u662f\u201c\u884c(row)\u3001\u5217(column)\u201d\uff1f\u4ec0\u4e48\u662f\u201c\u683c\u5b50(cell)\u201d\uff1f\u4ec0\u4e48\u662f\u201csheet\u8868\u201d\uff1f<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"2Excelspan_idjump4span_93\"><br \/>\n   <\/a><br \/>\n   2\uff09\u6253\u5f00Excel\u8868\u683c\u5e76\u83b7\u53d6\u8868\u683c\u540d\u79f0<br \/>\n   <span id=\"jump4\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> openpyxl <span class=\"token keyword\">import<\/span> load_workbook\nworkbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"test.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nworkbook<span class=\"token punctuation\">.<\/span>sheetnames\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"3sheetspan_idjump5span_101\"><br \/>\n   <\/a><br \/>\n   3\uff09\u901a\u8fc7sheet\u540d\u79f0\u83b7\u53d6\u8868\u683c<br \/>\n   <span id=\"jump5\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> openpyxl <span class=\"token keyword\">import<\/span> load_workbook\nworkbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"test.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nworkbook<span class=\"token punctuation\">.<\/span>sheetnames\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">[<\/span><span class=\"token string\">\"Sheet1\"<\/span><span class=\"token punctuation\">]<\/span>\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>sheet<span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"4span_idjump6span_112\"><br \/>\n   <\/a><br \/>\n   4\uff09\u83b7\u53d6\u8868\u683c\u7684\u5c3a\u5bf8\u5927\u5c0f<br \/>\n   <span id=\"jump6\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    \u8fd9\u91cc\u6240\u8bf4\u7684\u5c3a\u5bf8\u5927\u5c0f\uff0c\u6307\u7684\u662fexcel\u8868\u683c\u4e2d\u7684\u6570\u636e\u6709\u51e0\u884c\u51e0\u5217\uff0c\u9488\u5bf9\u7684\u662f\u4e0d\u540c\u7684sheet\u800c\u8a00\u3002\n   <\/li>\n<\/ul>\n<pre><code class=\"prism language-python\">sheet<span class=\"token punctuation\">.<\/span>dimensions\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"5span_idjump7span_121\"><br \/>\n   <\/a><br \/>\n   5\uff09\u83b7\u53d6\u8868\u683c\u5185\u67d0\u4e2a\u683c\u5b50\u7684\u6570\u636e<br \/>\n   <span id=\"jump7\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<h6>\n   <a id=\"_sheetA1span_idjump8span_122\"><br \/>\n   <\/a><br \/>\n   \u2460 sheet[\u201cA1\u201d]\u65b9\u5f0f<br \/>\n   <span id=\"jump8\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\">workbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"test.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>sheet<span class=\"token punctuation\">)<\/span>\ncell1 <span class=\"token operator\">=<\/span> sheet<span class=\"token punctuation\">[<\/span><span class=\"token string\">\"A1\"<\/span><span class=\"token punctuation\">]<\/span>\ncell2 <span class=\"token operator\">=<\/span> sheet<span class=\"token punctuation\">[<\/span><span class=\"token string\">\"C11\"<\/span><span class=\"token punctuation\">]<\/span>\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>cell1<span class=\"token punctuation\">.<\/span>value<span class=\"token punctuation\">,<\/span> cell2<span class=\"token punctuation\">.<\/span>value<span class=\"token punctuation\">)<\/span>\n\n<span class=\"token triple-quoted-string string\">\"\"\"\nworkbook.active \u6253\u5f00\u6fc0\u6d3b\u7684\u8868\u683c\uff1b\nsheet[\"A1\"] \u83b7\u53d6A1\u683c\u5b50\u7684\u6570\u636e\uff1b\ncell.value \u83b7\u53d6\u683c\u5b50\u4e2d\u7684\u503c\uff1b\n\"\"\"<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_sheetcellrow_columnspan_idjump9span_140\"><br \/>\n   <\/a><br \/>\n   \u2461 sheet.cell(row=, column=)\u65b9\u5f0f<br \/>\n   <span id=\"jump9\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    \u8fd9\u79cd\u65b9\u5f0f\u66f4\u7b80\u5355\uff0c\u5927\u5bb6\u53ef\u4ee5\u5bf9\u6bd4\u8fd9\u4e24\u79cd\u65b9\u5f0f\uff1b\n   <\/li>\n<\/ul>\n<pre><code class=\"prism language-python\">workbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"test.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>sheet<span class=\"token punctuation\">)<\/span>\ncell1 <span class=\"token operator\">=<\/span> sheet<span class=\"token punctuation\">.<\/span>cell<span class=\"token punctuation\">(<\/span>row <span class=\"token operator\">=<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span>column <span class=\"token operator\">=<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span>\ncell2 <span class=\"token operator\">=<\/span> sheet<span class=\"token punctuation\">.<\/span>cell<span class=\"token punctuation\">(<\/span>row <span class=\"token operator\">=<\/span> <span class=\"token number\">11<\/span><span class=\"token punctuation\">,<\/span>column <span class=\"token operator\">=<\/span> <span class=\"token number\">3<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>cell1<span class=\"token punctuation\">.<\/span>value<span class=\"token punctuation\">,<\/span> cell2<span class=\"token punctuation\">.<\/span>value<span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"6span_idjump10span_153\"><br \/>\n   <\/a><br \/>\n   6\uff09\u83b7\u53d6\u67d0\u4e2a\u683c\u5b50\u7684\u884c\u6570\u3001\u5217\u6570\u3001\u5750\u6807<br \/>\n   <span id=\"jump10\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\">workbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"test.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>sheet<span class=\"token punctuation\">)<\/span>\ncell1 <span class=\"token operator\">=<\/span> sheet<span class=\"token punctuation\">[<\/span><span class=\"token string\">\"A1\"<\/span><span class=\"token punctuation\">]<\/span>\ncell2 <span class=\"token operator\">=<\/span> sheet<span class=\"token punctuation\">[<\/span><span class=\"token string\">\"C11\"<\/span><span class=\"token punctuation\">]<\/span>\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>cell1<span class=\"token punctuation\">.<\/span>value<span class=\"token punctuation\">,<\/span> cell1<span class=\"token punctuation\">.<\/span>row<span class=\"token punctuation\">,<\/span> cell1<span class=\"token punctuation\">.<\/span>column<span class=\"token punctuation\">,<\/span> cell1<span class=\"token punctuation\">.<\/span>coordinate<span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>cell2<span class=\"token punctuation\">.<\/span>value<span class=\"token punctuation\">,<\/span> cell2<span class=\"token punctuation\">.<\/span>row<span class=\"token punctuation\">,<\/span> cell2<span class=\"token punctuation\">.<\/span>column<span class=\"token punctuation\">,<\/span> cell2<span class=\"token punctuation\">.<\/span>coordinate<span class=\"token punctuation\">)<\/span>\n<span class=\"token triple-quoted-string string\">\"\"\"\n.row \u83b7\u53d6\u67d0\u4e2a\u683c\u5b50\u7684\u884c\u6570\uff1b\n.columns \u83b7\u53d6\u67d0\u4e2a\u683c\u5b50\u7684\u5217\u6570\uff1b\n.corordinate \u83b7\u53d6\u67d0\u4e2a\u683c\u5b50\u7684\u5750\u6807\uff1b\n\"\"\"<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"7span_idjump11span_173\"><br \/>\n   <\/a><br \/>\n   7\uff09\u83b7\u53d6\u4e00\u7cfb\u5217\u683c\u5b50<br \/>\n   <span id=\"jump11\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<h6>\n   <a id=\"_sheetspan_idjump12span_174\"><br \/>\n   <\/a><br \/>\n   \u2460 sheet[]\u65b9\u5f0f<br \/>\n   <span id=\"jump12\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\">workbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"test.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>sheet<span class=\"token punctuation\">)<\/span>\n<span class=\"token comment\"># \u83b7\u53d6A1:C2\u533a\u57df\u7684\u503c<\/span>\ncell <span class=\"token operator\">=<\/span> sheet<span class=\"token punctuation\">[<\/span><span class=\"token string\">\"A1:C2\"<\/span><span class=\"token punctuation\">]<\/span>\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>cell<span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">for<\/span> i <span class=\"token keyword\">in<\/span> cell<span class=\"token punctuation\">:<\/span>\n    <span class=\"token keyword\">for<\/span> j <span class=\"token keyword\">in<\/span> i<span class=\"token punctuation\">:<\/span>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>j<span class=\"token punctuation\">.<\/span>value<span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n<p>   \u7279\u522b\u7684\uff1a\u5982\u679c\u6211\u4eec\u53ea\u60f3\u83b7\u53d6\u201cA\u5217\u201d\uff0c\u6216\u8005\u83b7\u53d6\u201cA-C\u5217\u201d\uff0c\u53ef\u4ee5\u91c7\u53d6\u5982\u4e0b\u65b9\u5f0f\uff1a\n  <\/p>\n<pre><code class=\"prism language-python\">sheet<span class=\"token punctuation\">[<\/span><span class=\"token string\">\"A\"<\/span><span class=\"token punctuation\">]<\/span>    <span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span> \u83b7\u53d6A\u5217\u7684\u6570\u636e\nsheet<span class=\"token punctuation\">[<\/span><span class=\"token string\">\"A:C\"<\/span><span class=\"token punctuation\">]<\/span>    <span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span> \u83b7\u53d6A<span class=\"token punctuation\">,<\/span>B<span class=\"token punctuation\">,<\/span>C\u4e09\u5217\u7684\u6570\u636e\nsheet<span class=\"token punctuation\">[<\/span><span class=\"token number\">5<\/span><span class=\"token punctuation\">]<\/span>   <span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span> \u53ea\u83b7\u53d6\u7b2c<span class=\"token number\">5<\/span>\u884c\u7684\u6570\u636e\n<\/code><\/pre>\n<h6>\n   <a id=\"_iter_rowsspan_idjump13span_199\"><br \/>\n   <\/a><br \/>\n   \u2461 .iter_rows()\u65b9\u5f0f<br \/>\n   <span id=\"jump13\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    \u5f53\u7136\u6709.iter_rows()\u65b9\u5f0f\uff0c\u80af\u5b9a\u4e5f\u4f1a\u6709.iter_cols()\u65b9\u5f0f\uff0c\u53ea\u4e0d\u8fc7\u4e00\u4e2a\u662f\u6309\u884c\u8bfb\u53d6\uff0c\u4e00\u4e2a\u662f\u6309\u5217\u8bfb\u53d6\u3002\n   <\/li>\n<\/ul>\n<pre><code class=\"prism language-python\">workbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"test.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>sheet<span class=\"token punctuation\">)<\/span>\n<span class=\"token comment\"># \u6309\u884c\u83b7\u53d6\u503c<\/span>\n<span class=\"token keyword\">for<\/span> i <span class=\"token keyword\">in<\/span> sheet<span class=\"token punctuation\">.<\/span>iter_rows<span class=\"token punctuation\">(<\/span>min_row<span class=\"token operator\">=<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">,<\/span> max_row<span class=\"token operator\">=<\/span><span class=\"token number\">5<\/span><span class=\"token punctuation\">,<\/span> min_col<span class=\"token operator\">=<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> max_col<span class=\"token operator\">=<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\n    <span class=\"token keyword\">for<\/span> j <span class=\"token keyword\">in<\/span> i<span class=\"token punctuation\">:<\/span>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>j<span class=\"token punctuation\">.<\/span>value<span class=\"token punctuation\">)<\/span>\n<span class=\"token comment\"># \u6309\u5217\u83b7\u53d6\u503c<\/span>\n<span class=\"token keyword\">for<\/span> i <span class=\"token keyword\">in<\/span> sheet<span class=\"token punctuation\">.<\/span>iter_cols<span class=\"token punctuation\">(<\/span>min_row<span class=\"token operator\">=<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">,<\/span> max_row<span class=\"token operator\">=<\/span><span class=\"token number\">5<\/span><span class=\"token punctuation\">,<\/span> min_col<span class=\"token operator\">=<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> max_col<span class=\"token operator\">=<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\n    <span class=\"token keyword\">for<\/span> j <span class=\"token keyword\">in<\/span> i<span class=\"token punctuation\">:<\/span>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>j<span class=\"token punctuation\">.<\/span>value<span class=\"token punctuation\">)<\/span>      \n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_sheetrowsspan_idjump14span_218\"><br \/>\n   <\/a><br \/>\n   \u2462 sheet.rows()<br \/>\n   <span id=\"jump14\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    \u5e2e\u52a9\u6211\u4eec\u83b7\u53d6\u6240\u6709\u884c\n   <\/li>\n<\/ul>\n<pre><code class=\"prism language-python\">workbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"test.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>sheet<span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">for<\/span> i <span class=\"token keyword\">in<\/span> sheet<span class=\"token punctuation\">.<\/span>rows<span class=\"token punctuation\">:<\/span>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>i<span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h5>\n   <a id=\"3pythonexcelspan_idjump15span_231\"><br \/>\n   <\/a><br \/>\n   3\u3001python\u5982\u4f55\u5411excel\u4e2d\u5199\u5165\u67d0\u4e9b\u5185\u5bb9\uff1f<br \/>\n   <span id=\"jump15\"><br \/>\n   <\/span><br \/>\n  <\/h5>\n<h6>\n   <a id=\"1span_idjump16span_232\"><br \/>\n   <\/a><br \/>\n   1\uff09\u4fee\u6539\u8868\u683c\u4e2d\u7684\u5185\u5bb9<br \/>\n   <span id=\"jump16\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<h6>\n   <a id=\"_span_idjump17span_233\"><br \/>\n   <\/a><br \/>\n   \u2460 \u5411\u67d0\u4e2a\u683c\u5b50\u4e2d\u5199\u5165\u5185\u5bb9\u5e76\u4fdd\u5b58<br \/>\n   <span id=\"jump17\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\">workbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"test.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>sheet<span class=\"token punctuation\">)<\/span>\nsheet<span class=\"token punctuation\">[<\/span><span class=\"token string\">\"A1\"<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">=<\/span> <span class=\"token string\">\"\u54c8\u55bd\"<\/span> <span class=\"token comment\"># \u8fd9\u53e5\u4ee3\u7801\u4e5f\u53ef\u4ee5\u6539\u4e3acell = sheet[\"A1\"] cell.value = \"\u54c8\u55bd\"<\/span>\nworkbook<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"\u54c8\u55bd.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token triple-quoted-string string\">\"\"\"\n\u6ce8\u610f\uff1a\u6211\u4eec\u5c06\u201cA1\u201d\u5355\u5143\u683c\u7684\u6570\u636e\u6539\u4e3a\u4e86\u201c\u54c8\u55bd\u201d\uff0c\u5e76\u53e6\u5b58\u4e3a\u4e86\u201c\u54c8\u55bd.xlsx\u201d\u6587\u4ef6\u3002\n\u5982\u679c\u6211\u4eec\u4fdd\u5b58\u7684\u65f6\u5019\uff0c\u4e0d\u4fee\u6539\u8868\u540d\uff0c\u76f8\u5f53\u4e8e\u76f4\u63a5\u4fee\u6539\u6e90\u6587\u4ef6\uff1b\n\"\"\"<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_appendspan_idjump18span_247\"><br \/>\n   <\/a><br \/>\n   \u2461 .append()\uff1a\u5411\u8868\u683c\u4e2d\u63d2\u5165\u884c\u6570\u636e<br \/>\n   <span id=\"jump18\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    .append()\u65b9\u5f0f\uff1a\u4f1a\u5728\u8868\u683c\u5df2\u6709\u7684\u6570\u636e\u540e\u9762\uff0c\u589e\u6dfb\u8fd9\u4e9b\u6570(\u6309\u884c\u63d2\u5165)\uff1b\n   <\/li>\n<li>\n    \u8fd9\u4e2a\u64cd\u4f5c\u5f88\u6709\u7528\uff0c\u722c\u866b\u5f97\u5230\u7684\u6570\u636e\uff0c\u53ef\u4ee5\u4f7f\u7528\u8be5\u65b9\u5f0f\u4fdd\u5b58\u6210Excel\u6587\u4ef6\uff1b\n   <\/li>\n<\/ul>\n<pre><code class=\"prism language-python\">workbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"test.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>sheet<span class=\"token punctuation\">)<\/span>\ndata <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span>\n    <span class=\"token punctuation\">[<\/span><span class=\"token string\">\"\u5510\u50e7\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u7537\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"180cm\"<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token punctuation\">[<\/span><span class=\"token string\">\"\u5b59\u609f\u7a7a\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u7537\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"188cm\"<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token punctuation\">[<\/span><span class=\"token string\">\"\u732a\u516b\u6212\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u7537\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"175cm\"<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token punctuation\">[<\/span><span class=\"token string\">\"\u6c99\u50e7\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u7537\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"176cm\"<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n<span class=\"token punctuation\">]<\/span>\n<span class=\"token keyword\">for<\/span> row <span class=\"token keyword\">in<\/span> data<span class=\"token punctuation\">:<\/span>\n    sheet<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span>row<span class=\"token punctuation\">)<\/span>\nworkbook<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"test.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_pythonexcelspan_idjump19span_267\"><br \/>\n   <\/a><br \/>\n   \u2462 \u5728python\u4e2d\u4f7f\u7528excel\u51fd\u6570\u516c\u5f0f(\u5f88\u6709\u7528)<br \/>\n   <span id=\"jump19\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\"><span class=\"token comment\"># \u8fd9\u662f\u6211\u4eec\u5728excel\u4e2d\u8f93\u5165\u7684\u516c\u5f0f<\/span>\n<span class=\"token operator\">=<\/span>IF<span class=\"token punctuation\">(<\/span>RIGHT<span class=\"token punctuation\">(<\/span>C2<span class=\"token punctuation\">,<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">)<\/span><span class=\"token operator\">=<\/span><span class=\"token string\">\"cm\"<\/span><span class=\"token punctuation\">,<\/span>C2<span class=\"token punctuation\">,<\/span>SUBSTITUTE<span class=\"token punctuation\">(<\/span>C2<span class=\"token punctuation\">,<\/span><span class=\"token string\">\"m\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\"<\/span><span class=\"token punctuation\">)<\/span><span class=\"token operator\">*<\/span><span class=\"token number\">100<\/span><span class=\"token operator\">&amp;<\/span><span class=\"token string\">\"cm\"<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token comment\"># \u90a3\u4e48\uff0c\u5728python\u4e2d\u600e\u4e48\u63d2\u5165excel\u516c\u5f0f\u5462\uff1f<\/span>\nworkbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"test.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>sheet<span class=\"token punctuation\">)<\/span>\nsheet<span class=\"token punctuation\">[<\/span><span class=\"token string\">\"D1\"<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">=<\/span> <span class=\"token string\">\"\u6807\u51c6\u8eab\u9ad8\"<\/span>\n<span class=\"token keyword\">for<\/span> i <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">range<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">,<\/span><span class=\"token number\">16<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\n    sheet<span class=\"token punctuation\">[<\/span><span class=\"token string\">\"D{}\"<\/span><span class=\"token punctuation\">.<\/span><span class=\"token builtin\">format<\/span><span class=\"token punctuation\">(<\/span>i<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">=<\/span> <span class=\"token string\">'=IF(RIGHT(C{},2)=\"cm\",C{},SUBSTITUTE(C{},\"m\",\"\")*100&amp;\"cm\")'<\/span><span class=\"token punctuation\">.<\/span><span class=\"token builtin\">format<\/span><span class=\"token punctuation\">(<\/span>i<span class=\"token punctuation\">,<\/span>i<span class=\"token punctuation\">,<\/span>i<span class=\"token punctuation\">)<\/span>\nworkbook<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"test.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n<p>   \u6b64\u65f6\uff0c\u4f60\u80af\u5b9a\u4f1a\u597d\u5947\uff0cpython\u7a76\u7adf\u652f\u6301\u5199\u54ea\u4e9b\u201cexcel\u51fd\u6570\u516c\u5f0f\u201d\u5462\uff1f\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528\u5982\u4e0b\u64cd\u4f5c\u67e5\u770b\u4e00\u4e0b\u3002\n  <\/p>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">import<\/span> openpyxl\n<span class=\"token keyword\">from<\/span> openpyxl<span class=\"token punctuation\">.<\/span>utils <span class=\"token keyword\">import<\/span> FORMULAE\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>FORMULAE<span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_insert_colsinsert_rowsspan_idjump20span_292\"><br \/>\n   <\/a><br \/>\n   \u2463 .insert_cols()\u548c.insert_rows()\uff1a\u63d2\u5165\u7a7a\u884c\u548c\u7a7a\u5217<br \/>\n   <span id=\"jump20\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    .insert_cols(idx=\u6570\u5b57\u7f16\u53f7, amount=\u8981\u63d2\u5165\u7684\u5217\u6570)\uff0c\u63d2\u5165\u7684\u4f4d\u7f6e\u662f\u5728idx\u5217\u6570\u7684\u5de6\u4fa7\u63d2\u5165\uff1b\n   <\/li>\n<li>\n    .insert_rows(idx=\u6570\u5b57\u7f16\u53f7, amount=\u8981\u63d2\u5165\u7684\u884c\u6570)\uff0c\u63d2\u5165\u7684\u884c\u6570\u662f\u5728idx\u884c\u6570\u7684\u4e0b\u65b9\u63d2\u5165\uff1b\n   <\/li>\n<\/ul>\n<pre><code class=\"prism language-python\">workbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"test.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>sheet<span class=\"token punctuation\">)<\/span>\nsheet<span class=\"token punctuation\">.<\/span>insert_cols<span class=\"token punctuation\">(<\/span>idx<span class=\"token operator\">=<\/span><span class=\"token number\">4<\/span><span class=\"token punctuation\">,<\/span>amount<span class=\"token operator\">=<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">)<\/span>\nsheet<span class=\"token punctuation\">.<\/span>insert_rows<span class=\"token punctuation\">(<\/span>idx<span class=\"token operator\">=<\/span><span class=\"token number\">5<\/span><span class=\"token punctuation\">,<\/span>amount<span class=\"token operator\">=<\/span><span class=\"token number\">4<\/span><span class=\"token punctuation\">)<\/span>\nworkbook<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"test.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_delete_rowsdelete_colsspan_idjump21span_306\"><br \/>\n   <\/a><br \/>\n   \u2464 .delete_rows()\u548c.delete_cols()\uff1a\u5220\u9664\u884c\u548c\u5217<br \/>\n   <span id=\"jump21\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    .delete_rows(idx=\u6570\u5b57\u7f16\u53f7, amount=\u8981\u5220\u9664\u7684\u884c\u6570)\n   <\/li>\n<li>\n    .delete_cols(idx=\u6570\u5b57\u7f16\u53f7, amount=\u8981\u5220\u9664\u7684\u5217\u6570)\n   <\/li>\n<\/ul>\n<pre><code class=\"prism language-python\">workbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"test.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>sheet<span class=\"token punctuation\">)<\/span>\n<span class=\"token comment\"># \u5220\u9664\u7b2c\u4e00\u5217\uff0c\u7b2c\u4e00\u884c<\/span>\nsheet<span class=\"token punctuation\">.<\/span>delete_cols<span class=\"token punctuation\">(<\/span>idx<span class=\"token operator\">=<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span>\nsheet<span class=\"token punctuation\">.<\/span>delete_rows<span class=\"token punctuation\">(<\/span>idx<span class=\"token operator\">=<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span>\nworkbook<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"test.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_move_rangespan_idjump22span_322\"><br \/>\n   <\/a><br \/>\n   \u2465 .move_range()\uff1a\u79fb\u52a8\u683c\u5b50<br \/>\n   <span id=\"jump22\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    .move_range(\u201c\u6570\u636e\u533a\u57df\u201d,rows=,cols=)\uff1a\u6b63\u6574\u6570\u4e3a\u5411\u4e0b\u6216\u5411\u53f3\u3001\u8d1f\u6574\u6570\u4e3a\u5411\u5de6\u6216\u5411\u4e0a\uff1b\n   <\/li>\n<\/ul>\n<pre><code class=\"prism language-python\"><span class=\"token comment\"># \u5411\u5de6\u79fb\u52a8\u4e24\u5217\uff0c\u5411\u4e0b\u79fb\u52a8\u4e24\u884c<\/span>\nsheet<span class=\"token punctuation\">.<\/span>move_range<span class=\"token punctuation\">(<\/span><span class=\"token string\">\"C1:D4\"<\/span><span class=\"token punctuation\">,<\/span>rows<span class=\"token operator\">=<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">,<\/span>cols<span class=\"token operator\">=<\/span><span class=\"token operator\">-<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u6f14\u793a\u6548\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_create_sheetsheetspan_idjump23span_332\"><br \/>\n   <\/a><br \/>\n   \u2466 .create_sheet()\uff1a\u521b\u5efa\u65b0\u7684sheet\u8868\u683c<br \/>\n   <span id=\"jump23\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    .create_sheet(\u201c\u65b0\u7684sheet\u540d\u201d)\uff1a\u521b\u5efa\u4e00\u4e2a\u65b0\u7684sheet\u8868\uff1b\n   <\/li>\n<\/ul>\n<pre><code class=\"prism language-python\">workbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"test.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>sheet<span class=\"token punctuation\">)<\/span>\nworkbook<span class=\"token punctuation\">.<\/span>create_sheet<span class=\"token punctuation\">(<\/span><span class=\"token string\">\"\u6211\u662f\u4e00\u4e2a\u65b0\u7684sheet\"<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>workbook<span class=\"token punctuation\">.<\/span>sheetnames<span class=\"token punctuation\">)<\/span>\nworkbook<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"test.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_removesheetspan_idjump24span_346\"><br \/>\n   <\/a><br \/>\n   \u2467 .remove()\uff1a\u5220\u9664\u67d0\u4e2asheet\u8868<br \/>\n   <span id=\"jump24\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    .remove(\u201csheet\u540d\u201d)\uff1a\u5220\u9664\u67d0\u4e2asheet\u8868\uff1b\n   <\/li>\n<\/ul>\n<pre><code class=\"prism language-python\">workbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"test.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>workbook<span class=\"token punctuation\">.<\/span>sheetnames<span class=\"token punctuation\">)<\/span>\n<span class=\"token comment\"># \u8fd9\u4e2a\u76f8\u5f53\u4e8e\u6fc0\u6d3b\u7684\u8fd9\u4e2asheet\u8868\uff0c\u6fc0\u6d3b\u72b6\u6001\u4e0b\uff0c\u624d\u53ef\u4ee5\u64cd\u4f5c\uff1b<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">[<\/span><span class=\"token string\">'\u6211\u662f\u4e00\u4e2a\u65b0\u7684sheet'<\/span><span class=\"token punctuation\">]<\/span>  \n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>sheet<span class=\"token punctuation\">)<\/span>\nworkbook<span class=\"token punctuation\">.<\/span>remove<span class=\"token punctuation\">(<\/span>sheet<span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>workbook<span class=\"token punctuation\">.<\/span>sheetnames<span class=\"token punctuation\">)<\/span>\nworkbook<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"test.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_copy_worksheetsheetexcelspan_idjump25span_363\"><br \/>\n   <\/a><br \/>\n   \u2468 .copy_worksheet()\uff1a\u590d\u5236\u4e00\u4e2asheet\u8868\u5230\u53e6\u5916\u4e00\u5f20excel\u8868<br \/>\n   <span id=\"jump25\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    \u8fd9\u4e2a\u64cd\u4f5c\u7684\u5b9e\u8d28\uff0c\u5c31\u662f\u590d\u5236\u67d0\u4e2aexcel\u8868\u4e2d\u7684sheet\u8868\uff0c\u7136\u540e\u5c06\u6587\u4ef6\u5b58\u50a8\u5230\u53e6\u5916\u4e00\u5f20excel\u8868\u4e2d\uff1b\n   <\/li>\n<\/ul>\n<pre><code class=\"prism language-python\">workbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"a.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"a.xlsx\u4e2d\u6709\u8fd9\u51e0\u4e2asheet\u8868\"<\/span><span class=\"token punctuation\">,<\/span>workbook<span class=\"token punctuation\">.<\/span>sheetnames<span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">[<\/span><span class=\"token string\">'\u59d3\u540d'<\/span><span class=\"token punctuation\">]<\/span>  \nworkbook<span class=\"token punctuation\">.<\/span>copy_worksheet<span class=\"token punctuation\">(<\/span>sheet<span class=\"token punctuation\">)<\/span>\nworkbook<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"test.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_sheettitlesheetspan_idjump26span_377\"><br \/>\n   <\/a><br \/>\n   \u2469 sheet.title\uff1a\u4fee\u6539sheet\u8868\u7684\u540d\u79f0<br \/>\n   <span id=\"jump26\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    .title = \u201c\u65b0\u7684sheet\u8868\u540d\u201d\n   <\/li>\n<\/ul>\n<pre><code class=\"prism language-python\">workbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"a.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>sheet<span class=\"token punctuation\">)<\/span>\nsheet<span class=\"token punctuation\">.<\/span>title <span class=\"token operator\">=<\/span> <span class=\"token string\">\"\u6211\u662f\u4fee\u6539\u540e\u7684sheet\u540d\"<\/span>\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>sheet<span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_excelspan_idjump27span_389\"><br \/>\n   <\/a><br \/>\n   \u246a \u521b\u5efa\u65b0\u7684excel\u8868\u683c\u6587\u4ef6<br \/>\n   <span id=\"jump27\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> openpyxl <span class=\"token keyword\">import<\/span> Workbook\n\nworkbook <span class=\"token operator\">=<\/span> Workbook<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\nsheet<span class=\"token punctuation\">.<\/span>title <span class=\"token operator\">=<\/span> <span class=\"token string\">\"\u8868\u683c1\"<\/span>\nworkbook<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"\u65b0\u5efa\u7684excel\u8868\u683c\"<\/span><span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_sheetfreeze_panesspan_idjump28span_401\"><br \/>\n   <\/a><br \/>\n   \u246b sheet.freeze_panes\uff1a\u51bb\u7ed3\u7a97\u53e3<br \/>\n   <span id=\"jump28\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    .freeze_panes = \u201c\u5355\u5143\u683c\u201d\n   <\/li>\n<\/ul>\n<pre><code class=\"prism language-python\">workbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"\u82b1\u56ed.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>sheet<span class=\"token punctuation\">)<\/span>\nsheet<span class=\"token punctuation\">.<\/span>freeze_panes <span class=\"token operator\">=<\/span> <span class=\"token string\">\"C3\"<\/span>\nworkbook<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"\u82b1\u56ed.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token triple-quoted-string string\">\"\"\"\n\u51bb\u7ed3\u7a97\u53e3\u4ee5\u540e\uff0c\u4f60\u53ef\u4ee5\u6253\u5f00\u6e90\u6587\u4ef6\uff0c\u8fdb\u884c\u68c0\u9a8c\uff1b\n\"\"\"<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_sheetauto_filterrefspan_idjump29span_416\"><br \/>\n   <\/a><br \/>\n   \u246c sheet.auto_filter.ref\uff1a\u7ed9\u8868\u683c\u6dfb\u52a0\u201c\u7b5b\u9009\u5668\u201d<br \/>\n   <span id=\"jump29\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    .auto_filter.ref = sheet.dimension \u7ed9\u6240\u6709\u5b57\u6bb5\u6dfb\u52a0\u7b5b\u9009\u5668\uff1b\n   <\/li>\n<li>\n    .auto_filter.ref = \u201cA1\u201d \u7ed9A1\u8fd9\u4e2a\u683c\u5b50\u6dfb\u52a0\u201c\u7b5b\u9009\u5668\u201d\uff0c\u5c31\u662f\u7ed9\u7b2c\u4e00\u5217\u6dfb\u52a0\u201c\u7b5b\u9009\u5668\u201d\uff1b\n   <\/li>\n<\/ul>\n<pre><code class=\"prism language-python\">workbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"\u82b1\u56ed.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>sheet<span class=\"token punctuation\">)<\/span>\nsheet<span class=\"token punctuation\">.<\/span>auto_filter<span class=\"token punctuation\">.<\/span>ref <span class=\"token operator\">=<\/span> sheet<span class=\"token punctuation\">[<\/span><span class=\"token string\">\"A1\"<\/span><span class=\"token punctuation\">]<\/span>\nworkbook<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"\u82b1\u56ed.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h5>\n   <a id=\"4span_idjump30span_428\"><br \/>\n   <\/a><br \/>\n   4\u3001\u6279\u91cf\u8c03\u6574\u5b57\u4f53\u548c\u6837\u5f0f<br \/>\n   <span id=\"jump30\"><br \/>\n   <\/span><br \/>\n  <\/h5>\n<h6>\n   <a id=\"1span_idjump31span_429\"><br \/>\n   <\/a><br \/>\n   1\uff09\u4fee\u6539\u5b57\u4f53\u6837\u5f0f<br \/>\n   <span id=\"jump31\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    Font(name=\u5b57\u4f53\u540d\u79f0,size=\u5b57\u4f53\u5927\u5c0f,bold=\u662f\u5426\u52a0\u7c97,italic=\u662f\u5426\u659c\u4f53,color=\u5b57\u4f53\u989c\u8272)\n   <\/li>\n<\/ul>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> openpyxl<span class=\"token punctuation\">.<\/span>styles <span class=\"token keyword\">import<\/span> Font\n<span class=\"token keyword\">from<\/span> openpyxl <span class=\"token keyword\">import<\/span> load_workbook\n\nworkbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename<span class=\"token operator\">=<\/span><span class=\"token string\">\"\u82b1\u56ed.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\ncell <span class=\"token operator\">=<\/span> sheet<span class=\"token punctuation\">[<\/span><span class=\"token string\">\"A1\"<\/span><span class=\"token punctuation\">]<\/span>\nfont <span class=\"token operator\">=<\/span> Font<span class=\"token punctuation\">(<\/span>name<span class=\"token operator\">=<\/span><span class=\"token string\">\"\u5fae\u8f6f\u96c5\u9ed1\"<\/span><span class=\"token punctuation\">,<\/span>size<span class=\"token operator\">=<\/span><span class=\"token number\">20<\/span><span class=\"token punctuation\">,<\/span>bold<span class=\"token operator\">=<\/span><span class=\"token boolean\">True<\/span><span class=\"token punctuation\">,<\/span>italic<span class=\"token operator\">=<\/span><span class=\"token boolean\">True<\/span><span class=\"token punctuation\">,<\/span>color<span class=\"token operator\">=<\/span><span class=\"token string\">\"FF0000\"<\/span><span class=\"token punctuation\">)<\/span>\ncell<span class=\"token punctuation\">.<\/span>font <span class=\"token operator\">=<\/span> font\nworkbook<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"\u82b1\u56ed.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token triple-quoted-string string\">\"\"\"\n\u8fd9\u4e2acolor\u662fRGB\u768416\u8fdb\u5236\u8868\u793a\uff0c\u81ea\u5df1\u4e0b\u53bb\u767e\u5ea6\u5b66\u4e60\uff1b\n\"\"\"<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"2span_idjump32span_449\"><br \/>\n   <\/a><br \/>\n   2\uff09\u83b7\u53d6\u8868\u683c\u4e2d\u683c\u5b50\u7684\u5b57\u4f53\u6837\u5f0f<br \/>\n   <span id=\"jump32\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> openpyxl<span class=\"token punctuation\">.<\/span>styles <span class=\"token keyword\">import<\/span> Font\n<span class=\"token keyword\">from<\/span> openpyxl <span class=\"token keyword\">import<\/span> load_workbook\n\nworkbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename<span class=\"token operator\">=<\/span><span class=\"token string\">\"\u82b1\u56ed.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\ncell <span class=\"token operator\">=<\/span> sheet<span class=\"token punctuation\">[<\/span><span class=\"token string\">\"A2\"<\/span><span class=\"token punctuation\">]<\/span>\nfont <span class=\"token operator\">=<\/span> cell<span class=\"token punctuation\">.<\/span>font\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>font<span class=\"token punctuation\">.<\/span>name<span class=\"token punctuation\">,<\/span> font<span class=\"token punctuation\">.<\/span>size<span class=\"token punctuation\">,<\/span> font<span class=\"token punctuation\">.<\/span>bold<span class=\"token punctuation\">,<\/span> font<span class=\"token punctuation\">.<\/span>italic<span class=\"token punctuation\">,<\/span> font<span class=\"token punctuation\">.<\/span>color<span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"3span_idjump33span_464\"><br \/>\n   <\/a><br \/>\n   3\uff09\u8bbe\u7f6e\u5bf9\u9f50\u6837\u5f0f<br \/>\n   <span id=\"jump33\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    Alignment(horizontal=\u6c34\u5e73\u5bf9\u9f50\u6a21\u5f0f,vertical=\u5782\u76f4\u5bf9\u9f50\u6a21\u5f0f,text_rotation=\u65cb\u8f6c\u89d2\u5ea6,wrap_text=\u662f\u5426\u81ea\u52a8\u6362\u884c)\n   <\/li>\n<li>\n    \u6c34\u5e73\u5bf9\u9f50\uff1a\u2018distributed\u2019\uff0c\u2018justify\u2019\uff0c\u2018center\u2019\uff0c\u2018leftfill\u2019\uff0c \u2018centerContinuous\u2019\uff0c\u2018right\uff0c\u2018general\u2019\uff1b\n   <\/li>\n<li>\n    \u5782\u76f4\u5bf9\u9f50\uff1a\u2018bottom\u2019\uff0c\u2018distributed\u2019\uff0c\u2018justify\u2019\uff0c\u2018center\u2019\uff0c\u2018top\u2019\uff1b\n   <\/li>\n<\/ul>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> openpyxl<span class=\"token punctuation\">.<\/span>styles <span class=\"token keyword\">import<\/span> Alignment\n<span class=\"token keyword\">from<\/span> openpyxl <span class=\"token keyword\">import<\/span> load_workbook\n\nworkbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename<span class=\"token operator\">=<\/span><span class=\"token string\">\"\u82b1\u56ed.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\ncell <span class=\"token operator\">=<\/span> sheet<span class=\"token punctuation\">[<\/span><span class=\"token string\">\"A1\"<\/span><span class=\"token punctuation\">]<\/span>\nalignment <span class=\"token operator\">=<\/span> Alignment<span class=\"token punctuation\">(<\/span>horizontal<span class=\"token operator\">=<\/span><span class=\"token string\">\"center\"<\/span><span class=\"token punctuation\">,<\/span>vertical<span class=\"token operator\">=<\/span><span class=\"token string\">\"center\"<\/span><span class=\"token punctuation\">,<\/span>text_rotation<span class=\"token operator\">=<\/span><span class=\"token number\">45<\/span><span class=\"token punctuation\">,<\/span>wrap_text<span class=\"token operator\">=<\/span><span class=\"token boolean\">True<\/span><span class=\"token punctuation\">)<\/span>\ncell<span class=\"token punctuation\">.<\/span>alignment <span class=\"token operator\">=<\/span> alignment\nworkbook<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"\u82b1\u56ed.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"4span_idjump34span_484\"><br \/>\n   <\/a><br \/>\n   4\uff09\u8bbe\u7f6e\u8fb9\u6846\u6837\u5f0f<br \/>\n   <span id=\"jump34\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    Side(style=\u8fb9\u7ebf\u6837\u5f0f\uff0ccolor=\u8fb9\u7ebf\u989c\u8272)\n   <\/li>\n<li>\n    Border(left=\u5de6\u8fb9\u7ebf\u6837\u5f0f\uff0cright=\u53f3\u8fb9\u7ebf\u6837\u5f0f\uff0ctop=\u4e0a\u8fb9\u7ebf\u6837\u5f0f\uff0cbottom=\u4e0b\u8fb9\u7ebf\u6837\u5f0f)\n   <\/li>\n<li>\n    style\u53c2\u6570\u7684\u79cd\u7c7b\uff1a &#8216;double, \u2018mediumDashDotDot\u2019, \u2018slantDashDot\u2019,\u2018dashDotDot\u2019,\u2018dotted\u2019,\u2018hair\u2019, &#8216;mediumDashed, \u2018dashed\u2019, \u2018dashDot\u2019, \u2018thin\u2019,\u2018mediumDashDot\u2019,\u2018medium\u2019, &#8216;thick\u2019from openpyxl.styles import Side,Borderfrom\n   <\/li>\n<\/ul>\n<pre><code class=\"prism language-python\">openpyxl <span class=\"token keyword\">import<\/span> load_workbook\n\nworkbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename<span class=\"token operator\">=<\/span><span class=\"token string\">\"\u82b1\u56ed.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\ncell <span class=\"token operator\">=<\/span> sheet<span class=\"token punctuation\">[<\/span><span class=\"token string\">\"D6\"<\/span><span class=\"token punctuation\">]<\/span>\nside1 <span class=\"token operator\">=<\/span> Side<span class=\"token punctuation\">(<\/span>style<span class=\"token operator\">=<\/span><span class=\"token string\">\"thin\"<\/span><span class=\"token punctuation\">,<\/span>color<span class=\"token operator\">=<\/span><span class=\"token string\">\"FF0000\"<\/span><span class=\"token punctuation\">)<\/span>\nside2 <span class=\"token operator\">=<\/span> Side<span class=\"token punctuation\">(<\/span>style<span class=\"token operator\">=<\/span><span class=\"token string\">\"thick\"<\/span><span class=\"token punctuation\">,<\/span>color<span class=\"token operator\">=<\/span><span class=\"token string\">\"FFFF0000\"<\/span><span class=\"token punctuation\">)<\/span>\nborder <span class=\"token operator\">=<\/span> Border<span class=\"token punctuation\">(<\/span>left<span class=\"token operator\">=<\/span>side1<span class=\"token punctuation\">,<\/span>right<span class=\"token operator\">=<\/span>side1<span class=\"token punctuation\">,<\/span>top<span class=\"token operator\">=<\/span>side2<span class=\"token punctuation\">,<\/span>bottom<span class=\"token operator\">=<\/span>side2<span class=\"token punctuation\">)<\/span>\ncell<span class=\"token punctuation\">.<\/span>border <span class=\"token operator\">=<\/span> border\nworkbook<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"\u82b1\u56ed.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"5span_idjump35span_505\"><br \/>\n   <\/a><br \/>\n   5\uff09\u8bbe\u7f6e\u586b\u5145\u6837\u5f0f<br \/>\n   <span id=\"jump35\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    PatternFill(fill_type=\u586b\u5145\u6837\u5f0f\uff0cfgColor=\u586b\u5145\u989c\u8272\uff09\n   <\/li>\n<li>\n    GradientFill(stop=(\u6e10\u53d8\u989c\u82721\uff0c\u6e10\u53d8\u989c\u82722\u2026\u2026))\n   <\/li>\n<\/ul>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> openpyxl<span class=\"token punctuation\">.<\/span>styles <span class=\"token keyword\">import<\/span> PatternFill<span class=\"token punctuation\">,<\/span>GradientFill\n<span class=\"token keyword\">from<\/span> openpyxl <span class=\"token keyword\">import<\/span> load_workbook\n\nworkbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename<span class=\"token operator\">=<\/span><span class=\"token string\">\"\u82b1\u56ed.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\ncell_b9 <span class=\"token operator\">=<\/span> sheet<span class=\"token punctuation\">[<\/span><span class=\"token string\">\"B9\"<\/span><span class=\"token punctuation\">]<\/span>\npattern_fill <span class=\"token operator\">=<\/span> PatternFill<span class=\"token punctuation\">(<\/span>fill_type<span class=\"token operator\">=<\/span><span class=\"token string\">\"solid\"<\/span><span class=\"token punctuation\">,<\/span>fgColor<span class=\"token operator\">=<\/span><span class=\"token string\">\"99ccff\"<\/span><span class=\"token punctuation\">)<\/span>\ncell_b9<span class=\"token punctuation\">.<\/span>fill <span class=\"token operator\">=<\/span> pattern_fill\ncell_b10 <span class=\"token operator\">=<\/span> sheet<span class=\"token punctuation\">[<\/span><span class=\"token string\">\"B10\"<\/span><span class=\"token punctuation\">]<\/span>\ngradient_fill <span class=\"token operator\">=<\/span> GradientFill<span class=\"token punctuation\">(<\/span>stop<span class=\"token operator\">=<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"FFFFFF\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"99ccff\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"000000\"<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span>\ncell_b10<span class=\"token punctuation\">.<\/span>fill <span class=\"token operator\">=<\/span> gradient_fill\nworkbook<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"\u82b1\u56ed.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"6span_idjump36span_527\"><br \/>\n   <\/a><br \/>\n   6\uff09\u8bbe\u7f6e\u884c\u9ad8\u548c\u5217\u5bbd<br \/>\n   <span id=\"jump36\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    .row_dimensions[\u884c\u7f16\u53f7].height = \u884c\u9ad8\n   <\/li>\n<li>\n    .column_dimensions[\u5217\u7f16\u53f7].width = \u5217\u5bbd\n   <\/li>\n<\/ul>\n<pre><code class=\"prism language-python\">workbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename<span class=\"token operator\">=<\/span><span class=\"token string\">\"\u82b1\u56ed.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\n<span class=\"token comment\"># \u8bbe\u7f6e\u7b2c1\u884c\u7684\u9ad8\u5ea6<\/span>\nsheet<span class=\"token punctuation\">.<\/span>row_dimensions<span class=\"token punctuation\">[<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>height <span class=\"token operator\">=<\/span> <span class=\"token number\">50<\/span>\n<span class=\"token comment\"># \u8bbe\u7f6eB\u5217\u7684\u5bbd\u5ea6<\/span>\nsheet<span class=\"token punctuation\">.<\/span>column_dimensions<span class=\"token punctuation\">[<\/span><span class=\"token string\">\"B\"<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>width <span class=\"token operator\">=<\/span> <span class=\"token number\">20<\/span>\nworkbook<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"\u82b1\u56ed.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token triple-quoted-string string\">\"\"\"\nsheet.row_dimensions.height = 50\nsheet.column_dimensions.width = 30\n\u8fd9\u4e24\u53e5\u4ee3\u7801\uff0c\u662f\u5c06\u6574\u4e2a\u8868\u7684\u884c\u9ad8\u8bbe\u7f6e\u4e3a50\uff0c\u5217\u5bbd\u8bbe\u7f6e\u4e3a30\uff1b\n\"\"\"<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"7span_idjump37span_549\"><br \/>\n   <\/a><br \/>\n   7\uff09\u5408\u5e76\u5355\u5143\u683c<br \/>\n   <span id=\"jump37\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    .merge_cells(\u5f85\u5408\u5e76\u7684\u683c\u5b50\u7f16\u53f7)\n   <\/li>\n<li>\n    .merge_cells(start_row=\u8d77\u59cb\u884c\u53f7\uff0cstart_column=\u8d77\u59cb\u5217\u53f7\uff0cend_row=\u7ed3\u675f\u884c\u53f7\uff0cend_column=\u7ed3\u675f\u5217\u53f7)\n   <\/li>\n<\/ul>\n<pre><code class=\"prism language-python\">workbook <span class=\"token operator\">=<\/span> load_workbook<span class=\"token punctuation\">(<\/span>filename<span class=\"token operator\">=<\/span><span class=\"token string\">\"\u82b1\u56ed.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\nsheet<span class=\"token punctuation\">.<\/span>merge_cells<span class=\"token punctuation\">(<\/span><span class=\"token string\">\"C1:D2\"<\/span><span class=\"token punctuation\">)<\/span>\nsheet<span class=\"token punctuation\">.<\/span>merge_cells<span class=\"token punctuation\">(<\/span>start_row<span class=\"token operator\">=<\/span><span class=\"token number\">7<\/span><span class=\"token punctuation\">,<\/span>start_column<span class=\"token operator\">=<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span>end_row<span class=\"token operator\">=<\/span><span class=\"token number\">8<\/span><span class=\"token punctuation\">,<\/span>end_column<span class=\"token operator\">=<\/span><span class=\"token number\">3<\/span><span class=\"token punctuation\">)<\/span>\nworkbook<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"\u82b1\u56ed.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n<p>   \u5f53\u7136\uff0c\u4e5f\u6709\u201c\u53d6\u6d88\u5408\u5e76\u5355\u5143\u683c\u201d\uff0c\u7528\u6cd5\u4e00\u81f4\u3002\n  <\/p>\n<ul>\n<li>\n    .unmerge_cells(\u5f85\u5408\u5e76\u7684\u683c\u5b50\u7f16\u53f7)\n   <\/li>\n<li>\n    .unmerge_cells(start_row=\u8d77\u59cb\u884c\u53f7\uff0cstart_column=\u8d77\u59cb\u5217\u53f7\uff0cend_row=\u7ed3\u675f\u884c\u53f7\uff0cend_column=\u7ed3\u675f\u5217\u53f7)\n   <\/li>\n<\/ul>\n<h4>\n   <a id=\"pythonPyPDF2pdfplumberpdfspan_idjump38span_567\"><br \/>\n   <\/a><br \/>\n   \u7ae0\u8282\u4e8c\uff1apython\u4f7f\u7528PyPDF2\u548cpdfplumber\u64cd\u4f5cpdf<br \/>\n   <span id=\"jump38\"><br \/>\n   <\/span><br \/>\n  <\/h4>\n<h5>\n   <a id=\"1PyPDF2pdfplumberspan_idjump39span_568\"><br \/>\n   <\/a><br \/>\n   1\u3001PyPDF2\u548cpdfplumber\u5e93\u4ecb\u7ecd<br \/>\n   <span id=\"jump39\"><br \/>\n   <\/span><br \/>\n  <\/h5>\n<ul>\n<li>\n    PyPDF2\u5b98\u7f51\uff1a<br \/>\n    <a href=\"https:\/\/pythonhosted.org\/PyPDF2\/\" rel=\"nofollow\"><br \/>\n     PyPDF2\u5b98\u7f51<br \/>\n    <\/a><br \/>\n    \uff0c\u53ef\u4ee5\u66f4\u597d\u7684\u8bfb\u53d6\u3001\u5199\u5165\u3001\u5206\u5272\u3001\u5408\u5e76PDF\u6587\u4ef6\uff1b\n   <\/li>\n<li>\n    pdfplumber\u5b98\u7f51\uff1a<br \/>\n    <a href=\"https:\/\/github.com\/jsvine\/pdfplumber\"><br \/>\n     pdfplumber\u5b98\u7f51<br \/>\n    <\/a><br \/>\n    \uff0c\u53ef\u4ee5\u66f4\u597d\u5730\u8bfb\u53d6PDF\u6587\u4ef6\u5185\u5bb9\u548c\u63d0\u53d6PDF\u4e2d\u7684\u8868\u683c\uff1b\n   <\/li>\n<li>\n    \u8fd9\u4e24\u4e2a\u5e93\u4e0d\u5c5e\u4e8epython\u6807\u51c6\u5e93\uff0c\u90fd\u9700\u8981\u5355\u72ec\u5b89\u88c5\uff1b\n   <\/li>\n<\/ul>\n<h5>\n   <a id=\"2pythonPDFspan_idjump40span_573\"><br \/>\n   <\/a><br \/>\n   2\u3001python\u63d0\u53d6PDF\u6587\u5b57\u5185\u5bb9<br \/>\n   <span id=\"jump40\"><br \/>\n   <\/span><br \/>\n  <\/h5>\n<h6>\n   <a id=\"1pdfplumberspan_idjump41span_574\"><br \/>\n   <\/a><br \/>\n   1\uff09\u5229\u7528pdfplumber\u63d0\u53d6\u6587\u5b57<br \/>\n   <span id=\"jump41\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">import<\/span> PyPDF2\n<span class=\"token keyword\">import<\/span> pdfplumber\n\n<span class=\"token keyword\">with<\/span> pdfplumber<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">open<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"\u9910\u996e\u4f01\u4e1a\u7efc\u5408\u5206\u6790.pdf\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">as<\/span> p<span class=\"token punctuation\">:<\/span>\n    page <span class=\"token operator\">=<\/span> p<span class=\"token punctuation\">.<\/span>pages<span class=\"token punctuation\">[<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">]<\/span>\n    <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>page<span class=\"token punctuation\">.<\/span>extract_text<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"2pdfplumberexcelspan_idjump42span_588\"><br \/>\n   <\/a><br \/>\n   2\uff09\u5229\u7528pdfplumber\u63d0\u53d6\u8868\u683c\u5e76\u5199\u5165excel<br \/>\n   <span id=\"jump42\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    extract_table()\uff1a\u5982\u679c\u4e00\u9875\u6709\u4e00\u4e2a\u8868\u683c\uff1b\n   <\/li>\n<li>\n    extract_tables()\uff1a\u5982\u679c\u4e00\u9875\u6709\u591a\u4e2a\u8868\u683c\uff1b\n   <\/li>\n<\/ul>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">import<\/span> PyPDF2\n<span class=\"token keyword\">import<\/span> pdfplumber\n<span class=\"token keyword\">from<\/span> openpyxl <span class=\"token keyword\">import<\/span> Workbook\n\n<span class=\"token keyword\">with<\/span> pdfplumber<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">open<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"\u9910\u996e\u4f01\u4e1a\u7efc\u5408\u5206\u6790.pdf\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">as<\/span> p<span class=\"token punctuation\">:<\/span>\n    page <span class=\"token operator\">=<\/span> p<span class=\"token punctuation\">.<\/span>pages<span class=\"token punctuation\">[<\/span><span class=\"token number\">4<\/span><span class=\"token punctuation\">]<\/span>\n    table <span class=\"token operator\">=<\/span> page<span class=\"token punctuation\">.<\/span>extract_table<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n    <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>table<span class=\"token punctuation\">)<\/span>\n    \n    workbook <span class=\"token operator\">=<\/span> Workbook<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n    sheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\n    <span class=\"token keyword\">for<\/span> row <span class=\"token keyword\">in<\/span> table<span class=\"token punctuation\">:<\/span>\n        <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> <span class=\"token string\">\"\"<\/span><span class=\"token punctuation\">.<\/span>join<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">==<\/span> <span class=\"token string\">\"\"<\/span>\n            sheet<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span>row<span class=\"token punctuation\">)<\/span>\n    workbook<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"\u65b0pdf.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n<p>   \u7f3a\u9677\uff1a\u53ef\u4ee5\u770b\u5230\uff0c\u8fd9\u91cc\u63d0\u53d6\u51fa\u6765\u7684\u8868\u683c\u6709\u5f88\u591a\u7a7a\u884c\uff0c\u600e\u4e48\u53bb\u6389\u8fd9\u4e9b\u7a7a\u884c\u5462\uff1f<br \/>\n   <br \/>\n   \u5224\u65ad\uff1a\u5c06\u5217\u8868\u4e2d\u6bcf\u4e2a\u5143\u7d20\u90fd\u8fde\u63a5\u6210\u4e00\u4e2a\u5b57\u7b26\u4e32\uff0c\u5982\u679c\u8fd8\u662f\u4e00\u4e2a\u7a7a\u5b57\u7b26\u4e32\u90a3\u4e48\u80af\u5b9a\u5c31\u662f\u7a7a\u884c\u3002\n  <\/p>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">import<\/span> PyPDF2\n<span class=\"token keyword\">import<\/span> pdfplumber\n<span class=\"token keyword\">from<\/span> openpyxl <span class=\"token keyword\">import<\/span> Workbook\n\n<span class=\"token keyword\">with<\/span> pdfplumber<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">open<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"\u9910\u996e\u4f01\u4e1a\u7efc\u5408\u5206\u6790.pdf\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">as<\/span> p<span class=\"token punctuation\">:<\/span>\n    page <span class=\"token operator\">=<\/span> p<span class=\"token punctuation\">.<\/span>pages<span class=\"token punctuation\">[<\/span><span class=\"token number\">4<\/span><span class=\"token punctuation\">]<\/span>\n    table <span class=\"token operator\">=<\/span> page<span class=\"token punctuation\">.<\/span>extract_table<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n    <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>table<span class=\"token punctuation\">)<\/span>\n    \n    workbook <span class=\"token operator\">=<\/span> Workbook<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n    sheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\n    <span class=\"token keyword\">for<\/span> row <span class=\"token keyword\">in<\/span> table<span class=\"token punctuation\">:<\/span>\n        <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> <span class=\"token string\">\"\"<\/span><span class=\"token punctuation\">.<\/span>join<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">[<\/span><span class=\"token builtin\">str<\/span><span class=\"token punctuation\">(<\/span>i<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">for<\/span> i <span class=\"token keyword\">in<\/span> row<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">==<\/span> <span class=\"token string\">\"\"<\/span><span class=\"token punctuation\">:<\/span>\n            sheet<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span>row<span class=\"token punctuation\">)<\/span>\n    workbook<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">\"\u65b0pdf.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h5>\n   <a id=\"3PDFspan_idjump43span_636\"><br \/>\n   <\/a><br \/>\n   3\u3001PDF\u5408\u5e76\u53ca\u9875\u9762\u7684\u6392\u5e8f\u548c\u65cb\u8f6c<br \/>\n   <span id=\"jump43\"><br \/>\n   <\/span><br \/>\n  <\/h5>\n<h6>\n   <a id=\"1pdfspan_idjump44span_637\"><br \/>\n   <\/a><br \/>\n   1\uff09\u5206\u5272\u53ca\u5408\u5e76pdf<br \/>\n   <span id=\"jump44\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<h6>\n   <a id=\"_pdfspan_idjump45span_638\"><br \/>\n   <\/a><br \/>\n   \u2460 \u5408\u5e76pdf<br \/>\n   <span id=\"jump45\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<p>\n   \u9996\u5148\uff0c\u6211\u4eec\u6709\u5982\u4e0b\u51e0\u4e2a\u6587\u4ef6\uff0c\u53ef\u4ee5\u53d1\u73b0\u8fd9\u91cc\u5171\u6709\u4e09\u4e2aPDF\u6587\u4ef6\u9700\u8981\u6211\u4eec\u5408\u5e76\u3002\u540c\u65f6\u53ef\u4ee5\u53d1\u73b0\u4ed6\u4eec\u7684\u6587\u4ef6\u540d\u90fd\u662f\u6709\u89c4\u5f8b\u7684(\u5982\u679c\u6587\u4ef6\u540d\uff0c\u6ca1\u6709\u5148\u540e\u987a\u5e8f\uff0c\u6211\u4eec\u5408\u5e76\u8d77\u6765\u5c31\u6ca1\u6709\u610f\u4e49\u4e86\u3002)<\/p>\n<p>   \u4ee3\u7801\u5982\u4e0b\uff1a\n  <\/p>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> PyPDF2 <span class=\"token keyword\">import<\/span> PdfFileReader<span class=\"token punctuation\">,<\/span> PdfFileWriter\n\npdf_writer <span class=\"token operator\">=<\/span> PdfFileWriter<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">for<\/span> i <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">range<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>os<span class=\"token punctuation\">.<\/span>listdir<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_pdf\"<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token operator\">+<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\n    <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>i<span class=\"token operator\">*<\/span><span class=\"token number\">50<\/span><span class=\"token operator\">+<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span><span class=\"token punctuation\">(<\/span>i<span class=\"token operator\">+<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><span class=\"token operator\">*<\/span><span class=\"token number\">50<\/span><span class=\"token punctuation\">)<\/span>\n    pdf_reader <span class=\"token operator\">=<\/span> PdfFileReader<span class=\"token punctuation\">(<\/span><span class=\"token string\">\"G:\\\\6Tipdm\\\\7python\u529e\u516c\u81ea\u52a8\u5316\\\\concat_pdf\\{}-{}.pdf\"<\/span><span class=\"token punctuation\">.<\/span><span class=\"token builtin\">format<\/span><span class=\"token punctuation\">(<\/span>i<span class=\"token operator\">*<\/span><span class=\"token number\">50<\/span><span class=\"token operator\">+<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span><span class=\"token punctuation\">(<\/span>i<span class=\"token operator\">+<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><span class=\"token operator\">*<\/span><span class=\"token number\">50<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span>\n    <span class=\"token keyword\">for<\/span> page <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">range<\/span><span class=\"token punctuation\">(<\/span>pdf_reader<span class=\"token punctuation\">.<\/span>getNumPages<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\n        pdf_writer<span class=\"token punctuation\">.<\/span>addPage<span class=\"token punctuation\">(<\/span>pdf_reader<span class=\"token punctuation\">.<\/span>getPage<span class=\"token punctuation\">(<\/span>page<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span>\n        \n<span class=\"token keyword\">with<\/span> <span class=\"token builtin\">open<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"G:\\\\6Tipdm\\\\7python\u529e\u516c\u81ea\u52a8\u5316\\\\concat_pdf\\merge.pdf\"<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">\"wb\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">as<\/span> out<span class=\"token punctuation\">:<\/span>\n    pdf_writer<span class=\"token punctuation\">.<\/span>write<span class=\"token punctuation\">(<\/span>out<span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_pdfspan_idjump46span_660\"><br \/>\n   <\/a><br \/>\n   \u2461 \u62c6\u5206pdf<br \/>\n   <span id=\"jump46\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<p>\n   \u8fd9\u91cc\u6709\u4e00\u4e2a\u201c\u65f6\u95f4\u5e8f\u5217.pdf\u201d\u7684\u6587\u4ef6\uff0c\u51713\u9875\uff0c\u6211\u4eec\u5c06\u5176\u6bcf\u4e00\u9875\u5b58\u4e3a\u4e00\u4e2aPDF\u6587\u4ef6\u3002<\/p>\n<p>   \u4ee3\u7801\u5982\u4e0b\uff1a\n  <\/p>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> PyPDF2 <span class=\"token keyword\">import<\/span> PdfFileReader<span class=\"token punctuation\">,<\/span> PdfFileWriter\n\npdf_reader <span class=\"token operator\">=<\/span> PdfFileReader<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_pdf\\\u65f6\u95f4\u5e8f\u5217.pdf\"<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">for<\/span> page <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">range<\/span><span class=\"token punctuation\">(<\/span>pdf_reader<span class=\"token punctuation\">.<\/span>getNumPages<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\n    pdf_writer <span class=\"token operator\">=<\/span> PdfFileWriter<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n    pdf_writer<span class=\"token punctuation\">.<\/span>addPage<span class=\"token punctuation\">(<\/span>pdf_reader<span class=\"token punctuation\">.<\/span>getPage<span class=\"token punctuation\">(<\/span>page<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span>\n    <span class=\"token keyword\">with<\/span> <span class=\"token builtin\">open<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f\"G:\\\\6Tipdm\\\\7python\u529e\u516c\u81ea\u52a8\u5316\\\\concat_pdf\\\\<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<!-- --><\/span>page<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">.pdf\"<\/span><\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">\"wb\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">as<\/span> out<span class=\"token punctuation\">:<\/span>\n        pdf_writer<span class=\"token punctuation\">.<\/span>write<span class=\"token punctuation\">(<\/span>out<span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"2pdfspan_idjump47span_679\"><br \/>\n   <\/a><br \/>\n   2\uff09\u65cb\u8f6c\u53ca\u6392\u5e8fpdf<br \/>\n   <span id=\"jump47\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<h6>\n   <a id=\"_pdfspan_idjump48span_680\"><br \/>\n   <\/a><br \/>\n   \u2460 \u65cb\u8f6cpdf<br \/>\n   <span id=\"jump48\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    .rotateClockwise(90\u7684\u500d\u6570)\uff1a\u987a\u65f6\u9488\u65cb\u8f6c90\u5ea6\n   <\/li>\n<li>\n    .rotateCounterClockwise(90\u7684\u500d\u6570)\uff1a\u9006\u65f6\u9488\u65cb\u8f6c90\u5ea6\n   <\/li>\n<\/ul>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> PyPDF2 <span class=\"token keyword\">import<\/span> PdfFileReader<span class=\"token punctuation\">,<\/span> PdfFileWriter\n\npdf_reader <span class=\"token operator\">=<\/span> PdfFileReader<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_pdf\\\u65f6\u95f4\u5e8f\u5217.pdf\"<\/span><span class=\"token punctuation\">)<\/span>\npdf_writer <span class=\"token operator\">=<\/span> PdfFileWriter<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">for<\/span> page <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">range<\/span><span class=\"token punctuation\">(<\/span>pdf_reader<span class=\"token punctuation\">.<\/span>getNumPages<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\n    <span class=\"token keyword\">if<\/span> page <span class=\"token operator\">%<\/span> <span class=\"token number\">2<\/span> <span class=\"token operator\">==<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">:<\/span>\n        rotation_page <span class=\"token operator\">=<\/span> pdf_reader<span class=\"token punctuation\">.<\/span>getPage<span class=\"token punctuation\">(<\/span>page<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>rotateCounterClockwise<span class=\"token punctuation\">(<\/span><span class=\"token number\">90<\/span><span class=\"token punctuation\">)<\/span>\n    <span class=\"token keyword\">else<\/span><span class=\"token punctuation\">:<\/span>\n        rotation_page <span class=\"token operator\">=<\/span> pdf_reader<span class=\"token punctuation\">.<\/span>getPage<span class=\"token punctuation\">(<\/span>page<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>rotateClockwise<span class=\"token punctuation\">(<\/span><span class=\"token number\">90<\/span><span class=\"token punctuation\">)<\/span>\n    pdf_writer<span class=\"token punctuation\">.<\/span>addPage<span class=\"token punctuation\">(<\/span>rotation_page<span class=\"token punctuation\">)<\/span>\n    <span class=\"token keyword\">with<\/span> <span class=\"token builtin\">open<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"G:\\\\6Tipdm\\\\7python\u529e\u516c\u81ea\u52a8\u5316\\\\concat_pdf\\\\\u65cb\u8f6c.pdf\"<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">\"wb\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">as<\/span> out<span class=\"token punctuation\">:<\/span>\n        pdf_writer<span class=\"token punctuation\">.<\/span>write<span class=\"token punctuation\">(<\/span>out<span class=\"token punctuation\">)<\/span>\n<span class=\"token triple-quoted-string string\">\"\"\"\n\u4e0a\u8ff0\u4ee3\u7801\u4e2d\uff0c\u6211\u4eec\u5faa\u73af\u904d\u5386\u4e86\u8fd9\u4e2apdf\uff0c\u5bf9\u4e8e\u5076\u6570\u9875\u6211\u4eec\u9006\u65f6\u9488\u65cb\u8f6c90\u00b0\uff0c\u5bf9\u4e8e\u5947\u6570\u9875\u6211\u4eec\u987a\u65f6\u9488\u65cb\u8f6c90\u00b0\uff1b\n\u6ce8\u610f\uff1a\u65cb\u8f6c\u7684\u89d2\u5ea6\u53ea\u80fd\u662f90\u7684\u500d\u6570\uff1b\n\"\"\"<\/span>\n<\/code><\/pre>\n<p>\n   \u5176\u4e2d\u4e00\u9875\u6548\u679c\u5c55\u793a\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_pdfspan_idjump49span_706\"><br \/>\n   <\/a><br \/>\n   \u2461 \u6392\u5e8fpdf<br \/>\n   <span id=\"jump49\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<p>\n   \u9700\u6c42\uff1a\u6211\u4eec\u6709\u4e00\u4e2aPDF\u6587\u4ef6\uff0c\u6211\u4eec\u9700\u8981\u5012\u5e8f\u6392\u5217\uff0c\u5e94\u8be5\u600e\u4e48\u505a\u5462\uff1f<br \/>\n   <br \/>\n   \u9996\u5148\uff0c\u6211\u4eec\u6765\u770bpython\u4e2d\uff0c\u600e\u4e48\u5012\u53d9\u6253\u5370\u4e00\u4e32\u6570\u5b57\uff0c\u5982\u4e0b\u56fe\u6240\u793a\u3002<\/p>\n<p>   \u90a3\u4e48\u5012\u5e8f\u6392\u5217\u4e00\u4e2apdf\uff0c\u601d\u8def\u540c\u4e0a\uff0c\u4ee3\u7801\u5982\u4e0b\uff1a\n  <\/p>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> PyPDF2 <span class=\"token keyword\">import<\/span> PdfFileReader<span class=\"token punctuation\">,<\/span> PdfFileWriter\n\npdf_reader <span class=\"token operator\">=<\/span> PdfFileReader<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_pdf\\\u65f6\u95f4\u5e8f\u5217.pdf\"<\/span><span class=\"token punctuation\">)<\/span>\npdf_writer <span class=\"token operator\">=<\/span> PdfFileWriter<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">for<\/span> page <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">range<\/span><span class=\"token punctuation\">(<\/span>pdf_reader<span class=\"token punctuation\">.<\/span>getNumPages<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token operator\">-<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token operator\">-<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token operator\">-<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\n    pdf_writer<span class=\"token punctuation\">.<\/span>addPage<span class=\"token punctuation\">(<\/span>pdf_reader<span class=\"token punctuation\">.<\/span>getPage<span class=\"token punctuation\">(<\/span>page<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">with<\/span> <span class=\"token builtin\">open<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"G:\\\\6Tipdm\\\\7python\u529e\u516c\u81ea\u52a8\u5316\\\\concat_pdf\\\\\u5012\u5e8f.pdf\"<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">\"wb\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">as<\/span> out<span class=\"token punctuation\">:<\/span>\n        pdf_writer<span class=\"token punctuation\">.<\/span>write<span class=\"token punctuation\">(<\/span>out<span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h5>\n   <a id=\"4pdfspan_idjump50span_725\"><br \/>\n   <\/a><br \/>\n   4\u3001pdf\u6279\u91cf\u52a0\u6c34\u5370\u53ca\u52a0\u5bc6\u3001\u89e3\u5bc6<br \/>\n   <span id=\"jump50\"><br \/>\n   <\/span><br \/>\n  <\/h5>\n<h6>\n   <a id=\"1span_idjump51span_726\"><br \/>\n   <\/a><br \/>\n   1\uff09\u6279\u91cf\u52a0\u6c34\u5370<br \/>\n   <span id=\"jump51\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> PyPDF2 <span class=\"token keyword\">import<\/span> PdfFileReader<span class=\"token punctuation\">,<\/span> PdfFileWriter\n<span class=\"token keyword\">from<\/span> copy <span class=\"token keyword\">import<\/span> copy\n\nwater <span class=\"token operator\">=<\/span> PdfFileReader<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_pdf\\\u6c34\u5370.pdf\"<\/span><span class=\"token punctuation\">)<\/span>\nwater_page <span class=\"token operator\">=<\/span> water<span class=\"token punctuation\">.<\/span>getPage<span class=\"token punctuation\">(<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">)<\/span>\n\npdf_reader <span class=\"token operator\">=<\/span> PdfFileReader<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_pdf\\aa.pdf\"<\/span><span class=\"token punctuation\">)<\/span>\npdf_writer <span class=\"token operator\">=<\/span> PdfFileWriter<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n\n<span class=\"token keyword\">for<\/span> page <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">range<\/span><span class=\"token punctuation\">(<\/span>pdf_reader<span class=\"token punctuation\">.<\/span>getNumPages<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\n    my_page <span class=\"token operator\">=<\/span> pdf_reader<span class=\"token punctuation\">.<\/span>getPage<span class=\"token punctuation\">(<\/span>page<span class=\"token punctuation\">)<\/span>\n    new_page <span class=\"token operator\">=<\/span> copy<span class=\"token punctuation\">(<\/span>water_page<span class=\"token punctuation\">)<\/span>\n    new_page<span class=\"token punctuation\">.<\/span>mergePage<span class=\"token punctuation\">(<\/span>my_page<span class=\"token punctuation\">)<\/span>\n    pdf_writer<span class=\"token punctuation\">.<\/span>addPage<span class=\"token punctuation\">(<\/span>new_page<span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">with<\/span> <span class=\"token builtin\">open<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"G:\\\\6Tipdm\\\\7python\u529e\u516c\u81ea\u52a8\u5316\\\\concat_pdf\\\\\u6dfb\u52a0\u6c34\u5370\u540e\u7684aa.pdf\"<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">\"wb\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">as<\/span> out<span class=\"token punctuation\">:<\/span>\n        pdf_writer<span class=\"token punctuation\">.<\/span>write<span class=\"token punctuation\">(<\/span>out<span class=\"token punctuation\">)<\/span>  \n<span class=\"token triple-quoted-string string\">\"\"\"\n\u8fd9\u91cc\u6709\u4e00\u70b9\u9700\u8981\u6ce8\u610f\uff1a\u8fdb\u884cpdf\u5408\u5e76\u7684\u65f6\u5019\uff0c\u6211\u4eec\u5e0c\u671b\u201c\u6c34\u5370\u201d\u5728\u4e0b\u9762\uff0c\u6587\u5b57\u5728\u4e0a\u9762\uff0c\u56e0\u6b64\u662f\u201c\u6c34\u5370\u201d.mergePage(\u201c\u56fe\u7247\u9875\u201d)\n\"\"\"<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"2span_idjump52span_753\"><br \/>\n   <\/a><br \/>\n   2\uff09\u6279\u91cf\u52a0\u5bc6\u3001\u89e3\u5bc6<br \/>\n   <span id=\"jump52\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    \u8fd9\u91cc\u6240\u8bf4\u7684\u201c\u89e3\u5bc6\u201d\uff0c\u662f\u5728\u77e5\u9053pdf\u7684\u5bc6\u7801\u4e0b\uff0c\u53bb\u6253\u5f00pdf\uff0c\u800c\u4e0d\u662f\u66b4\u529b\u7834\u89e3\uff1b\n   <\/li>\n<\/ul>\n<h6>\n   <a id=\"_pdfspan_idjump53span_756\"><br \/>\n   <\/a><br \/>\n   \u2460 \u52a0\u5bc6pdf<br \/>\n   <span id=\"jump53\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> PyPDF2 <span class=\"token keyword\">import<\/span> PdfFileReader<span class=\"token punctuation\">,<\/span> PdfFileWriter\n\npdf_reader <span class=\"token operator\">=<\/span> PdfFileReader<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_pdf\\\u65f6\u95f4\u5e8f\u5217.pdf\"<\/span><span class=\"token punctuation\">)<\/span>\npdf_writer <span class=\"token operator\">=<\/span> PdfFileWriter<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">for<\/span> page <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">range<\/span><span class=\"token punctuation\">(<\/span>pdf_reader<span class=\"token punctuation\">.<\/span>getNumPages<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\n    pdf_writer<span class=\"token punctuation\">.<\/span>addPage<span class=\"token punctuation\">(<\/span>pdf_reader<span class=\"token punctuation\">.<\/span>getPage<span class=\"token punctuation\">(<\/span>page<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token comment\"># \u6dfb\u52a0\u5bc6\u7801<\/span>\npdf_writer<span class=\"token punctuation\">.<\/span>encrypt<span class=\"token punctuation\">(<\/span><span class=\"token string\">\"a123456\"<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">with<\/span> <span class=\"token builtin\">open<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"G:\\\\6Tipdm\\\\7python\u529e\u516c\u81ea\u52a8\u5316\\\\concat_pdf\\\\\u65f6\u95f4\u5e8f\u5217.pdf\"<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">\"wb\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">as<\/span> out<span class=\"token punctuation\">:<\/span>\n        pdf_writer<span class=\"token punctuation\">.<\/span>write<span class=\"token punctuation\">(<\/span>out<span class=\"token punctuation\">)<\/span>  \n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_pdfpdfspan_idjump54span_774\"><br \/>\n   <\/a><br \/>\n   \u2461 \u89e3\u5bc6pdf\u5e76\u4fdd\u5b58\u4e3a\u672a\u52a0\u5bc6\u7684pdf<br \/>\n   <span id=\"jump54\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> PyPDF2 <span class=\"token keyword\">import<\/span> PdfFileReader<span class=\"token punctuation\">,<\/span> PdfFileWriter\n\npdf_reader <span class=\"token operator\">=<\/span> PdfFileReader<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_pdf\\\u65f6\u95f4\u5e8f\u5217.pdf\"<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token comment\"># \u89e3\u5bc6pdf<\/span>\npdf_reader<span class=\"token punctuation\">.<\/span>decrypt<span class=\"token punctuation\">(<\/span><span class=\"token string\">\"a123456\"<\/span><span class=\"token punctuation\">)<\/span>\npdf_writer <span class=\"token operator\">=<\/span> PdfFileWriter<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">for<\/span> page <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">range<\/span><span class=\"token punctuation\">(<\/span>pdf_reader<span class=\"token punctuation\">.<\/span>getNumPages<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\n    pdf_writer<span class=\"token punctuation\">.<\/span>addPage<span class=\"token punctuation\">(<\/span>pdf_reader<span class=\"token punctuation\">.<\/span>getPage<span class=\"token punctuation\">(<\/span>page<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">with<\/span> <span class=\"token builtin\">open<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"G:\\\\6Tipdm\\\\7python\u529e\u516c\u81ea\u52a8\u5316\\\\concat_pdf\\\\\u672a\u52a0\u5bc6\u7684\u65f6\u95f4\u5e8f\u5217.pdf\"<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">\"wb\"<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">as<\/span> out<span class=\"token punctuation\">:<\/span>\n        pdf_writer<span class=\"token punctuation\">.<\/span>write<span class=\"token punctuation\">(<\/span>out<span class=\"token punctuation\">)<\/span>  \n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h4>\n   <a id=\"pythonpythondocxwordspan_idjump55span_790\"><br \/>\n   <\/a><br \/>\n   \u7ae0\u8282\u4e09\uff1apython\u4f7f\u7528python-docx\u64cd\u4f5cword<br \/>\n   <span id=\"jump55\"><br \/>\n   <\/span><br \/>\n  <\/h4>\n<h5>\n   <a id=\"1pythondocxspan_idjump56span_791\"><br \/>\n   <\/a><br \/>\n   1\u3001python-docx\u5e93\u4ecb\u7ecd<br \/>\n   <span id=\"jump56\"><br \/>\n   <\/span><br \/>\n  <\/h5>\n<ul>\n<li>\n    \u8be5\u6a21\u5757\u513f\u53ef\u4ee5\u521b\u5efa\u3001\u4fee\u6539Word\uff08.docx\uff09\u6587\u4ef6\uff1b\n   <\/li>\n<li>\n    \u6b64\u6a21\u5757\u513f\u4e0d\u5c5e\u4e8epython\u6807\u51c6\u5e93\uff0c\u9700\u8981\u5355\u72ec\u5b89\u88c5\uff1b\n   <\/li>\n<li>\n    python-docx\u4f7f\u7528\u5b98\u7f51\uff1a<br \/>\n    <a href=\"https:\/\/python-docx.readthedocs.io\/en\/latest\/\" rel=\"nofollow\"><br \/>\n     python-docx\u5b98\u7f51<br \/>\n    <\/a>\n   <\/li>\n<li>\n    \u6211\u4eec\u5728\u5b89\u88c5\u6b64\u6a21\u5757\u513f\u4f7f\u7528\u7684\u662fpip install python-docx\uff0c\u4f46\u662f\u5728\u5bfc\u5165\u7684\u65f6\u5019\u662fimport docx\uff1b\n   <\/li>\n<\/ul>\n<h5>\n   <a id=\"2PythonWordspan_idjump57span_797\"><br \/>\n   <\/a><br \/>\n   2\u3001Python\u8bfb\u53d6Word\u6587\u6863\u5185\u5bb9<br \/>\n   <span id=\"jump57\"><br \/>\n   <\/span><br \/>\n  <\/h5>\n<ul>\n<li>\n    \u6ce8\u610f\uff1a\u6bcf\u8fdb\u884c\u4e00\u4e2a\u64cd\u4f5c\uff0c\u5fc5\u987b\u4fdd\u5b58\u4e00\u4e0b\uff0c\u5426\u5219\u7b49\u4e8e\u767d\u505a\uff1b\n   <\/li>\n<\/ul>\n<h6>\n   <a id=\"1wordspan_idjump58span_800\"><br \/>\n   <\/a><br \/>\n   1\uff09word\u6587\u6863\u7ed3\u6784\u4ecb\u7ecd<br \/>\n   <span id=\"jump58\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<\/p>\n<h6>\n   <a id=\"2pythondocxspan_idjump59span_802\"><br \/>\n   <\/a><br \/>\n   2\uff09python-docx\u63d0\u53d6\u6587\u5b57\u548c\u6587\u5b57\u5757\u513f<br \/>\n   <span id=\"jump59\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<h6>\n   <a id=\"_pythondocxspan_idjump60span_803\"><br \/>\n   <\/a><br \/>\n   \u2460 python-docx\u63d0\u53d6\u6587\u5b57<br \/>\n   <span id=\"jump60\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<p>\n   \u6709\u4e00\u4e2a\u8fd9\u6837\u7684docx\u6587\u4ef6\uff0c\u6211\u4eec\u60f3\u8981\u63d0\u53d6\u5176\u4e2d\u7684\u6587\u5b57\uff0c\u5e94\u8be5\u600e\u4e48\u505a\uff1f<\/p>\n<p>   \u4ee3\u7801\u5982\u4e0b\uff1a\n  <\/p>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> docx <span class=\"token keyword\">import<\/span> Document\n\ndoc <span class=\"token operator\">=<\/span> Document<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_word\\test1.docx\"<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>doc<span class=\"token punctuation\">.<\/span>paragraphs<span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">for<\/span> paragraph <span class=\"token keyword\">in<\/span> doc<span class=\"token punctuation\">.<\/span>paragraphs<span class=\"token punctuation\">:<\/span>\n    <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>paragraph<span class=\"token punctuation\">.<\/span>text<span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_pythondocxspan_idjump61span_820\"><br \/>\n   <\/a><br \/>\n   \u2461 python-docx\u63d0\u53d6\u6587\u5b57\u5757\u513f<br \/>\n   <span id=\"jump61\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> docx <span class=\"token keyword\">import<\/span> Document\n\ndoc <span class=\"token operator\">=<\/span> Document<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_word\\test1.docx\"<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>doc<span class=\"token punctuation\">.<\/span>paragraphs<span class=\"token punctuation\">)<\/span>\nparagraph <span class=\"token operator\">=<\/span> doc<span class=\"token punctuation\">.<\/span>paragraphs<span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span>\nruns <span class=\"token operator\">=<\/span> paragraph<span class=\"token punctuation\">.<\/span>runs\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>runs<span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">for<\/span> run <span class=\"token keyword\">in<\/span> paragraph<span class=\"token punctuation\">.<\/span>runs<span class=\"token punctuation\">:<\/span>\n    <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>run<span class=\"token punctuation\">.<\/span>text<span class=\"token punctuation\">)<\/span>\n<span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span><span class=\"token operator\">-<\/span>\nparagraph <span class=\"token operator\">=<\/span> doc<span class=\"token punctuation\">.<\/span>paragraphs<span class=\"token punctuation\">[<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">]<\/span>\nruns <span class=\"token operator\">=<\/span> paragraph<span class=\"token punctuation\">.<\/span>runs\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>runs<span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">for<\/span> run <span class=\"token keyword\">in<\/span> paragraph<span class=\"token punctuation\">.<\/span>runs<span class=\"token punctuation\">:<\/span>\n    <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>run<span class=\"token punctuation\">.<\/span>text<span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"3PythonWordspan_idjump62span_843\"><br \/>\n   <\/a><br \/>\n   3\uff09\u5229\u7528Python\u5411Word\u6587\u6863\u5199\u5165\u5185\u5bb9<br \/>\n   <span id=\"jump62\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<h6>\n   <a id=\"_span_idjump63span_844\"><br \/>\n   <\/a><br \/>\n   \u2460 \u6dfb\u52a0\u6bb5\u843d<br \/>\n   <span id=\"jump63\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> docx <span class=\"token keyword\">import<\/span> Document\n\ndoc <span class=\"token operator\">=<\/span> Document<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_word\\test1.docx\"<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token comment\"># print(doc.add_heading(\"\u4e00\u7ea7\u6807\u9898\", level=1))   \u6dfb\u52a0\u4e00\u7ea7\u6807\u9898\u7684\u65f6\u5019\u51fa\u9519\uff0c\u8fd8\u6ca1\u6709\u89e3\u51b3\uff01<\/span>\nparagraph1 <span class=\"token operator\">=<\/span> doc<span class=\"token punctuation\">.<\/span>add_paragraph<span class=\"token punctuation\">(<\/span><span class=\"token string\">\"\u8fd9\u662f\u4e00\u4e2a\u6bb5\u843d\"<\/span><span class=\"token punctuation\">)<\/span>\nparagraph2 <span class=\"token operator\">=<\/span> doc<span class=\"token punctuation\">.<\/span>add_paragraph<span class=\"token punctuation\">(<\/span><span class=\"token string\">\"\u8fd9\u662f\u7b2c\u4e8c\u4e2a\u6bb5\u843d\"<\/span><span class=\"token punctuation\">)<\/span>\ndoc<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_word\\test1.docx\"<\/span><span class=\"token punctuation\">)<\/span> \n<span class=\"token triple-quoted-string string\">\"\"\"\n\u6dfb\u52a0\u6bb5\u843d\u7684\u65f6\u5019\uff0c\u8d4b\u503c\u7ed9\u4e00\u4e2a\u53d8\u91cf\uff0c\u65b9\u4fbf\u6211\u4eec\u540e\u9762\u8fdb\u884c\u683c\u5f0f\u8c03\u6574\uff1b\n\"\"\"<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_span_idjump64span_862\"><br \/>\n   <\/a><br \/>\n   \u2461 \u6dfb\u52a0\u6587\u5b57\u5757\u513f<br \/>\n   <span id=\"jump64\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> docx <span class=\"token keyword\">import<\/span> Document\n\ndoc <span class=\"token operator\">=<\/span> Document<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_word\\test1.docx\"<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token comment\"># \u8fd9\u91cc\u76f8\u5f53\u4e8e\u8f93\u5165\u4e86\u4e00\u4e2a\u7a7a\u683c\uff0c\u540e\u9762\u7b49\u5f85\u7740\u6587\u5b57\u8f93\u5165<\/span>\nparagraph3 <span class=\"token operator\">=<\/span> doc<span class=\"token punctuation\">.<\/span>add_paragraph<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\nparagraph3<span class=\"token punctuation\">.<\/span>add_run<span class=\"token punctuation\">(<\/span><span class=\"token string\">\"\u6211\u88ab\u52a0\u7c97\u4e86\u6587\u5b57\u5757\u513f\"<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>bold <span class=\"token operator\">=<\/span> <span class=\"token boolean\">True<\/span>\nparagraph3<span class=\"token punctuation\">.<\/span>add_run<span class=\"token punctuation\">(<\/span><span class=\"token string\">\"\uff0c\u6211\u662f\u666e\u901a\u6587\u5b57\u5757\u513f\uff0c\"<\/span><span class=\"token punctuation\">)<\/span>\nparagraph3<span class=\"token punctuation\">.<\/span>add_run<span class=\"token punctuation\">(<\/span><span class=\"token string\">\"\u6211\u662f\u659c\u4f53\u6587\u5b57\u5757\u513f\"<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>italic <span class=\"token operator\">=<\/span> <span class=\"token boolean\">True<\/span>\ndoc<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_word\\test1.docx\"<\/span><span class=\"token punctuation\">)<\/span> \n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_span_idjump65span_879\"><br \/>\n   <\/a><br \/>\n   \u2462 \u6dfb\u52a0\u4e00\u4e2a\u5206\u9875<br \/>\n   <span id=\"jump65\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> docx <span class=\"token keyword\">import<\/span> Document\n\ndoc <span class=\"token operator\">=<\/span> Document<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_word\\test1.docx\"<\/span><span class=\"token punctuation\">)<\/span>\ndoc<span class=\"token punctuation\">.<\/span>add_page_break<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\ndoc<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_word\\test1.docx\"<\/span><span class=\"token punctuation\">)<\/span> \n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_span_idjump66span_892\"><br \/>\n   <\/a><br \/>\n   \u2463 \u6dfb\u52a0\u56fe\u7247<br \/>\n   <span id=\"jump66\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> docx <span class=\"token keyword\">import<\/span> Document\n<span class=\"token keyword\">from<\/span> docx<span class=\"token punctuation\">.<\/span>shared <span class=\"token keyword\">import<\/span> Cm\n\ndoc <span class=\"token operator\">=<\/span> Document<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_word\\test1.docx\"<\/span><span class=\"token punctuation\">)<\/span>\ndoc<span class=\"token punctuation\">.<\/span>add_picture<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_word\\sun_wu_kong.png\"<\/span><span class=\"token punctuation\">,<\/span>width<span class=\"token operator\">=<\/span>Cm<span class=\"token punctuation\">(<\/span><span class=\"token number\">5<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span>height<span class=\"token operator\">=<\/span>Cm<span class=\"token punctuation\">(<\/span><span class=\"token number\">5<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span>\ndoc<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_word\\test1.docx\"<\/span><span class=\"token punctuation\">)<\/span> \n<span class=\"token triple-quoted-string string\">\"\"\"\nCm\u6a21\u5757\uff0c\u7528\u4e8e\u8bbe\u5b9a\u56fe\u7247\u5c3a\u5bf8\u5927\u5c0f\n\"\"\"<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_span_idjump67span_909\"><br \/>\n   <\/a><br \/>\n   \u2464 \u6dfb\u52a0\u8868\u683c<br \/>\n   <span id=\"jump67\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> docx <span class=\"token keyword\">import<\/span> Document\n\ndoc <span class=\"token operator\">=<\/span> Document<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_word\\test1.docx\"<\/span><span class=\"token punctuation\">)<\/span>\n\nlist1 <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span>\n    <span class=\"token punctuation\">[<\/span><span class=\"token string\">\"\u59d3\u540d\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u6027\u522b\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u5bb6\u5ead\u5730\u5740\"<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token punctuation\">[<\/span><span class=\"token string\">\"\u5510\u50e7\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u7537\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u6e56\u5317\u7701\"<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token punctuation\">[<\/span><span class=\"token string\">\"\u5b59\u609f\u7a7a\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u7537\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u5317\u4eac\u5e02\"<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token punctuation\">[<\/span><span class=\"token string\">\"\u732a\u516b\u6212\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u7537\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u5e7f\u4e1c\u7701\"<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token punctuation\">[<\/span><span class=\"token string\">\"\u6c99\u548c\u5c1a\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u7537\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u6e56\u5357\u7701\"<\/span><span class=\"token punctuation\">]<\/span>\n<span class=\"token punctuation\">]<\/span>\nlist2 <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span>\n    <span class=\"token punctuation\">[<\/span><span class=\"token string\">\"\u59d3\u540d\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u6027\u522b\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u5bb6\u5ead\u5730\u5740\"<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token punctuation\">[<\/span><span class=\"token string\">\"\u8c82\u8749\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u5973\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u6cb3\u5317\u7701\"<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token punctuation\">[<\/span><span class=\"token string\">\"\u6768\u8d35\u5983\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u5973\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u8d35\u5dde\u7701\"<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token punctuation\">[<\/span><span class=\"token string\">\"\u897f\u65bd\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u5973\"<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u5c71\u4e1c\u7701\"<\/span><span class=\"token punctuation\">]<\/span>\n<span class=\"token punctuation\">]<\/span>\n\ntable1 <span class=\"token operator\">=<\/span> doc<span class=\"token punctuation\">.<\/span>add_table<span class=\"token punctuation\">(<\/span>rows<span class=\"token operator\">=<\/span><span class=\"token number\">5<\/span><span class=\"token punctuation\">,<\/span>cols<span class=\"token operator\">=<\/span><span class=\"token number\">3<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">for<\/span> row <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">range<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">5<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\n    cells <span class=\"token operator\">=<\/span> table1<span class=\"token punctuation\">.<\/span>rows<span class=\"token punctuation\">[<\/span>row<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>cells\n    <span class=\"token keyword\">for<\/span> col <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">range<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">3<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\n        cells<span class=\"token punctuation\">[<\/span>col<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>text <span class=\"token operator\">=<\/span> <span class=\"token builtin\">str<\/span><span class=\"token punctuation\">(<\/span>list1<span class=\"token punctuation\">[<\/span>row<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">[<\/span>col<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span>\ndoc<span class=\"token punctuation\">.<\/span>add_paragraph<span class=\"token punctuation\">(<\/span><span class=\"token string\">\"-----------------------------------------------------------\"<\/span><span class=\"token punctuation\">)<\/span>\ntable2 <span class=\"token operator\">=<\/span> doc<span class=\"token punctuation\">.<\/span>add_table<span class=\"token punctuation\">(<\/span>rows<span class=\"token operator\">=<\/span><span class=\"token number\">4<\/span><span class=\"token punctuation\">,<\/span>cols<span class=\"token operator\">=<\/span><span class=\"token number\">3<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">for<\/span> row <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">range<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">4<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\n    cells <span class=\"token operator\">=<\/span> table2<span class=\"token punctuation\">.<\/span>rows<span class=\"token punctuation\">[<\/span>row<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>cells\n    <span class=\"token keyword\">for<\/span> col <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">range<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">3<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\n        cells<span class=\"token punctuation\">[<\/span>col<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>text <span class=\"token operator\">=<\/span> <span class=\"token builtin\">str<\/span><span class=\"token punctuation\">(<\/span>list2<span class=\"token punctuation\">[<\/span>row<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">[<\/span>col<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span>\n        \ndoc<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_word\\test1.docx\"<\/span><span class=\"token punctuation\">)<\/span> \n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_wordexcelspan_idjump68span_948\"><br \/>\n   <\/a><br \/>\n   \u2465 \u63d0\u53d6word\u8868\u683c\uff0c\u5e76\u4fdd\u5b58\u5728excel\u4e2d(\u5f88\u91cd\u8981)<br \/>\n   <span id=\"jump68\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> docx <span class=\"token keyword\">import<\/span> Document\n<span class=\"token keyword\">from<\/span> openpyxl <span class=\"token keyword\">import<\/span> Workbook\n\ndoc <span class=\"token operator\">=<\/span> Document<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_word\\test2.docx\"<\/span><span class=\"token punctuation\">)<\/span>\nt0 <span class=\"token operator\">=<\/span> doc<span class=\"token punctuation\">.<\/span>tables<span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span>\n\nworkbook <span class=\"token operator\">=<\/span> Workbook<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\nsheet <span class=\"token operator\">=<\/span> workbook<span class=\"token punctuation\">.<\/span>active\n\n<span class=\"token keyword\">for<\/span> i <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">range<\/span><span class=\"token punctuation\">(<\/span><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>t0<span class=\"token punctuation\">.<\/span>rows<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\n    list1 <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span>\n    <span class=\"token keyword\">for<\/span> j <span class=\"token keyword\">in<\/span> <span class=\"token builtin\">range<\/span><span class=\"token punctuation\">(<\/span><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>t0<span class=\"token punctuation\">.<\/span>columns<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\n        list1<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span>t0<span class=\"token punctuation\">.<\/span>cell<span class=\"token punctuation\">(<\/span>i<span class=\"token punctuation\">,<\/span>j<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>text<span class=\"token punctuation\">)<\/span>\n    sheet<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span>list1<span class=\"token punctuation\">)<\/span>\nworkbook<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span>filename <span class=\"token operator\">=<\/span> <span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_word\\\u6765\u81eaword\u4e2d\u7684\u8868.xlsx\"<\/span><span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h5>\n   <a id=\"3PythonWordspan_idjump69span_971\"><br \/>\n   <\/a><br \/>\n   3\u3001\u5229\u7528Python\u8c03\u6574Word\u6587\u6863\u6837\u5f0f<br \/>\n   <span id=\"jump69\"><br \/>\n   <\/span><br \/>\n  <\/h5>\n<h6>\n   <a id=\"1span_idjump70span_972\"><br \/>\n   <\/a><br \/>\n   1\uff09\u4fee\u6539\u6587\u5b57\u5b57\u4f53\u6837\u5f0f<br \/>\n   <span id=\"jump70\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> docx <span class=\"token keyword\">import<\/span> Document\n<span class=\"token keyword\">from<\/span> docx<span class=\"token punctuation\">.<\/span>shared <span class=\"token keyword\">import<\/span> Pt<span class=\"token punctuation\">,<\/span>RGBColor \n<span class=\"token keyword\">from<\/span> docx<span class=\"token punctuation\">.<\/span>oxml<span class=\"token punctuation\">.<\/span>ns <span class=\"token keyword\">import<\/span> qn\n\ndoc <span class=\"token operator\">=<\/span> Document<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_word\\test2.docx\"<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">for<\/span> paragraph <span class=\"token keyword\">in<\/span> doc<span class=\"token punctuation\">.<\/span>paragraphs<span class=\"token punctuation\">:<\/span>\n    <span class=\"token keyword\">for<\/span> run <span class=\"token keyword\">in<\/span> paragraph<span class=\"token punctuation\">.<\/span>runs<span class=\"token punctuation\">:<\/span>\n        run<span class=\"token punctuation\">.<\/span>font<span class=\"token punctuation\">.<\/span>bold <span class=\"token operator\">=<\/span> <span class=\"token boolean\">True<\/span>\n        run<span class=\"token punctuation\">.<\/span>font<span class=\"token punctuation\">.<\/span>italic <span class=\"token operator\">=<\/span> <span class=\"token boolean\">True<\/span>\n        run<span class=\"token punctuation\">.<\/span>font<span class=\"token punctuation\">.<\/span>underline <span class=\"token operator\">=<\/span> <span class=\"token boolean\">True<\/span>\n        run<span class=\"token punctuation\">.<\/span>font<span class=\"token punctuation\">.<\/span>strike <span class=\"token operator\">=<\/span> <span class=\"token boolean\">True<\/span>\n        run<span class=\"token punctuation\">.<\/span>font<span class=\"token punctuation\">.<\/span>shadow <span class=\"token operator\">=<\/span> <span class=\"token boolean\">True<\/span>\n        run<span class=\"token punctuation\">.<\/span>font<span class=\"token punctuation\">.<\/span>size <span class=\"token operator\">=<\/span> Pt<span class=\"token punctuation\">(<\/span><span class=\"token number\">18<\/span><span class=\"token punctuation\">)<\/span>\n        run<span class=\"token punctuation\">.<\/span>font<span class=\"token punctuation\">.<\/span>color<span class=\"token punctuation\">.<\/span>rgb <span class=\"token operator\">=<\/span> RGBColor<span class=\"token punctuation\">(<\/span><span class=\"token number\">255<\/span><span class=\"token punctuation\">,<\/span><span class=\"token number\">255<\/span><span class=\"token punctuation\">,<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">)<\/span>\n        run<span class=\"token punctuation\">.<\/span>font<span class=\"token punctuation\">.<\/span>name <span class=\"token operator\">=<\/span> <span class=\"token string\">\"\u5b8b\u4f53\"<\/span>\n        <span class=\"token comment\"># \u8bbe\u7f6e\u50cf\u5b8b\u4f53\u8fd9\u6837\u7684\u4e2d\u6587\u5b57\u4f53\uff0c\u5fc5\u987b\u6dfb\u52a0\u4e0b\u97622\u884c\u4ee3\u7801<\/span>\n        r <span class=\"token operator\">=<\/span> run<span class=\"token punctuation\">.<\/span>_element<span class=\"token punctuation\">.<\/span>rPr<span class=\"token punctuation\">.<\/span>rFonts\n        r<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">set<\/span><span class=\"token punctuation\">(<\/span>qn<span class=\"token punctuation\">(<\/span><span class=\"token string\">\"w:eastAsia\"<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><span class=\"token string\">\"\u5b8b\u4f53\"<\/span><span class=\"token punctuation\">)<\/span>\ndoc<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_word\\_test1.docx\"<\/span><span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"2span_idjump71span_999\"><br \/>\n   <\/a><br \/>\n   2\uff09\u4fee\u6539\u6bb5\u843d\u6837\u5f0f<br \/>\n   <span id=\"jump71\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<h6>\n   <a id=\"_span_idjump72span_1000\"><br \/>\n   <\/a><br \/>\n   \u2460 \u5bf9\u9f50\u6837\u5f0f<br \/>\n   <span id=\"jump72\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> docx <span class=\"token keyword\">import<\/span> Document \n<span class=\"token keyword\">from<\/span> docx<span class=\"token punctuation\">.<\/span>enum<span class=\"token punctuation\">.<\/span>text <span class=\"token keyword\">import<\/span> WD_ALIGN_PARAGRAPH\n\ndoc <span class=\"token operator\">=<\/span> Document<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_word\\test1.docx\"<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span>doc<span class=\"token punctuation\">.<\/span>paragraphs<span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>text<span class=\"token punctuation\">)<\/span>\ndoc<span class=\"token punctuation\">.<\/span>paragraphs<span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>alignment <span class=\"token operator\">=<\/span> WD_ALIGN_PARAGRAPH<span class=\"token punctuation\">.<\/span>CENTER\n<span class=\"token comment\"># \u8fd9\u91cc\u8bbe\u7f6e\u7684\u662f\u5c45\u4e2d\u5bf9\u9f50<\/span>\ndoc<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_word\\\u5bf9\u9f50\u6837\u5f0f.docx\"<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token triple-quoted-string string\">\"\"\"\nLEFT,CENTER,RIGHT,JUSTIFY,DISTRIBUTE,JUSTIFY_MED,JUSTIFY_HI,JUSTIFY_LOW,THAI_JUSTIFY\n\"\"\"<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_span_idjump73span_1018\"><br \/>\n   <\/a><br \/>\n   \u2461 \u884c\u95f4\u8ddd\u8c03\u6574<br \/>\n   <span id=\"jump73\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<pre><code class=\"prism language-python\"><span class=\"token keyword\">from<\/span> docx <span class=\"token keyword\">import<\/span> Document \n<span class=\"token keyword\">from<\/span> docx<span class=\"token punctuation\">.<\/span>enum<span class=\"token punctuation\">.<\/span>text <span class=\"token keyword\">import<\/span> WD_ALIGN_PARAGRAPH\n\ndoc <span class=\"token operator\">=<\/span> Document<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_word\\test1.docx\"<\/span><span class=\"token punctuation\">)<\/span>\n<span class=\"token keyword\">for<\/span> paragraph <span class=\"token keyword\">in<\/span> doc<span class=\"token punctuation\">.<\/span>paragraphs<span class=\"token punctuation\">:<\/span>\n    paragraph<span class=\"token punctuation\">.<\/span>paragraph_format<span class=\"token punctuation\">.<\/span>line_spacing <span class=\"token operator\">=<\/span> <span class=\"token number\">5.0<\/span>\ndoc<span class=\"token punctuation\">.<\/span>save<span class=\"token punctuation\">(<\/span><span class=\"token string\">r\"G:\\6Tipdm\\7python\u529e\u516c\u81ea\u52a8\u5316\\concat_word\\\u884c\u95f4\u8ddd.docx\"<\/span><span class=\"token punctuation\">)<\/span>\n<\/code><\/pre>\n<p>\n   \u7ed3\u679c\u5982\u4e0b\uff1a<br \/>\n   \n  <\/p>\n<h6>\n   <a id=\"_span_idjump74span_1032\"><br \/>\n   <\/a><br \/>\n   \u2462 \u6bb5\u524d\u4e0e\u6bb5\u540e\u95f4\u8ddd<br \/>\n   <span id=\"jump74\"><br \/>\n   <\/span><br \/>\n  <\/h6>\n<ul>\n<li>\n    \u8fd9\u91cc\u63d0\u4f9b\u4ee3\u7801\uff0c\u81ea\u884c\u4e0b\u53bb\u68c0\u9a8c\n   <\/li>\n<\/ul>\n<\/p><\/div>\n<link href=\"https:\/\/csdnimg.cn\/release\/blogv2\/dist\/mdeditor\/css\/editerView\/markdown_views-a5d25dd831.css\" rel=\"stylesheet\"\/>\n <link href=\"https:\/\/csdnimg.cn\/release\/blogv2\/dist\/mdeditor\/css\/style-e504d6a974.css\" rel=\"stylesheet\"\/>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u672c\u6587\u662f\u9274\u4e8e\u6709\u4e9b\u7c89\u4e1d\u7684\u5de5\u4f5c\u9700\u6c42\uff0c\u6709\u65f6\u5019\u9700\u8981\u9047\u5230\u8fd9\u4e9b\u6587\u4ef6\u7684\u5904\u7406\u3002\u56e0\u6b64\uff0c\u6211\u5199\u4e86\u4e00\u4e2a\u6587\u7ae0\u96c6\u5408\uff0c\u4f9b\u5927\u5bb6\u53c2\u8003\uff0c\u6574\u7bc7\u6587\u7ae0\u5df2\u7ecf [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":215,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-340","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-18"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>python\u81ea\u52a8\u5316\u529e\u516c\u2014\u2014python\u64cd\u4f5cExcel\u3001Word\u3001PDF\u96c6\u5408\u5927\u5168 - \u7269\u5ae9\u8f6f\u4ef6\u8d44\u8baf\u7f51<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python\u81ea\u52a8\u5316\u529e\u516c-python\u64cd\u4f5cexcel\u3001word\u3001pdf\u96c6\u5408\u5927\u5168\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"python\u81ea\u52a8\u5316\u529e\u516c\u2014\u2014python\u64cd\u4f5cExcel\u3001Word\u3001PDF\u96c6\u5408\u5927\u5168 - \u7269\u5ae9\u8f6f\u4ef6\u8d44\u8baf\u7f51\" \/>\n<meta property=\"og:description\" content=\"\u672c\u6587\u662f\u9274\u4e8e\u6709\u4e9b\u7c89\u4e1d\u7684\u5de5\u4f5c\u9700\u6c42\uff0c\u6709\u65f6\u5019\u9700\u8981\u9047\u5230\u8fd9\u4e9b\u6587\u4ef6\u7684\u5904\u7406\u3002\u56e0\u6b64\uff0c\u6211\u5199\u4e86\u4e00\u4e2a\u6587\u7ae0\u96c6\u5408\uff0c\u4f9b\u5927\u5bb6\u53c2\u8003\uff0c\u6574\u7bc7\u6587\u7ae0\u5df2\u7ecf [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python\u81ea\u52a8\u5316\u529e\u516c-python\u64cd\u4f5cexcel\u3001word\u3001pdf\u96c6\u5408\u5927\u5168\/\" \/>\n<meta property=\"og:site_name\" content=\"\u7269\u5ae9\u8f6f\u4ef6\u8d44\u8baf\u7f51\" \/>\n<meta property=\"article:published_time\" content=\"2025-03-31T10:00:18+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.wunen.com\/wp-content\/uploads\/2025\/03\/\u8d44\u8baf.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"260\" \/>\n\t<meta property=\"og:image:height\" content=\"180\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin@wunen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin@wunen\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/#article\",\"isPartOf\":{\"@id\":\"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/\"},\"author\":{\"name\":\"admin@wunen\",\"@id\":\"https:\/\/www.wunen.com\/#\/schema\/person\/d5f7a6cf545656a9c90d507e64452db8\"},\"headline\":\"python\u81ea\u52a8\u5316\u529e\u516c\u2014\u2014python\u64cd\u4f5cExcel\u3001Word\u3001PDF\u96c6\u5408\u5927\u5168\",\"datePublished\":\"2025-03-31T10:00:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/\"},\"wordCount\":386,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.wunen.com\/#organization\"},\"image\":{\"@id\":\"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.wunen.com\/wp-content\/uploads\/2025\/03\/\u8d44\u8baf.jpg\",\"articleSection\":[\"\u5b66\u4e60\u529e\u516c\"],\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/\",\"url\":\"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/\",\"name\":\"python\u81ea\u52a8\u5316\u529e\u516c\u2014\u2014python\u64cd\u4f5cExcel\u3001Word\u3001PDF\u96c6\u5408\u5927\u5168 - \u7269\u5ae9\u8f6f\u4ef6\u8d44\u8baf\u7f51\",\"isPartOf\":{\"@id\":\"https:\/\/www.wunen.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/#primaryimage\"},\"image\":{\"@id\":\"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.wunen.com\/wp-content\/uploads\/2025\/03\/\u8d44\u8baf.jpg\",\"datePublished\":\"2025-03-31T10:00:18+00:00\",\"breadcrumb\":{\"@id\":\"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/#primaryimage\",\"url\":\"http:\/\/www.wunen.com\/wp-content\/uploads\/2025\/03\/\u8d44\u8baf.jpg\",\"contentUrl\":\"http:\/\/www.wunen.com\/wp-content\/uploads\/2025\/03\/\u8d44\u8baf.jpg\",\"width\":260,\"height\":180},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wunen.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"python\u81ea\u52a8\u5316\u529e\u516c\u2014\u2014python\u64cd\u4f5cExcel\u3001Word\u3001PDF\u96c6\u5408\u5927\u5168\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wunen.com\/#website\",\"url\":\"https:\/\/www.wunen.com\/\",\"name\":\"\u7269\u5ae9\u8f6f\u4ef6\u8d44\u8baf\u7f51\",\"description\":\"\u8f6f\u4ef6\u8d44\u8baf\u6765\u7269\u5ae9\",\"publisher\":{\"@id\":\"https:\/\/www.wunen.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wunen.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.wunen.com\/#organization\",\"name\":\"\u7269\u5ae9\u8f6f\u4ef6\u8d44\u8baf\u7f51\",\"url\":\"https:\/\/www.wunen.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wunen.com\/#\/schema\/logo\/image\/\",\"url\":\"http:\/\/www.wunen.com\/wp-content\/uploads\/2025\/03\/cropped-\u7269\u5ae9-1.png\",\"contentUrl\":\"http:\/\/www.wunen.com\/wp-content\/uploads\/2025\/03\/cropped-\u7269\u5ae9-1.png\",\"width\":1024,\"height\":1024,\"caption\":\"\u7269\u5ae9\u8f6f\u4ef6\u8d44\u8baf\u7f51\"},\"image\":{\"@id\":\"https:\/\/www.wunen.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wunen.com\/#\/schema\/person\/d5f7a6cf545656a9c90d507e64452db8\",\"name\":\"admin@wunen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wunen.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d90ec1e3faf77c4d4e66e40c29b85ff6401161e0502f401dae2f0e25b38ce25e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d90ec1e3faf77c4d4e66e40c29b85ff6401161e0502f401dae2f0e25b38ce25e?s=96&d=mm&r=g\",\"caption\":\"admin@wunen\"},\"sameAs\":[\"http:\/\/www.wunen.com\"],\"url\":\"http:\/\/www.wunen.com\/index.php\/author\/adminwunen\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"python\u81ea\u52a8\u5316\u529e\u516c\u2014\u2014python\u64cd\u4f5cExcel\u3001Word\u3001PDF\u96c6\u5408\u5927\u5168 - \u7269\u5ae9\u8f6f\u4ef6\u8d44\u8baf\u7f51","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python\u81ea\u52a8\u5316\u529e\u516c-python\u64cd\u4f5cexcel\u3001word\u3001pdf\u96c6\u5408\u5927\u5168\/","og_locale":"zh_CN","og_type":"article","og_title":"python\u81ea\u52a8\u5316\u529e\u516c\u2014\u2014python\u64cd\u4f5cExcel\u3001Word\u3001PDF\u96c6\u5408\u5927\u5168 - \u7269\u5ae9\u8f6f\u4ef6\u8d44\u8baf\u7f51","og_description":"\u672c\u6587\u662f\u9274\u4e8e\u6709\u4e9b\u7c89\u4e1d\u7684\u5de5\u4f5c\u9700\u6c42\uff0c\u6709\u65f6\u5019\u9700\u8981\u9047\u5230\u8fd9\u4e9b\u6587\u4ef6\u7684\u5904\u7406\u3002\u56e0\u6b64\uff0c\u6211\u5199\u4e86\u4e00\u4e2a\u6587\u7ae0\u96c6\u5408\uff0c\u4f9b\u5927\u5bb6\u53c2\u8003\uff0c\u6574\u7bc7\u6587\u7ae0\u5df2\u7ecf [&hellip;]","og_url":"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python\u81ea\u52a8\u5316\u529e\u516c-python\u64cd\u4f5cexcel\u3001word\u3001pdf\u96c6\u5408\u5927\u5168\/","og_site_name":"\u7269\u5ae9\u8f6f\u4ef6\u8d44\u8baf\u7f51","article_published_time":"2025-03-31T10:00:18+00:00","og_image":[{"width":260,"height":180,"url":"http:\/\/www.wunen.com\/wp-content\/uploads\/2025\/03\/\u8d44\u8baf.jpg","type":"image\/jpeg"}],"author":"admin@wunen","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin@wunen","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"11 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/#article","isPartOf":{"@id":"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/"},"author":{"name":"admin@wunen","@id":"https:\/\/www.wunen.com\/#\/schema\/person\/d5f7a6cf545656a9c90d507e64452db8"},"headline":"python\u81ea\u52a8\u5316\u529e\u516c\u2014\u2014python\u64cd\u4f5cExcel\u3001Word\u3001PDF\u96c6\u5408\u5927\u5168","datePublished":"2025-03-31T10:00:18+00:00","mainEntityOfPage":{"@id":"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/"},"wordCount":386,"commentCount":0,"publisher":{"@id":"https:\/\/www.wunen.com\/#organization"},"image":{"@id":"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/#primaryimage"},"thumbnailUrl":"http:\/\/www.wunen.com\/wp-content\/uploads\/2025\/03\/\u8d44\u8baf.jpg","articleSection":["\u5b66\u4e60\u529e\u516c"],"inLanguage":"zh-Hans","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/","url":"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/","name":"python\u81ea\u52a8\u5316\u529e\u516c\u2014\u2014python\u64cd\u4f5cExcel\u3001Word\u3001PDF\u96c6\u5408\u5927\u5168 - \u7269\u5ae9\u8f6f\u4ef6\u8d44\u8baf\u7f51","isPartOf":{"@id":"https:\/\/www.wunen.com\/#website"},"primaryImageOfPage":{"@id":"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/#primaryimage"},"image":{"@id":"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/#primaryimage"},"thumbnailUrl":"http:\/\/www.wunen.com\/wp-content\/uploads\/2025\/03\/\u8d44\u8baf.jpg","datePublished":"2025-03-31T10:00:18+00:00","breadcrumb":{"@id":"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/"]}]},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/#primaryimage","url":"http:\/\/www.wunen.com\/wp-content\/uploads\/2025\/03\/\u8d44\u8baf.jpg","contentUrl":"http:\/\/www.wunen.com\/wp-content\/uploads\/2025\/03\/\u8d44\u8baf.jpg","width":260,"height":180},{"@type":"BreadcrumbList","@id":"http:\/\/www.wunen.com\/index.php\/2025\/03\/31\/python%e8%87%aa%e5%8a%a8%e5%8c%96%e5%8a%9e%e5%85%ac-python%e6%93%8d%e4%bd%9cexcel%e3%80%81word%e3%80%81pdf%e9%9b%86%e5%90%88%e5%a4%a7%e5%85%a8\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wunen.com\/"},{"@type":"ListItem","position":2,"name":"python\u81ea\u52a8\u5316\u529e\u516c\u2014\u2014python\u64cd\u4f5cExcel\u3001Word\u3001PDF\u96c6\u5408\u5927\u5168"}]},{"@type":"WebSite","@id":"https:\/\/www.wunen.com\/#website","url":"https:\/\/www.wunen.com\/","name":"\u7269\u5ae9\u8f6f\u4ef6\u8d44\u8baf\u7f51","description":"\u8f6f\u4ef6\u8d44\u8baf\u6765\u7269\u5ae9","publisher":{"@id":"https:\/\/www.wunen.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wunen.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-Hans"},{"@type":"Organization","@id":"https:\/\/www.wunen.com\/#organization","name":"\u7269\u5ae9\u8f6f\u4ef6\u8d44\u8baf\u7f51","url":"https:\/\/www.wunen.com\/","logo":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wunen.com\/#\/schema\/logo\/image\/","url":"http:\/\/www.wunen.com\/wp-content\/uploads\/2025\/03\/cropped-\u7269\u5ae9-1.png","contentUrl":"http:\/\/www.wunen.com\/wp-content\/uploads\/2025\/03\/cropped-\u7269\u5ae9-1.png","width":1024,"height":1024,"caption":"\u7269\u5ae9\u8f6f\u4ef6\u8d44\u8baf\u7f51"},"image":{"@id":"https:\/\/www.wunen.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.wunen.com\/#\/schema\/person\/d5f7a6cf545656a9c90d507e64452db8","name":"admin@wunen","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wunen.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d90ec1e3faf77c4d4e66e40c29b85ff6401161e0502f401dae2f0e25b38ce25e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d90ec1e3faf77c4d4e66e40c29b85ff6401161e0502f401dae2f0e25b38ce25e?s=96&d=mm&r=g","caption":"admin@wunen"},"sameAs":["http:\/\/www.wunen.com"],"url":"http:\/\/www.wunen.com\/index.php\/author\/adminwunen\/"}]}},"_links":{"self":[{"href":"http:\/\/www.wunen.com\/index.php\/wp-json\/wp\/v2\/posts\/340","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.wunen.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.wunen.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.wunen.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.wunen.com\/index.php\/wp-json\/wp\/v2\/comments?post=340"}],"version-history":[{"count":0,"href":"http:\/\/www.wunen.com\/index.php\/wp-json\/wp\/v2\/posts\/340\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.wunen.com\/index.php\/wp-json\/wp\/v2\/media\/215"}],"wp:attachment":[{"href":"http:\/\/www.wunen.com\/index.php\/wp-json\/wp\/v2\/media?parent=340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.wunen.com\/index.php\/wp-json\/wp\/v2\/categories?post=340"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.wunen.com\/index.php\/wp-json\/wp\/v2\/tags?post=340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}