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