Another Google Sheets pivot table crash
*Created originally on Bitbucket by [bjwebb (Ben Webb)](https://bitbucket.org/%7B6fc79bf2-665b-41ff-898d-b74e9065badb%7D/)* Following on from https://bitbucket.org/openpyxl/openpyxl/issues/1175/google-sheets-pivot-table-causes-openpyxl, it looks like our actual data file causes a different error than the simple example. Here's the file: https://docs.google.com/spreadsheets/d/1p-6zgIEXmLWSixDuOH_p6xhnPC64pri-acu5sL8I-OE/export?format=xlsx (also attached) Here's the error: ``` #!python3-traceback Python 3.6.7 (default, Oct 22 2018, 11:32:17) [GCC 8.2.0] on linux Type "help", "copyright", "credits" or "license" for more information. >>> from openpyxl import load_workbook >>> wb = load_workbook('CoVE IATI 2.03 #2019-02-04 #pivot #published.xlsx') Traceback (most recent call last): File "/home/bjwebb/opendataservices/openpyxl/openpyxl/descriptors/base.py", line 57, in _convert value = expected_type(value) TypeError: int() argument must be a string, a bytes-like object or a number, not 'NoneType' During handling of the above exception, another exception occurred: Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/home/bjwebb/opendataservices/openpyxl/openpyxl/reader/excel.py", line 312, in load_workbook reader.read() File "/home/bjwebb/opendataservices/openpyxl/openpyxl/reader/excel.py", line 274, in read self.read_worksheets() File "/home/bjwebb/opendataservices/openpyxl/openpyxl/reader/excel.py", line 260, in read_worksheets pivot = TableDefinition.from_tree(tree) File "/home/bjwebb/opendataservices/openpyxl/openpyxl/descriptors/serialisable.py", line 84, in from_tree obj = desc.from_tree(el) File "/home/bjwebb/opendataservices/openpyxl/openpyxl/descriptors/sequence.py", line 86, in from_tree return [self.expected_type.from_tree(el) for el in node] File "/home/bjwebb/opendataservices/openpyxl/openpyxl/descriptors/sequence.py", line 86, in <listcomp> return [self.expected_type.from_tree(el) for el in node] File "/home/bjwebb/opendataservices/openpyxl/openpyxl/descriptors/serialisable.py", line 104, in from_tree return cls(**attrib) File "/home/bjwebb/opendataservices/openpyxl/openpyxl/pivot/table.py", line 572, in __init__ self.hier = hier File "/home/bjwebb/opendataservices/openpyxl/openpyxl/descriptors/base.py", line 69, in __set__ value = _convert(self.expected_type, value) File "/home/bjwebb/opendataservices/openpyxl/openpyxl/descriptors/base.py", line 59, in _convert raise TypeError('expected ' + str(expected_type)) TypeError: expected <class 'int'> >>> ``` This looks similar to the last one, so I suspect its a similar issue with google docs. I don't need to use openpyxl's pivot table support, so one way for me to deal with these errors would be to monkeypatch to disable pivot table support. *Attachments:* [CoVE_IATI_2.03__2019-02-04__pivot__published.xlsx](/uploads/975470dcfe73ec560102c5960126441a/CoVE_IATI_2.03__2019-02-04__pivot__published.xlsx)
issue