Python 3 How to resolve No module named '_win32com' error?

Question

I'm using Python 3 and working in Pycharm.

I was able to get pywin32 and win32com working on one project, but since I have tried importing them into a new project, they don't seem to be working. At first I was getting No module named 'win32api', but I updated the win32com\__init__.py from import win32api to from win32 import win32api. That seems to have fixed the initial error, but now I'm getting No module named '_win32com'. This seems to be from issues with \pythoncom\__init__.py maybe?

I've tried uninstalling and reinstalling pywin32 and pypiwin32 as well.

Example of code here:

import win32com.client as win32
xlapp = win32.DispatchEx("Excel.Application")
wbe = xlapp.workbooks.open(r"C:\Users\me\example.xlsx")

"but since I have tried importing them into a new project, they don't seem to be working" How did you try to "import them into a new project"? I think it might be a virtual environment issue (ie. the packages were not globally installed), but that's just a guess. — Uncle Dino
– Uncle Dino, Commented Jul 26, 2022 at 20:49
I believe that is correct, they are not installed globally right now. By import into a new project, I mean I started a new project, imported using the code above and making sure the packages are installed, etc. That's how I did it in the first project without issue. — scorbin
– scorbin, Commented Jul 26, 2022 at 21:34
Have you checked this: stackoverflow.com/questions/49307303/… (install script also mentioned on pypi.org/project/pywin32) — Uncle Dino
– Uncle Dino, Commented Jul 26, 2022 at 21:41
I haven't seen that specific post, but I've seen similar. I've got pypiwin32 installed as well, it's loaded in the project. I've tried that post_install script as well and that doesn't work. Although, I haven't tried deleting any copies of the dll's. Not sure where those should be located. — scorbin
– scorbin, Commented Jul 26, 2022 at 21:56
I would also just note that I am seeing the error for '_win32com' with an underscore, while every other post I have seen is for 'win32com'. I am not sure if that is important. — scorbin
– scorbin, Commented Jul 26, 2022 at 21:57

scorbin · Accepted Answer · 2022-07-27 17:32:56Z

0

I decided to try again with a new project and install the packages globally and that has fixed the issue. Still not sure why it wasn't working when installing locally, but using global installs seems to be good solution.

answered Jul 27, 2022 at 17:32

scorbin

93 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python 3 How to resolve No module named '_win32com' error?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related