shows CellRange ValueError when load workbook
Created originally on Bitbucket by nana
When I try to load attached ”CPR_testtable.xlsx”, it shows error:
Traceback (most recent call last):
File "try_openpyxl.py", line 183, in <module>
xlsx2csv(xlsx_folder, csv_folder, "Software_Bins")
File "try_openpyxl.py", line 125, in xlsx2csv
wb = xl.load_workbook(xlsx_folder+Filename_xlsx)
File "/usr/lib/python2.7/site-packages/openpyxl/reader/excel.py", line 312, in load_workbook
reader.read()
File "/usr/lib/python2.7/site-packages/openpyxl/reader/excel.py", line 274, in read
self.read_worksheets()
File "/usr/lib/python2.7/site-packages/openpyxl/reader/excel.py", line 228, in read_worksheets
ws_parser.bind_all()
File "/usr/lib/python2.7/site-packages/openpyxl/worksheet/_reader.py", line 403, in bind_all
self.bind_cells()
File "/usr/lib/python2.7/site-packages/openpyxl/worksheet/_reader.py", line 326, in bind_cells
for idx, row in self.parser.parse():
File "/usr/lib/python2.7/site-packages/openpyxl/worksheet/_reader.py", line 146, in parse
obj = prop[1].from_tree(element)
File "/usr/lib/python2.7/site-packages/openpyxl/descriptors/serialisable.py", line 104, in from_tree
return cls(**attrib)
File "/usr/lib/python2.7/site-packages/openpyxl/worksheet/filters.py", line 329, in __init__
self.ref = ref
File "/usr/lib/python2.7/site-packages/openpyxl/descriptors/excel.py", line 105, in __set__
super(CellRange, self).__set__(instance, value)
File "/usr/lib/python2.7/site-packages/openpyxl/descriptors/base.py", line 255, in __set__
raise ValueError('Value does not match pattern {0}'.format(self.pattern))
ValueError: Value does not match pattern ^[$]?([A-Za-z]{1,3})[$]?(\d+)(:[$]?([A-Za-z]{1,3})[$]?(\d+)?)?$|^[A-Za-z]{1,3}:[A-Za-z]{1,3}$
I don’t know what is this mean? Can you help me?
Attach my code and issue .xlsx file.
Attachments: issue_xlsx.rar