# python unable to install open\_excel module for ansible

**URL:** <https://forum.ansible.com/t/python-unable-to-install-open-excel-module-for-ansible/33401>\
**Category:** Ansible Project\
**Created:** [July 15, 2020, 2:45am UTC](https://forum.ansible.com/t/python-unable-to-install-open-excel-module-for-ansible/33401 "2020-07-15T02:45:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![stack\_flow](https://avatars.discourse-cdn.com/v4/letter/s/97f17d/32.png) [@stack\_flow](https://forum.ansible.com/u/stack_flow)\
**Post date:** [July 15, 2020, 2:45am UTC](https://forum.ansible.com/t/python-unable-to-install-open-excel-module-for-ansible/33401/1 "2020-07-15T02:45:52Z")

</div>

Hello,

I need open\_excel module for ansible so that it can read multiple sheets in excel. I am getting following errors. how to fix it? I am using macbook os catalina.

_ljames@mac ~ % pip3 install open\_excel_  
_Collecting open\_excel_  
_Using cached [https://files.pythonhosted.org/packages/91/5c/71c6bf1b23d923da947c264aaf3606204aee2bc63ab450fe20a14ab98d63/open\_excel-0.101a0.tar.gz](https://files.pythonhosted.org/packages/91/5c/71c6bf1b23d923da947c264aaf3606204aee2bc63ab450fe20a14ab98d63/open_excel-0.101a0.tar.gz)_  
_Requirement already satisfied: openpyxl in /Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages (from open\_excel) (3.0.4)_  
_Requirement already satisfied: jdcal in /Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages (from openpyxl-\>open\_excel) (1.4.1)_  
_Requirement already satisfied: et-xmlfile in /Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages (from openpyxl-\>open\_excel) (1.0.1)_  
_Installing collected packages: open-excel_  
_Running setup.py install for open-excel … error_  
_ERROR: Command errored out with exit status 1:_  
_command: /Library/Frameworks/Python.framework/Versions/3.7/bin/python3.7 -u -c ‘import sys, setuptools, tokenize; sys.argv[0] = ‘"’"’/private/var/folders/l8/gjnzx82j2fbd8dqjdxvmx7940000gn/T/pip-install-7rj4t72f/open-excel/setup.py’“'”‘; **file** =’“'”‘/private/var/folders/l8/gjnzx82j2fbd8dqjdxvmx7940000gn/T/pip-install-7rj4t72f/open-excel/setup.py’“'”‘;f=getattr(tokenize, ‘"’“‘open’”’“‘, open)( **file** );code=f.read().replace(’”‘"’\r\n’“'”‘, ‘"’"’\n’“'”‘);f.close();exec(compile(code, **file** , ‘"’“‘exec’”’"‘))’ install --record /private/var/folders/l8/gjnzx82j2fbd8dqjdxvmx7940000gn/T/pip-record-kl2pm\_3e/install-record.txt --single-version-externally-managed --compile_  
_cwd: /private/var/folders/l8/gjnzx82j2fbd8dqjdxvmx7940000gn/T/pip-install-7rj4t72f/open-excel/_  
_Complete output (14 lines):_  
_/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/setuptools/dist.py:474: UserWarning: Normalizing ‘0.101a’ to ‘0.101a0’_  
_normalized\_version,_  
_running install_  
_running build_  
_running build\_py_  
_creating build_  
_creating build/lib_  
_creating build/lib/open\_excel_  
_copying open\_excel/search\_excel.py → build/lib/open\_excel_  
_copying open\_excel/ **init**.py → build/lib/open\_excel_  
_copying open\_excel/open\_excel.py → build/lib/open\_excel_  
_running build\_scripts_  
_creating build/scripts-3.7_  
_error: [Errno 21] Is a directory: ‘open\_excel’_

---

<div class="post-metadata">

**Author:** ![Dick\_Visser](https://avatars.discourse-cdn.com/v4/letter/d/d9b06d/32.png) [@Dick\_Visser](https://forum.ansible.com/u/Dick_Visser)\
**Post date:** [July 15, 2020, 9:56am UTC](https://forum.ansible.com/t/python-unable-to-install-open-excel-module-for-ansible/33401/2 "2020-07-15T09:56:18Z")

</div>

Your best bet is to ask the author of that code:  
[https://pypi.org/user/mohamedosam/](https://pypi.org/user/mohamedosam/)

---

<div class="post-metadata">

**Author:** ![Udayendu\_kar](https://avatars.discourse-cdn.com/v4/letter/u/87869e/32.png) [@Udayendu\_kar](https://forum.ansible.com/u/Udayendu_kar)\
**Post date:** [July 15, 2020, 10:04am UTC](https://forum.ansible.com/t/python-unable-to-install-open-excel-module-for-ansible/33401/3 "2020-07-15T10:04:52Z")

</div>

You can use:

$ sudo pip3 install openpyxl -y

I am using this and its working perfectly.