Trying to read the xlsx, but getting error

Issue #569 resolved
sagar shirsath
created an issue

Here is the error

raise NamedRangeException('Invalid named range string: "%s"' % range_string)
openpyxl.utils.exceptions.NamedRangeException: Invalid named range string: "{TRUE"

can you explain why it is coming,
i want to ignore it without modifying the xlsx file.

Comments (13)

  1. sagar shirsath reporter

    Here is the file that gives following error :
    Traceback (most recent call last):
    File "model_validate.py", line 4, in <module>
    wb = load_workbook(filename = '/home/sagar/PXD_1436231695.xlsx')
    File "/home/sagar/contrib/local/lib/python2.7/site-packages/openpyxl/reader/excel.py", line 252, in load_workbook
    wb._named_ranges = list(read_named_ranges(archive.read(ARC_WORKBOOK), wb))
    File "/home/sagar/contrib/local/lib/python2.7/site-packages/openpyxl/workbook/names/named_range.py", line 138, in read_named_ranges
    destinations = [(workbook[sheet], cells) for sheet, cells in destinations
    File "/home/sagar/contrib/local/lib/python2.7/site-packages/openpyxl/workbook/names/named_range.py", line 94, in split_named_range
    raise NamedRangeException('Invalid named range string: "%s"' % range_string)
    openpyxl.utils.exceptions.NamedRangeException: Invalid named range string: "{TRU

  2. Log in to comment