When trying to append dataframe to Excel that contains pivot table raises TypeError: Value must be a sequence.
This error raised only when selected execl file contains pivot table, when deleting all pivot tables from selected excel the append works as expected. meanwhile i've downgraded to 3.0.4 and everything working with no problems.
Traceback (most recent call last):
File "C:/python/ExcelTol/venv/main.py", line 181, in <module>
main()
File "C:/python/ExcelTol/venv/main.py", line 162, in main
**with pd.ExcelWriter(output, engine="openpyxl", mode='a') as writer:**
File "C:\Python\ExcelToSql\venv\lib\site-packages\pandas\io\excel\_openpyxl.py", line 25, in __init__
book = load_workbook(self.path)
File "C:\Python\ExcelToSql\venv\lib\site-packages\openpyxl\reader\excel.py", line 315, in load_workbook
reader.read()
File "C:\Python\ExcelToSql\venv\lib\site-packages\openpyxl\reader\excel.py", line 280, in read
self.read_worksheets()
File "C:\Python\ExcelToSql\venv\lib\site-packages\openpyxl\reader\excel.py", line 266, in read_worksheets
pivot = TableDefinition.from_tree(tree)
File "C:\Python\ExcelToSql\venv\lib\site-packages\openpyxl\descriptors\serialisable.py", line 83, in from_tree
obj = desc.from_tree(el)
File "C:\Python\ExcelToSql\venv\lib\site-packages\openpyxl\descriptors\sequence.py", line 85, in from_tree
return [self.expected_type.from_tree(el) for el in node]
File "C:\Python\ExcelToSql\venv\lib\site-packages\openpyxl\descriptors\sequence.py", line 85, in <listcomp>
return [self.expected_type.from_tree(el) for el in node]
File "C:\Python\ExcelToSql\venv\lib\site-packages\openpyxl\descriptors\serialisable.py", line 103, in from_tree
return cls(**attrib)
File "C:\Python\ExcelToSql\venv\lib\site-packages\openpyxl\pivot\table.py", line 601, in __init__
self.x = x
File "C:\Python\ExcelToSql\venv\lib\site-packages\openpyxl\descriptors\sequence.py", line 25, in __set__
**raise TypeError("Value must be a sequence")
TypeError: Value must be a sequence**