"openpyxl" is not accessed Pylance

[dee]

Hello,

I installed openpyxl using pip install openpyxl, but I’m running into issues when trying to use it.

In my script, import openpyxl is flagged by Pylance as "openpyxl is not accessed". When I run the script, I get the following error:
ModuleNotFoundError: No module named 'openpyxl'

Please advise.
Thanks.
Dee

[snippsat]

ModuleNotFoundError: No module named 'openpyxl'

That usually means openpyxl was installed into a different Python environment than the one running your script.
I you use VS Code look down i right corner to see what Python interpreter it use or
Ctrl + Shift + P
Then type:
Python: Select Interpreter

From command line,if work here use same Python interpreter in VC Code.

python -m pip install openpyxl

python --version
python -c "import sys; print(sys.executable)"

python -m pip show openpyxl
python -c "import openpyxl; print(openpyxl.__version__)"

[deanhystad]

Are you using a virtual environment? If so, did you activate your virtual environment before running "pip install openpyxl"? Does openpyxl appear in the list when you run "pip list"?

[dee]

Thanks for the responses.

openpyxl was installed. After I ran "-m pip show openpyxl", it has the following. It seems for Excel 2010.
Version: 3.1.5
Summary: A Python library to read/write Excel 2010 xlsx/xlsm files
Home-page: https://openpyxl.readthedocs.io
Author: See AUTHORS
Author-email: [email protected]
License: MIT
Location: C:\****\.venv\Lib\site-packages
Requires: et-xmlfile

What if I have Excel 365?

[deanhystad]

That shows that you have openpyxl installed in some virtual environment (****\.venv). Are you using that virtual environment when you run your program?

[snippsat]

Location: C:\****\.venv\Lib\site-packages
This mean that openpyxl is installed in a virtual environment.

Then you most choose this environment in VS Code.
Open Command Palette: Ctrl + Shift + P
Choose Python: Select Interpreter
Select the interpreter that points to environment:
C:\...\ .venv\Scripts\python.exe

[dee]

Thanks snippsat and deanhystad.