python error in import

Question

In a vartual env taxenv when I try to run my python program runner.py it shows the following error

enter image description here

The first line of my runner.py is

from openpyxl.reader.excel import load_workbook

what to do? How do I install openpyxl in the virtual env?

I've tried pip install openpyxl in the virtualenv

enter image description here

Answer 1

Install it using pip:

pip install openpyxl

Optionally specify a requirements.txt to specify the dependencies. Read more about it here.

• user1733583: when I do pip install openpyxl it's giving another error as shown above
• Remco Haszing: Maybe you need to upgrade pip or setuptools first using pip install pip setuptools --upgrade.