XLSX format incompatibility

Post your questions, bug reports and suggestions here for PlanMaker 2018 for Mac.

Moderator: SoftMaker Team

Post Reply
yarilko
Posts: 3
Joined: Tue Apr 16, 2019 11:00 am

XLSX format incompatibility

Post by yarilko » Tue Apr 30, 2019 1:50 pm

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
SoftMaker Team
SoftMaker Team
Posts: 2921
Joined: Fri Nov 21, 2003 4:57 pm
Location: Nürnberg, Germany
Contact:

Re: XLSX format incompatibility

Post by martin-k » Mon May 13, 2019 1:45 pm

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.
Martin Kotulla
SoftMaker Software GmbH

Post Reply

Return to “PlanMaker 2018 for Mac”