Fix for module win32com.gen_py has no attribute 'CLSIDToPackageMap'

win32com.client.py

# If errors are found, do this
# clear contents of C:\Users\<username>\AppData\Local\Temp\gen_py
# that should fix it, to test it type
import win32com.client
app = win32com.client.gencache.EnsureDispatch('Word.Application')
app.Visible = True

I modified @fossum code:

try:
    xl = client.gencache.EnsureDispatch('Excel.Application')
except AttributeError:
    # Corner case dependencies.
    import os
    import re
    import sys
    import shutil
    # Remove cache and try again.
    MODULE_LIST = [m.__name__ for m in sys.modules.values()]
    for module in MODULE_LIST:
        if re.match(r'win32com\.gen_py\..+', module):
            del sys.modules[module]
    shutil.rmtree(os.path.abspath(os.path.join(win32com.__gen_path__, '..')))
    from win32com import client
    xl = client.gencache.EnsureDispatch('Excel.Application')

shutil.rmtree(os.path.join(os.environ.get('LOCALAPPDATA'), 'Temp', 'gen_py')) did not work for me as the code is running on a server.

Better to use:
shutil.rmtree(os.path.abspath(win32com.__gen_path__+'/..'))

@Ddedalus worked for me, thanks...

Anyone know what causes this? Seems rather unpredictable....

Depuis PowerShell on peut utiliser :

 Remove-Item -path $env:LOCALAPPDATA\Temp\gen_py -recurse

Thanks

The following code will only delete the folder of the cache - it worked for me, but the better solution is "shutil" - earlier in this topic

try:
xl = gencache.EnsureDispatch('Excel.Application')
except AttributeError as ae:
error_message = str(ae)
if 'win32com.gen_py' in error_message:
start = error_message.find('win32com.gen_py.')+len('win32com.gen_py.')
tmp_em = error_message[start:]
end = tmp_em.find("'")
the_dir_to_remove = tmp_em[:end]
if the_dir_to_remove in os.listdir(win32com.gen_path):
win_gen_path_to_rm = win32com.gen_path+'\'+the_dir_to_remove
print("Removing: ", win_gen_path_to_rm)
recurcive_removal(win_gen_path_to_rm)
else:
print("unknown error of win32com")
else:
print("unknown error")
print(ae)

In My case, i had to reinstall office first in my case 64 bit
when i took the desicion to reinstall there were an error caused for AccessDatabaseEngine---(2007) 32 bit,
i had to uninstall Acess... first before i could reinstall, such thing was causing some sort of conflict or whatnot
,then # clear contents of C:\Users<username>\AppData\Local\Temp\gen_py
,then it work again

Note that the folder gen_py with the associated python version could be retrieved directly from win32com.__gen_path__:

Therefore, we could have the following code:

import logging
import re
from pathlib import Path
from shutil import rmtree

from win32com import client, __gen_path__

try:
    word = client.gencache.EnsureDispatch("Word.Application")
except AttributeError as e:
    # Sometimes we might have to clean the cache to open
    m_failing_cache = re.search(r"win32com\.gen_py\.([\w\-]+)", str(e))
    if m_failing_cache:
        cache_folder_name = m_failing_cache.group(1)
        logging.warning(f"Cleaning cache for '{cache_folder_name}'")
        cache_folder = Path(__gen_path__).joinpath(cache_folder_name)
        rmtree(cache_folder)
        word = client.gencache.EnsureDispatch("Word.Application")
    else:
        raise

The following code will only delete the folder of the cache - it worked for me, but the better solution is "shutil" - earlier in this topic

try: xl = gencache.EnsureDispatch('Excel.Application') except AttributeError as ae: error_message = str(ae) if 'win32com.gen_py' in error_message: start = error_message.find('win32com.gen_py.')+len('win32com.gen_py.') tmp_em = error_message[start:] end = tmp_em.find("'") the_dir_to_remove = tmp_em[:end] if the_dir_to_remove in os.listdir(win32com.gen_path): win_gen_path_to_rm = win32com.gen_path+''+the_dir_to_remove print("Removing: ", win_gen_path_to_rm) recurcive_removal(win_gen_path_to_rm) else: print("unknown error of win32com") else: print("unknown error") print(ae)

@HeroOfStorm When putting code, it's better to put between triple backsticks with an optional language, like:

```python
... Your code
```

This will:

• Ensure correct indenting
• Avoid __gen_path__ being replaced by gen_path (with bold and without underscores)
• Provide syntax Highlighting

Hi, in my case, sudenly, it happens again, i tried all metods showed here and no luck, in the end, i realized that my microsoft 365 apps for enterprise had beed updated few days ago in windows control panel, just right click, change, quick repair, and thats it, it worked again!!

regards

@amarines2605 - I've deleted gen_py countless times as everyone seems to recommend... the quickfix for microsoft 365 was the piece I was missing. Thank you for the solution.

Remove-Item -path $env:LOCALAPPDATA\Temp\gen_py -recurse

work for me!!!!!!!!!!!! ty!