{"id":709,"date":"2025-05-01T19:00:00","date_gmt":"2025-05-01T11:00:00","guid":{"rendered":"https:\/\/jonasme.ddns.net\/?p=709"},"modified":"2025-05-14T15:23:10","modified_gmt":"2025-05-14T07:23:10","slug":"python-x-pandas-x-openpyxl-x-win32com%ef%bc%9a%e4%b8%80%e9%8d%b5%e5%8c%96%e5%b7%a8%e9%87%8f-excel-%e8%b3%87%e6%96%99%e8%87%aa%e5%8b%95%e7%af%a9%e9%81%b8%e8%88%87%e5%8a%a0%e5%af%86","status":"publish","type":"post","link":"https:\/\/jonasvip.ddns.net\/?p=709","title":{"rendered":"Python \u00d7 pandas \u00d7 openpyxl \u00d7 win32com\uff1a\u4e00\u9375\u5316\u5de8\u91cf Excel \u8cc7\u6599\u81ea\u52d5\u7be9\u9078\u8207\u52a0\u5bc6\u5c08\u696d\u5be6\u6230\u5168\u653b\u7565"},"content":{"rendered":"\n<p>\u7d50\u5408 Python \u7684 pandas\u3001openpyxl \u53ca win32com \u4e09\u5927\u6a21\u7d44\uff0c\u63d0\u4f9b\u4e00\u9375\u5316\u6d41\u7a0b\uff0c\u53ef\u81ea\u52d5\u7be9\u9078 Excel \u5de8\u91cf\u8cc7\u6599\u3001\u532f\u51fa\u6307\u5b9a\u7d50\u679c\uff0c\u4e26\u5728\u532f\u51fa\u6642\u5957\u7528\u5bc6\u78bc\u4fdd\u8b77\uff0c\u5168\u65b9\u4f4d\u517c\u9867\u6548\u7387\u8207\u5b89\u5168\u6027\u3002<br>\u63a1\u7528 pandas \u512a\u5316\u8b80\u5beb\u6d41\u7a0b\uff0c\u6709\u6548\u8655\u7406\u767e\u842c\u7b46\u4ee5\u4e0a\u8cc7\u6599\u884c\u5217\u3002<br>openpyxl \u7121\u7e2b\u751f\u6210\u8207\u64cd\u4f5c .xlsx \u5de5\u4f5c\u7c3f\uff0c\u4e26\u80fd\u8a2d\u5b9a\u6a94\u6848\u4fdd\u8b77\u5c64\u7d1a\uff1b\u7d50\u5408 win32com \u900f\u904e COM \u4ecb\u9762\u4e00\u9375\u52a0\u5bc6\uff0c\u5be6\u73fe\u771f\u6b63\u7684\u6587\u4ef6\u5b89\u5168\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p><strong>\u74b0\u5883\u9700\u6c42<\/strong><\/p>\n\n\n\n<p>1.Windows 11<br>2.Python 3.12.7 64-bit<br>3.Qt 5.15.2<br>4.PyQt5 5.15.10<br>5.Spyder IDE 5.5.1<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"has-medium-font-size\"><strong>\u529f\u80fd<\/strong><\/p>\n\n\n\n<p>1.\u81ea\u52d5\u5316\u8cc7\u6599\u7be9\u9078\uff1a\u5229\u7528 pandas \u9ad8\u6548 DataFrame \u64cd\u4f5c\uff0c\u4f9d\u689d\u4ef6\u5feb\u901f\u904e\u6ffe\u6578\u5341\u842c\u81f3\u767e\u842c\u7b46\u8cc7\u6599\uff0c\u4e26\u4e00\u6b21\u6027\u532f\u51fa\u81f3\u65b0\u6a94\u6848\u3002<br>2.\u4e00\u9375\u5f0f\u5bc6\u78bc\u4fdd\u8b77\uff1aopenpyxl \u63d0\u4f9b\u57fa\u790e\u5de5\u4f5c\u7c3f\u4fdd\u8b77\u8a2d\u5b9a\uff0c\u53ef\u900f\u904e wb.security.workbookPassword \u4e00\u884c\u7a0b\u5f0f\u78bc\u9396\u5b9a\u7d50\u69cb\u8207\u4fee\u8a02\u6b77\u7a0b\u3002\u9032\u968e\u6642\u7d50\u5408 win32com \u8abf\u7528 Excel COM \u4ecb\u9762\uff0c\u5b8c\u6210\u6a94\u6848\u7d1a\u52a0\u5bc6\uff0c\u78ba\u4fdd\u4ed6\u4eba\u7121\u6cd5\u958b\u555f\u6216\u4fee\u6539\u3002<br>3.\u8655\u7406\u5de8\u91cf\u8cc7\u6599\uff1a\u900f\u904e pd.read_excel(usecols=\u2026, dtype=\u2026) \u7b49\u53c3\u6578\u6700\u4f73\u5316\u8b80\u53d6\uff0c\u986f\u8457\u964d\u4f4e\u8a18\u61b6\u9ad4\u8207\u6642\u9593\u6210\u672c\u3002\u5fc5\u8981\u6642\u53ef\u7d50\u5408 Dask \u6216\u5176\u4ed6\u5206\u6563\u5f0f\u6846\u67b6\uff0c\u5ef6\u5c55\u81f3\u5104\u7d1a\u8cc7\u6599\u8655\u7406\uff0c\u4fdd\u6301\u9ad8\u6548\u7a69\u5b9a\u3002<br>4.\u7121\u7e2b\u6a21\u7d44\u6574\u5408\uff1apandas\u4f5c\u70ba\u8cc7\u6599\u8655\u7406\u6838\u5fc3\uff0copenpyxl\u8ca0\u8cac\u7d14Python\u7684\u6a94\u6848\u751f\u6210\u8207\u4fee\u6539\uff0cwin32com \u5247\u7121\u7e2b\u5b8c\u6210\u52a0\u5bc6\u6d41\u7a0b\uff0c\u5f9e\u95b1\u8b80\u5230\u4fdd\u8b77\u4e00\u6c23\u5475\u6210\uff0c\u4e26\u7c21\u5316\u90e8\u7f72\u6b65\u9a5f\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"has-medium-font-size\"><strong>\u57f7\u884c\u6b65\u9a5f\uff1a<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>\u4e0b\u8f09\u5b89\u88dd\u6240\u9700\u5957\u4ef6<\/strong><\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>pip install pandas\npip install openpyxl\npip install pywin32\n<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-amber-color\">\u5982\u679c\u60a8\u4f7f\u7528\u7684\u662fPython3.4\u6216\u66f4\u9ad8\u7248\u672c\uff0cpywin32\u5957\u4ef6\u5305\u542b\u4e86win32com.client\u6a21\u7d44\u3002<\/mark><\/code><\/pre>\n\n\n\n<ul>\n<li><strong>\u9a57\u8b49\u5b89\u88dd<\/strong><\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>import pandas as pd\nimport openpyxl\nimport win32com.client\nprint(\"\u6a21\u7d44\u8f09\u5165\u6210\u529f\")\n<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-amber-color\">\u5728Spyder\u7684IPython Console\u9a57\u8b49<\/mark><\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"392\" height=\"137\" src=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-113131.png\" alt=\"\" class=\"wp-image-714\" srcset=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-113131.png 392w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-113131-300x105.png 300w\" sizes=\"(max-width: 392px) 100vw, 392px\" \/><\/figure>\n\n\n\n<ul>\n<li><strong>\u7a0b\u5f0f\u78bc<\/strong><\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-47f22e69-70c8-4bc5-9887-ba73a2dfb543\" href=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/202503\u6708-A\u8a08\u756b\u7570\u5e38\u767b\u5165\u8868-1.xlsx\">202503\u6708-A\u8a08\u756b\u7570\u5e38\u767b\u5165\u8868-1<\/a><a href=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/202503\u6708-A\u8a08\u756b\u7570\u5e38\u767b\u5165\u8868-1.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-47f22e69-70c8-4bc5-9887-ba73a2dfb543\">\u7bc4\u4f8b\u8cc7\u6599<\/a><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code># -*- coding: utf-8 -*-\n\"\"\"\nCreated on Thu May  1 15:34:39 2025\n\n@author: JONAS\n\"\"\"\nimport pandas as pd\nfrom openpyxl import Workbook\nfrom openpyxl.utils.dataframe import dataframe_to_rows\nimport win32com.client as win32\nimport os\nimport time\n\n# \u5b9a\u7fa9\u6a94\u6848\u540d\u7a31\ninput_file = 'C:\\\\Users\\\\au1983\\\\Downloads\\\\202503\u6708-A\u8a08\u756b\u7570\u5e38\u767b\u5165\u8868.xlsx'\n\n# \u5b9a\u7fa9\u7be9\u9078\u689d\u4ef6\nfilter_conditions = &#91;\n    {'column1': '\u7522\u696dABC\u7cfb\u7d71', 'column2': 'A\u55ae\u4f4d', 'output_file': '\u7522\u696dABC\u7cfb\u7d71_A\u55ae\u4f4d_filtered.xlsx'},\n    {'column1': '\u7522\u696dABC\u7cfb\u7d71', 'column2': 'B\u55ae\u4f4d', 'output_file': '\u7522\u696dABC\u7cfb\u7d71_B\u55ae\u4f4d_filtered.xlsx'},\n    {'column1': '\u7522\u696dABC\u7cfb\u7d71', 'column2': 'C\u55ae\u4f4d', 'output_file': '\u7522\u696dABC\u7cfb\u7d71_C\u55ae\u4f4d_filtered.xlsx'},\n    {'column1': '\u7522\u696dABC\u7cfb\u7d71', 'column2': 'D\u55ae\u4f4d', 'output_file': '\u7522\u696dABC\u7cfb\u7d71_D\u55ae\u4f4d_filtered.xlsx'},\n    {'column1': '\u7522\u696dABC\u7cfb\u7d71', 'column2': 'E\u55ae\u4f4d', 'output_file': '\u7522\u696dABC\u7cfb\u7d71_E\u55ae\u4f4d_filtered.xlsx'},\n    {'column1': '\u7522\u696dABC\u7cfb\u7d71', 'column2': 'F\u55ae\u4f4d', 'output_file': '\u7522\u696dABC\u7cfb\u7d71_F\u55ae\u4f4d_filtered.xlsx'}]\n\n# \u8b80\u53d6Excel\u6a94\u6848\ndf = pd.read_excel(input_file)\n\n# \u8ff4\u5708\u8655\u7406\u6bcf\u7d44\u7be9\u9078\u689d\u4ef6\nfor condition in filter_conditions:\n    column1_value = condition&#91;'column1']\n    column2_value = condition&#91;'column2']\n    output_file = condition&#91;'output_file']\n    \n    # \u7be9\u9078\u540c\u6642\u7b26\u5408\u5169\u500b\u6b04\u4f4d\u689d\u4ef6\u7684\u8cc7\u6599\n    filtered_df = df&#91;(df&#91;'\u7cfb\u7d71\u5225'] == column1_value) &amp; (df&#91;'\u5206\u7f72\u5225'] == column2_value)]\n    \n    # \u5982\u679c\u6709\u7be9\u9078\u5230\u8cc7\u6599\uff0c\u5247\u751f\u6210Excel\u6a94\u6848\n    if not filtered_df.empty:\n        # \u5c07\u7be9\u9078\u5f8c\u7684\u8cc7\u6599\u5beb\u5165\u65b0\u7684Excel\u6a94\u6848\n        wb = Workbook()\n        ws = wb.active\n        for r in dataframe_to_rows(filtered_df, index=False, header=True):\n            ws.append(r)\n\n        # \u5132\u5b58\u6a94\u6848\n        wb.save(output_file)\n\n        # \u78ba\u4fdd\u6587\u4ef6\u5df2\u7d93\u88ab\u5beb\u5165\u78c1\u789f\n        time.sleep(1)\n\n        # \u4f7f\u7528win32com\u5c0dExcel\u6587\u4ef6\u9032\u884c\u52a0\u5bc6\n        excel = win32.Dispatch('Excel.Application')\n        full_path = os.path.abspath(output_file)\n        wb = excel.Workbooks.Open(full_path)\n        wb.Password = 'RS6W@##+$xM8qb?a'\n        wb.SaveAs(full_path, Password='RS6W@##+$xM8qb?a')\n        wb.Close()\n        excel.Quit()\n\n        print(f'Processed and saved: {output_file}')\n    else:\n        print(f'No data found for condition: {column1_value} and {column2_value}')<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>\u6210\u679c\u622a\u5716\uff1a<\/strong><\/p>\n\n\n\n<p>\u756b\u976201-\u532f\u5165\u7bc4\u4f8b\u8cc7\u6599<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"330\" data-src=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-145228-1024x330.png\" alt=\"\" class=\"wp-image-718 lazyload\" data-srcset=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-145228-1024x330.png 1024w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-145228-300x97.png 300w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-145228-768x248.png 768w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-145228-1536x496.png 1536w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-145228.png 1906w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/330;\" \/><\/figure>\n\n\n\n<p>\u756b\u976202-Spyder\u57f7\u884c\u6210\u529f\u756b\u9762<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"476\" data-src=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-153827-1-1024x476.png\" alt=\"\" class=\"wp-image-719 lazyload\" data-srcset=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-153827-1-1024x476.png 1024w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-153827-1-300x140.png 300w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-153827-1-768x357.png 768w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-153827-1-1536x714.png 1536w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-153827-1.png 1907w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/476;\" \/><\/figure>\n\n\n\n<p>\u756b\u976203-Python\u57f7\u884c\u5f8c\u4f9d\u7167\u7be9\u9078\u985e\u5225\u7522\u51fa5\u500b\u55ae\u4f4d\u6a94\u6848<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"723\" data-src=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-154004-1024x723.png\" alt=\"\" class=\"wp-image-720 lazyload\" data-srcset=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-154004-1024x723.png 1024w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-154004-300x212.png 300w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-154004-768x542.png 768w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-154004.png 1035w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/723;\" \/><\/figure>\n\n\n\n<p>\u756b\u976204-Excel\u6a94\u6848\u52a0\u5bc6\uff08\u4ee5A\u55ae\u4f4d\u7be9\u9078\u6a94\u6848\u70ba\u7bc4\u4f8b\uff09<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"397\" height=\"191\" data-src=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-154108.png\" alt=\"\" class=\"wp-image-721 lazyload\" data-srcset=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-154108.png 397w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-154108-300x144.png 300w\" data-sizes=\"(max-width: 397px) 100vw, 397px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 397px; --smush-placeholder-aspect-ratio: 397\/191;\" \/><\/figure>\n\n\n\n<p>\u756b\u976205-A\u55ae\u4f4dExcel\u7be9\u9078\u7d50\u679c\u756b\u9762\uff08\u4ee5A\u55ae\u4f4d\u7be9\u9078\u6a94\u6848\u70ba\u7bc4\u4f8b\uff09<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"469\" data-src=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-154141-1024x469.png\" alt=\"\" class=\"wp-image-722 lazyload\" data-srcset=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-154141-1024x469.png 1024w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-154141-300x137.png 300w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-154141-768x352.png 768w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2025\/05\/\u87a2\u5e55\u64f7\u53d6\u756b\u9762-2025-05-01-154141.png 1277w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/469;\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u7d50\u5408 Python \u7684 pandas\u3001openpyxl \u53ca win32com \u4e09\u5927\u6a21\u7d44\uff0c\u63d0\u4f9b\u4e00\u9375\u5316\u6d41\u7a0b\uff0c\u53ef\u81ea\u52d5\u7be9\u9078 Excel \u5de8\u91cf\u8cc7\u6599\u3001\u532f\u51fa\u6307\u5b9a\u7d50\u679c\uff0c\u4e26\u5728\u532f\u51fa\u6642\u5957\u7528\u5bc6\u78bc\u4fdd\u8b77\uff0c\u5168\u65b9\u4f4d\u517c\u9867\u6548\u7387\u8207\u5b89\u5168\u6027\u3002<br \/>\n\u63a1\u7528 pandas \u512a\u5316\u8b80\u5beb\u6d41\u7a0b\uff0c\u6709\u6548\u8655\u7406\u767e\u842c\u7b46\u4ee5\u4e0a\u8cc7\u6599\u884c\u5217\u3002<br \/>\nopenpyxl \u7121\u7e2b\u751f\u6210\u8207\u64cd\u4f5c .xlsx \u5de5\u4f5c\u7c3f\uff0c\u4e26\u80fd\u8a2d\u5b9a\u6a94\u6848\u4fdd\u8b77\u5c64\u7d1a\uff1b\u7d50\u5408 win32com \u900f\u904e COM \u4ecb\u9762\u4e00\u9375\u52a0\u5bc6\uff0c\u5be6\u73fe\u771f\u6b63\u7684\u6587\u4ef6\u5b89\u5168\u3002<\/p>\n","protected":false},"author":3,"featured_media":719,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[24,11],"_links":{"self":[{"href":"https:\/\/jonasvip.ddns.net\/index.php?rest_route=\/wp\/v2\/posts\/709"}],"collection":[{"href":"https:\/\/jonasvip.ddns.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jonasvip.ddns.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jonasvip.ddns.net\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/jonasvip.ddns.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=709"}],"version-history":[{"count":8,"href":"https:\/\/jonasvip.ddns.net\/index.php?rest_route=\/wp\/v2\/posts\/709\/revisions"}],"predecessor-version":[{"id":729,"href":"https:\/\/jonasvip.ddns.net\/index.php?rest_route=\/wp\/v2\/posts\/709\/revisions\/729"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jonasvip.ddns.net\/index.php?rest_route=\/wp\/v2\/media\/719"}],"wp:attachment":[{"href":"https:\/\/jonasvip.ddns.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=709"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jonasvip.ddns.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=709"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jonasvip.ddns.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=709"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}