Defined Name RANGE for a table column
With a defined name range with value : =table[column]
; a reference to a column of a table
dn = wb.defined_names["dn"]
print(dn.type)
RANGE
for title, coord in dn.destinations :
ws = wb[title]
Traceback (most recent call last):
File "/home/test.py", line 10, in <module>
for title, coord in dn.destinations :
File "/home/py3.10/lib/python3.10/site-packages/openpyxl/workbook/defined_name.py", line 140, in destinations
sheetname = m.group('notquoted') or m.group('quoted')
AttributeError: 'NoneType' object has no attribute 'group'
Openpyxl 3.0.10