ValueError: Value must be one of {'field', 'selection', 'data'}

[Sathish Kumar]

Hi All,

Good day!!

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'}

Thanks and Regards,

Sathish.

[Charlie Clark]

On 8 Sep 2021, at 10:55, Sathish Kumar wrote:

> Hi All,
>
> Good day!!
>
> When trying to load an existing XLSX file I am getting this error.
>
> Can anyone please advise.

I think the exception is fairly self-explanatory: the table contains some invalid definitions. If you think this is a bug, please submit a bug report with a sample file.

Thanks

Charlie

--
Charlie Clark
Managing Director
Clark Consulting & Research
German Office
Waldlehne 23
Düsseldorf
D- 40489
Tel: +49-203-3925-0390
Mobile: +49-178-782-6226