XLSX format incompatibility

[yarilko]

Hello! I cannot open the XLSX file saved in PlanMaker by openpyxl

The problem is exactly described earlier in this thread:
https://bitbucket.org/openpyxl/openpyxl ... unexpected


Here is my output:
> python ny-from-xlsx.py --src ./filename.xlsx --appendyml ny-mr6.5.3.yml
ny-from-xlsx.py:23: YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details.
endyml = (yaml.load(stream))
Traceback (most recent call last):
File "ny-from-xlsx.py", line 31, in <module>
wb = load_workbook(filename=sourcefile)
File "/usr/local/lib/python2.7/site-packages/openpyxl/reader/excel.py", line 312, in load_workbook
reader.read()
File "/usr/local/lib/python2.7/site-packages/openpyxl/reader/excel.py", line 273, in read
apply_stylesheet(self.archive, self.wb)
File "/usr/local/lib/python2.7/site-packages/openpyxl/styles/stylesheet.py", line 189, in apply_stylesheet
stylesheet = Stylesheet.from_tree(node)
File "/usr/local/lib/python2.7/site-packages/openpyxl/styles/stylesheet.py", line 103, in from_tree
return super(Stylesheet, cls).from_tree(node)
File "/usr/local/lib/python2.7/site-packages/openpyxl/descriptors/serialisable.py", line 84, in from_tree
obj = desc.from_tree(el)
File "/usr/local/lib/python2.7/site-packages/openpyxl/descriptors/sequence.py", line 86, in from_tree
return [self.expected_type.from_tree(el) for el in node]
File "/usr/local/lib/python2.7/site-packages/openpyxl/styles/fills.py", line 64, in from_tree
return PatternFill._from_tree(child)
File "/usr/local/lib/python2.7/site-packages/openpyxl/styles/fills.py", line 102, in _from_tree
return cls(**attrib)
TypeError: __init__() got an unexpected keyword argument 'extLst'


Is it possible to adjust the XLSX format and make it like MS or Google office have to process the file externally?

[martin-k]

PlanMaker does some things better than Excel, and we need to store this as additional data in our files. Since XLSX is a first-class file format for PlanMaker, our customers expect that it stores everything that PlanMaker can do.

Excel does not have a problem with this additional information, only this Python library does. We cannot "dumb down" our XLSX files just to make the developer of this library happy because this would frustrate many of our customers. If Excel is happy with our files, then this Python library should, too.