Pivot table format unreadable
Created originally on Bitbucket by kanesharan
I am currently using 2.5.9. I have several pivot tables in my excel file. When loading workbook, I get the error below. However, when I clear the format of these pivot tables (Home -> Clear -> Clear Formats), the excel file loads fine in Openpyxl.
#!python
Traceback (most recent call last):
File "testfornewopenpyxl.py", line 11, in <module>
filee = openpyxl.reader.excel.load_workbook(filename=path)
File "C:\Users\kane\PycharmProjects\report_automation\tool\ui\openpyxl\reader\excel.py", line 286, in load_workbook
pivot = TableDefinition.from_tree(tree)
File "C:\Users\kane\PycharmProjects\report_automation\tool\ui\openpyxl\descriptors\serialisable.py", line 80, in from_tree
obj = desc.from_tree(el)
File "C:\Users\kane\PycharmProjects\report_automation\tool\ui\openpyxl\descriptors\sequence.py", line 86, in from_tree
return [self.expected_type.from_tree(el) for el in node]
File "C:\Users\kane\PycharmProjects\report_automation\tool\ui\openpyxl\descriptors\serialisable.py", line 100, in from_tree
return cls(**attrib)
File "C:\Users\kane\PycharmProjects\report_automation\tool\ui\openpyxl\pivot\table.py", line 503, in __init__
self.dxfId = dxfId
File "C:\Users\kane\PycharmProjects\report_automation\tool\ui\openpyxl\descriptors\base.py", line 69, in __set__
value = _convert(self.expected_type, value)
File "C:\Users\kane\PycharmProjects\report_automation\tool\ui\openpyxl\descriptors\base.py", line 59, in _convert
raise TypeError('expected ' + str(expected_type))
TypeError: expected <type 'long'>