TypeError: __init__() got an unexpected keyword argument 'extLst'

Created originally on Bitbucket by Raul (Raul Padilla)

Hey Charlie,

Openpyxl 2.5.0b1 now works fine for Excel workbooks with only one pivot table. I noticed that if a workbook contains multiple pivot tables, it will get the error below. Please let me know if you have the same issue. Thanks!

---

TypeError Traceback (most recent call last) in () 23 24 destination = 'C:/Users/raul.padilla/Desktop/SPOTLIGHT ACTUALIZATION TEMPLATE (UPDATED).xlsx'

---> 25 wb = openpyxl.load_workbook(destination) 26 writer = pd.ExcelWriter(destination, engine='openpyxl') 27 writer.book = wb

~\AppData\Local\Continuum\anaconda3\lib\site-packages\openpyxl\reader\excel.py in load_workbook(filename, read_only, keep_vba, data_only, guess_types, keep_links) 280 src = archive.read(pivot_path) 281 tree = fromstring(src) --> 282 pivot = TableDefinition.from_tree(tree) 283 pivot.cache = pivot_caches[pivot.cacheId] 284 ws.add_pivot(pivot)

~\AppData\Local\Continuum\anaconda3\lib\site-packages\openpyxl\descriptors\serialisable.py in from_tree(cls, node) 77 if hasattr(desc, 'from_tree'): 78 #descriptor manages conversion ---> 79 obj = desc.from_tree(el) 80 else: 81 if hasattr(desc.expected_type, "from_tree"):

~\AppData\Local\Continuum\anaconda3\lib\site-packages\openpyxl\descriptors\sequence.py in from_tree(self, node) 84 85 def from_tree(self, node): ---> 86 return [self.expected_type.from_tree(el) for el in node] 87 88

~\AppData\Local\Continuum\anaconda3\lib\site-packages\openpyxl\descriptors\sequence.py in (.0) 84 85 def from_tree(self, node): ---> 86 return [self.expected_type.from_tree(el) for el in node] 87 88

~\AppData\Local\Continuum\anaconda3\lib\site-packages\openpyxl\descriptors\serialisable.py in from_tree(cls, node) 97 attrib[tag] = obj 98 ---> 99 return cls(**attrib) 100 101

TypeError: init() got an unexpected keyword argument 'extLst'

Attachments: dataframe.xlsxdestination.xlsx