python-win32com excel com model started generating errors

by

I had the same issue and I resolved it by following the instructions here: https://mail.python.org/pipermail/python-win32/2007-August/006147.html

Deleting the gen_py output directory and re-running makepy SUCCEEDS
and subsequently the test application runs OK again.

So the symptom is resolved, but any clues as to how this could have
happened. This is a VERY long running application (think 24×7 for
years) and I’m concerned that whatever caused this might occur again.

To find the output directory, run this in your python console / python session:

import win32com
print(win32com.__gen_path__)

or, even better, a one-liner in the command line:

python -c "import win32com; print(win32com.__gen_path__)"

Based on the exception message in your post, the directory you need to remove will be titled ‘00020813-0000-0000-C000-000000000046x0x1x9’. So delete this directory and re-run the code. And if you’re nervous about deleting it (like I was) just cut the directory and paste it somewhere else.

💡Note that this directory is usually in your “TEMP” directory (copy-paste %TEMP%/gen_py in Windows File Explorer and you will arrive there directly).

I have no idea why this happens nor do I know how to prevent it from happening again, but the directions in the link I provided seemed to work for me.

More Related Contents:

  1. ImportError: No module named win32com.client
  2. .xlsx and xls(Latest Versions) to pdf using python
  3. Export Charts from Excel as images using Python
  4. Append existing excel sheet with new dataframe using python pandas
  5. Using Pandas to pd.read_excel() for multiple worksheets of the same workbook
  6. How to call python script on excel vba?
  7. .doc to pdf using python
  8. Driving Excel from Python in Windows
  9. check if a file is open in Python
  10. Import multiple excel files into python pandas and concatenate them into one dataframe
  11. How do I read a date in Excel format in Python?
  12. Pandas: Looking up the list of sheets in an excel file
  13. python xlrd unsupported format, or corrupt file.
  14. Reading Excel File using Python, how do I get the values of a specific column with indicated column name?
  15. append dataframe to excel with pandas
  16. How to write/update data into cells of existing XLSX workbook using xlsxwriter in python
  17. win32.Dispatch vs win32.gencache in Python. What are the pros and cons?
  18. How to copy worksheet from one workbook to another one using openpyxl?
  19. drop_duplicates not working in pandas?
  20. Calling python script from excel/vba
  21. Merge rows based on value (pandas to excel – xlsxwriter)
  22. How to read SharePoint Online (Office365) Excel files in Python with Work or School Account?
  23. Use Python to Inject Macros into Spreadsheets
  24. Write to StringIO object using Pandas Excelwriter?
  25. Identifying Excel Sheet cell color code using XLRD package
  26. Get cell color from .xlsx
  27. Python Pandas – Read csv file containing multiple tables
  28. django excel xlwt
  29. Automation Excel from Python
  30. XlsxWriter object save as http response to create download in Django

Leave a Comment