ValueError: Value must be one of {'top', 'justify', 'bottom', 'center', 'distributed'}
I am Trying to load workbook attached and getting error.
Traceback (most recent call last): File "test.py", line 16, in <module> wb = openpyxl.load_workbook('/home/scorer/Work/deepak/rahul/lazada_download/test.xlsx', data_only=True) File "/usr/local/lib/python3.7/site-packages/openpyxl/reader/excel.py", line 315, in load_workbook reader.read() File "/usr/local/lib/python3.7/site-packages/openpyxl/reader/excel.py", line 279, in read apply_stylesheet(self.archive, self.wb) File "/usr/local/lib/python3.7/site-packages/openpyxl/styles/stylesheet.py", line 192, in apply_stylesheet stylesheet = Stylesheet.from_tree(node) File "/usr/local/lib/python3.7/site-packages/openpyxl/styles/stylesheet.py", line 102, in from_tree return super(Stylesheet, cls).from_tree(node) File "/usr/local/lib/python3.7/site-packages/openpyxl/descriptors/serialisable.py", line 87, in from_tree obj = desc.expected_type.from_tree(el) File "/usr/local/lib/python3.7/site-packages/openpyxl/descriptors/serialisable.py", line 87, in from_tree obj = desc.expected_type.from_tree(el) File "/usr/local/lib/python3.7/site-packages/openpyxl/descriptors/serialisable.py", line 87, in from_tree obj = desc.expected_type.from_tree(el) File "/usr/local/lib/python3.7/site-packages/openpyxl/descriptors/serialisable.py", line 103, in from_tree return cls(**attrib) File "/usr/local/lib/python3.7/site-packages/openpyxl/styles/alignment.py", line 50, in __init__ self.vertical = vertical File "/usr/local/lib/python3.7/site-packages/openpyxl/descriptors/base.py", line 143, in __set__ super(NoneSet, self).__set__(instance, value) File "/usr/local/lib/python3.7/site-packages/openpyxl/descriptors/base.py", line 128, in __set__ raise ValueError(self.__doc__) ValueError: Value must be one of {'top', 'justify', 'bottom', 'center', 'distributed'}