Unable to open file - font family 34
/usr/local/bin/python3.7 "/Users/obow/Dropbox/Coding/Python/Marksheet Parser/parser.py"
Traceback (most recent call last):
File "/Users/obow/Dropbox/Coding/Python/Marksheet Parser/parser.py", line 161, in <module>
main()
File "/Users/obow/Dropbox/Coding/Python/Marksheet Parser/parser.py", line 35, in main
markbook_data = read_markbook()
File "/Users/obow/Dropbox/Coding/Python/Marksheet Parser/parser.py", line 49, in read_markbook
wb = load_workbook(filename=input_file)
File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/openpyxl/reader/excel.py", line 315, in load_workbook
reader.read()
File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/openpyxl/reader/excel.py", line 279, in read
apply_stylesheet(self.archive, self.wb)
File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/openpyxl/styles/stylesheet.py", line 192, in apply_stylesheet
stylesheet = Stylesheet.from_tree(node)
File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/openpyxl/styles/stylesheet.py", line 102, in from_tree
return super(Stylesheet, cls).from_tree(node)
File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/openpyxl/descriptors/serialisable.py", line 83, in from_tree
obj = desc.from_tree(el)
File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/openpyxl/descriptors/sequence.py", line 85, in from_tree
return [self.expected_type.from_tree(el) for el in node]
File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/openpyxl/descriptors/sequence.py", line 85, in <listcomp>
return [self.expected_type.from_tree(el) for el in node]
File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/openpyxl/styles/fonts.py", line 109, in from_tree
return super(Font, cls).from_tree(node)
File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/openpyxl/descriptors/serialisable.py", line 103, in from_tree
return cls(**attrib)
File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/openpyxl/styles/fonts.py", line 75, in __init__
self.family = family
File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/openpyxl/descriptors/nested.py", line 35, in __set__
super(Nested, self).__set__(instance, value)
File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/openpyxl/descriptors/base.py", line 108, in __set__
super(Min, self).__set__(instance, value)
File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/openpyxl/descriptors/base.py", line 87, in __set__
raise ValueError('Max value is {0}'.format(self.max))
ValueError: Max value is 14
Process finished with exit code 1
I looked at the frames in PyCharm and pasted the values below that seem to be causing the problem. Something to do with that family value of 34 being higher than 14. What does that refer to?
b = {NoneType} None
bold = {NoneType} None
charset = {NoneType} None
color = {Color} <openpyxl.styles.colors.Color object>\nParameters:\nrgb='FF000000', indexed=None, auto=None, theme=None, tint=0.0, type='rgb'
condense = {NoneType} None
extend = {NoneType} None
family = {str} '34'
i = {NoneType} None
italic = {NoneType} None
name = {str} 'Century Gothic'
outline = {NoneType} None
scheme = {NoneType} None
self = {Font} <openpyxl.styles.fonts.Font object>\nParameters:\nname='Century Gothic', charset=None, family=None, b=None, i=None, strike=None, outline=None, shadow=None, condense=None, color=None, extend=None, sz=None, u=None, vertAlign=None, scheme=None
shadow = {NoneType} None
size = {NoneType} None
strike = {NoneType} None
strikethrough = {NoneType} None
sz = {str} '11'
u = {NoneType} None
underline = {NoneType} None
vertAlign = {NoneType} None
Looking in the xml that is passed in I guess this is the issue.
<font>
<sz val="11"/>
<color rgb="FF000000"/>
<name val="Century Gothic"/>
<family val="34"/>
</font>
<font>
<b/>
<sz val="11"/>
<color rgb="FF000000"/>
<name val="Century Gothic"/>
<family val="34"/>
</font>