KeyboardInterrupt/ansible_xlsx_inventory

Error: ImportError: cannot import name 'coordinate_from_string'

Closed this issue · 1 comments

./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.

Resolved by #7