´Ä¶
- Windows 10
- Python 3.7
- pypiwin32 ¥Ð¡¼¥¸¥ç¥ó223
¥¨¥é¡¼¾õ¶·
Python¤«¤éExcel¤Î¥Þ¥¯¥í¤ò¼Â¹Ô¡ÊCOM¼Â¹Ô¡Ë¤·¤¿¤¯¤Æ¡Öpypiwin32¡×¤òpip¤Ç¥¤¥ó¥¹¥È¡¼¥ë¤·¤¿¡£
¡Öpip install pypiwin32¡×¤ÇľÀÜ¥·¥¹¥Æ¥à¾å¤Ë¥¤¥ó¥¹¥È¡¼¥ë¤·¤¿¾ì¹ç¤ÏÌäÂê¤Ê¤¯»ÈÍѤǤ¤¿¤¬¡¢ÇÛÉۥѥ屡¼¥¸¤È¤·¤Æ¤Þ¤È¤á¤¿¤«¤Ã¤¿¤Î¤Ç¡Öpip install pypiwin32 -t ./Lib/site-packages¡×¤È¤·¤Æ¥×¥í¥¸¥§¥¯¥È¥Õ¥©¥ë¥ÀÆâ¤ËľÀÜ¥¤¥ó¥¹¥È¡¼¥ë¤·¡¢Python¥¹¥¯¥ê¥×¥ÈÆâ¤Ç
import os import sys script_path = os.path.dirname(__file__) sys.path.append(os.path.join(script_path, "Lib/site-packages")) import win32com.client
¤È¤·¤Æ¥×¥í¥¸¥§¥¯¥È¥Õ¥©¥ë¥ÀÆâ¤Îpypiwin32¤ò»ÈÍѤ·¤¿¤È¤³¤í¥¤¥ó¥Ý¡¼¥È¥¨¥é¡¼¤È¤Ê¤Ã¤¿¡£¥¨¥é¡¼¥á¥Ã¥»¡¼¥¸¤Ï¼¡¤ÎÄ̤ꡣ
File "Lib/site-packages\win32com\__init__.py", line 5, inimport win32api, sys, os ModuleNotFoundError: No module named 'win32api'
¤Þ¤¿½¤ÀµÂбþÃæ¤Ë°Ê²¼¤ÎÍͤʥ¨¥é¡¼¥á¥Ã¥»¡¼¥¸¤â¸«¤é¤ì¤é¤¿¡£
File "Lib/site-packages\win32com\__init__.py", line 5, inimport win32api, sys, os ImportError: DLL load failed: »ØÄꤵ¤ì¤¿¥â¥¸¥å¡¼¥ë¤¬¸«¤Ä¤«¤ê¤Þ¤»¤ó¡£
File "Lib/site-packages\win32com\__init__.py", line 6, inimport pythoncom File "Lib/site-packages\pythoncom.py", line 2, in import pywintypes ModuleNotFoundError: No module named 'pywintypes'
ÂбþÊýË¡
Python¥¹¥¯¥ê¥×¥È¤ò°Ê²¼¤Î¤è¤¦¤ËÊѹ¹¤¹¤ë¤È¥¤¥ó¥Ý¡¼¥È¥¨¥é¡¼¤ò²ò¾Ã¤Ç¤¤¿¡£
import os import sys script_path = os.path.dirname(__file__) sys.path.append(os.path.join(script_path, "Lib/site-packages")) sys.path.append(os.path.join(script_path, "Lib/site-packages/win32")) sys.path.append(os.path.join(script_path, "Lib/site-packages/win32/lib")) os.environ["PATH"] = os.environ["PATH"] + ";" + os.path.join(script_path , "Lib/site-packages/pywin32_system32") import win32com.client
win32, win32/lib¥Õ¥©¥ë¥À¤òPython¤Î¥â¥¸¥å¡¼¥ë»²¾È°ÌÃÖ¤ËÄɲä·¡¢¤µ¤é¤Ë´Ä¶ÊÑ¿ôPATH¤Ëpywin32_system32¥Õ¥©¥ë¥À¤òÄɲ乤뤳¤È¤Çwin32api¤ò¥¤¥ó¥Ý¡¼¥È¤Ç¤¤ë¤è¤¦¤Ë¤Ê¤Ã¤¿¡£