Use pip or conda to install openpyxl

When I tried to read a xlsx file (xls = pd.ExcelFile(‘yelp.xlsx’)), I got a msg: 'ImportError: Missing optional dependency ‘openpyxl’. Use pip or conda to install openpyxl.

Anyone can help me to figure it out? Thanks a lot


you can install the missing dependency via Environments → Packages, or by executing the following command:
!pip install openpyxl

Will ask the devs if it is possible to include this package into the default env.

Thank you!