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
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’