Error: ImportError: cannot import name 'coordinate_from_string'
Closed this issue · 1 comments
KeyboardInterrupt commented
./xlsx_inventory.py --config --file hosts_hot.xlsx --hostname-col A --group-by-col W -sheet Sheet1
Traceback (most recent call last):
File "./xlsx_inventory.py", line 9, in <module>
from openpyxl.utils import coordinate_from_string, column_index_from_string
ImportError: cannot import name 'coordinate_from_string'
Using Python3.5.2
on Ubuntu 16.04 in a venv with dependencies installed form requirements.txt
et-xmlfile==1.0.1
jdcal==1.4
openpyxl==2.6.0
pkg-resources==0.0.0
six==1.12.0
Changing line 9
from:
from openpyxl.utils import coordinate_from_string, column_index_from_string
to:
from openpyxl.utils.cell import coordinate_from_string, column_index_from_string
(notice the cell
submodule)
apparently fixes the Issue.
My first Assumption is that an older version Version of openpyxel
was structured differently, and with a newer Version (openpyxl==2.6.0
) this breaks.
KeyboardInterrupt commented
Resolved by #7