When trying to load an existing XLSX file I am getting this error.
Can anyone please advise.
C:\Users\MittapelliS1\PycharmProjects\pythonProject\venv\Scripts\python.exe C:/Users/MittapelliS1/PycharmProjects/pythonProject/update_siebel_check_excel.py
C:\Users\MittapelliS1\PycharmProjects\pythonProject\venv\lib\site-packages\openpyxl\worksheet\_reader.py:312: UserWarning: Data Validation extension is not supported and will be removed
warn(msg)
C:\Users\MittapelliS1\PycharmProjects\pythonProject\venv\lib\site-packages\openpyxl\worksheet\_reader.py:312: UserWarning: Slicer List extension is not supported and will be removed
warn(msg)
Traceback (most recent call last):
File "C:\Users\MittapelliS1\PycharmProjects\pythonProject\update_siebel_check_excel.py", line 27, in <module>
clear_transactions()
File "C:\Users\MittapelliS1\PycharmProjects\pythonProject\update_siebel_check_excel.py", line 21, in clear_transactions
workbook = load_workbook(filename=excel_path, read_only=False)
File "C:\Users\MittapelliS1\PycharmProjects\pythonProject\venv\lib\site-packages\openpyxl\reader\excel.py", line 317, in load_workbook
reader.read()
File "C:\Users\MittapelliS1\PycharmProjects\pythonProject\venv\lib\site-packages\openpyxl\reader\excel.py", line 282, in read
self.read_worksheets()
File "C:\Users\MittapelliS1\PycharmProjects\pythonProject\venv\lib\site-packages\openpyxl\reader\excel.py", line 268, in read_worksheets
pivot = TableDefinition.from_tree(tree)
File "C:\Users\MittapelliS1\PycharmProjects\pythonProject\venv\lib\site-packages\openpyxl\descriptors\serialisable.py", line 83, in from_tree
obj = desc.from_tree(el)
File "C:\Users\MittapelliS1\PycharmProjects\pythonProject\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:\Users\MittapelliS1\PycharmProjects\pythonProject\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:\Users\MittapelliS1\PycharmProjects\pythonProject\venv\lib\site-packages\openpyxl\descriptors\serialisable.py", line 103, in from_tree
return cls(**attrib)
File "C:\Users\MittapelliS1\PycharmProjects\pythonProject\venv\lib\site-packages\openpyxl\pivot\table.py", line 481, in __init__
self.scope = scope
File "C:\Users\MittapelliS1\PycharmProjects\pythonProject\venv\lib\site-packages\openpyxl\descriptors\base.py", line 128, in __set__
raise ValueError(self.__doc__)
ValueError: Value must be one of {'field', 'selection', 'data'}
Sathish.