Value error when loading file with pivot table grouped by range
With version 3.0.7
When opening attached file, the following error is raised:
workbook = openpyxl.load_workbook(filename=transfer_path, keep_vba=True)
File "C:\Users\BoBob\AppData\Local\Programs\Python\Python38\lib\site-packages\openpyxl\reader\excel.py", line 317, in load_workbook
reader.read()
File "C:\Users\BoBob\AppData\Local\Programs\Python\Python38\lib\site-packages\openpyxl\reader\excel.py", line 282, in read
self.read_worksheets()
File "C:\Users\BoBob\AppData\Local\Programs\Python\Python38\lib\site-packages\openpyxl\reader\excel.py", line 269, in read_worksheets
pivot.cache = self.parser.pivot_caches[pivot.cacheId]
File "C:\Users\BoBob\AppData\Local\Programs\Python\Python38\lib\site-packages\openpyxl\reader\workbook.py", line 121, in pivot_caches
cache = get_rel(self.archive, self.rels, id=c.id, cls=CacheDefinition)
File "C:\Users\BoBob\AppData\Local\Programs\Python\Python38\lib\site-packages\openpyxl\packaging\relationship.py", line 168, in get_rel
obj = cls.from_tree(tree)
File "C:\Users\BoBob\AppData\Local\Programs\Python\Python38\lib\site-packages\openpyxl\descriptors\serialisable.py", line 83, in from_tree
obj = desc.from_tree(el)
File "C:\Users\BoBob\AppData\Local\Programs\Python\Python38\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\BoBob\AppData\Local\Programs\Python\Python38\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\BoBob\AppData\Local\Programs\Python\Python38\lib\site-packages\openpyxl\descriptors\serialisable.py", line 87, in from_tree
obj = desc.expected_type.from_tree(el)
File "C:\Users\BoBob\AppData\Local\Programs\Python\Python38\lib\site-packages\openpyxl\descriptors\serialisable.py", line 87, in from_tree
obj = desc.expected_type.from_tree(el)
File "C:\Users\BoBob\AppData\Local\Programs\Python\Python38\lib\site-packages\openpyxl\descriptors\serialisable.py", line 103, in from_tree
return cls(**attrib)
File "C:\Users\BoBob\AppData\Local\Programs\Python\Python38\lib\site-packages\openpyxl\pivot\cache.py", line 683, in __init__
self.groupBy = groupBy
File "C:\Users\BoBob\AppData\Local\Programs\Python\Python38\lib\site-packages\openpyxl\descriptors\base.py", line 128, in __set__
raise ValueError(self.__doc__)
ValueError: Value must be one of {'months', 'quarters', 'hours', 'seconds', 'years', 'range', 'minutes', 'days'}