expected type error since 2.5.0
Created originally on Bitbucket by jdbothma (JD Bothma)
The attached spreadsheet opened fine in 2.4.9, 2.4.10 and 2.4.11 but I get the following error in 2.5.0 if I open it writable:
Traceback (most recent call last):
File "bin/epre.py", line 203, in <module>
scrape_file(filepath, province_code, budget_financial_year)
File "bin/epre.py", line 58, in scrape_file
wb = load_workbook(filename=filename, data_only=True)
File "/home/jdb/proj/code4sa/treasury-portal/fiscal-data-package/env/lib/python3.6/site-packages/openpyxl/reader/excel.py", line 274, in load_workbook
for c in find_charts(archive, rel.target):
File "/home/jdb/proj/code4sa/treasury-portal/fiscal-data-package/env/lib/python3.6/site-packages/openpyxl/chart/reader.py", line 43, in find_charts
drawing = SpreadsheetDrawing.from_tree(tree)
File "/home/jdb/proj/code4sa/treasury-portal/fiscal-data-package/env/lib/python3.6/site-packages/openpyxl/descriptors/serialisable.py", line 84, in from_tree
obj = desc.expected_type.from_tree(el)
File "/home/jdb/proj/code4sa/treasury-portal/fiscal-data-package/env/lib/python3.6/site-packages/openpyxl/descriptors/serialisable.py", line 84, in from_tree
obj = desc.expected_type.from_tree(el)
File "/home/jdb/proj/code4sa/treasury-portal/fiscal-data-package/env/lib/python3.6/site-packages/openpyxl/descriptors/serialisable.py", line 84, in from_tree
obj = desc.expected_type.from_tree(el)
[Previous line repeated 3 more times]
File "/home/jdb/proj/code4sa/treasury-portal/fiscal-data-package/env/lib/python3.6/site-packages/openpyxl/descriptors/serialisable.py", line 100, in from_tree
return cls(**attrib)
File "/home/jdb/proj/code4sa/treasury-portal/fiscal-data-package/env/lib/python3.6/site-packages/openpyxl/drawing/shapes.py", line 104, in __init__
self.lat = lat
File "/home/jdb/proj/code4sa/treasury-portal/fiscal-data-package/env/lib/python3.6/site-packages/openpyxl/descriptors/base.py", line 44, in __set__
raise TypeError('expected ' + str(self.expected_type))
TypeError: expected <class 'openpyxl.descriptors.base.Integer'>
It works fine when I open it readonly but I haven't figured out how to check if a row is hidden when readonly.
This is how I open it: https://github.com/OpenUpSA/treasury-data-package-pipeline/blob/01cdffdc0dd3eb75938d506d87029211c42c5995/bin/epre.py
Attachments: EC_-EPRE-2015-16-_Final.xlsm