invalid named range string
Created originally on Bitbucket by Anonymous
I was trying to read an xlsx file, and got the following error:
{{{ #!python
In [6]: wb = load_workbook('Data/PG model v3.0.xlsx')
Exception Traceback (most recent call last)
/Users/…/WorkAndData/ in ()
/Users/…/WorkAndData/openpyxl/reader/excel.py in load_workbook(filename) 63 # add named ranges
64 wb._named_ranges = read_named_ranges(xml_source = archive.get_from_name(arc_name = ARC_WORKBOOK),
---> 65 workbook = wb) 66 67 finally:
/Users/…/WorkAndData/openpyxl/reader/workbook.py in read_named_ranges(xml_source, workbook) 72 for name_node in names_root.getchildren(): 73 ---> 74 worksheet_name, column, row = split_named_range(range_string = name_node.text) 75 worksheet = workbook.get_sheet_by_name(worksheet_name) 76 range = '%s%s' % (column, row)
/Users/…/WorkAndData/openpyxl/namedrange.py in split_named_range(range_string) 41 42 if not matches: ---> 43 raise Exception('invalid named range string') 44 else: 45 sheet_name, column, row = matches.groups()
Exception: invalid named range string
}}}
I therefore added some diagnostics in the exception text:
{{{ #!python
/Users/…/WorkAndData/openpyxl/namedrange.py in split_named_range(range_string) ---> 43 raise Exception('invalid named range string: %s' % range_string) }}}
The un-recognized string is HYPOTHESES!$B3:
L$3. The file was created by Excel itself…
(openpyxl.version is 0.0.1.)