TypeError: __init__() got an unexpected keyword argument 'extLst'
*Created originally on Bitbucket by [Raul (Raul Padilla)](https://bitbucket.org/%7B6b8099a7-26ae-4781-89d9-653857c4ad1e%7D/)*
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)
<ipython-input-9-7e418d5f0397> in <module>()
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 <listcomp>(.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.xlsx](/uploads/00e049685423aab9cb6ffa2d82ad62a7/dataframe.xlsx)[destination.xlsx](/uploads/7f12927365605dae73c5e0d5416fd8e8/destination.xlsx)
issue