Planmaker 2024 and openpyxl

Post Reply
louyo
Posts: 7
Joined: Tue May 16, 2023 4:34 pm

Planmaker 2024 and openpyxl

Post by louyo »

Planmaker 2024, Linux, debian 12. I created a vanilla spreadsheet and saved it to .xlsx. I copied it to a system that doesn't have Planmaker. When I try to read/edit it with openpyxl library in Python, it gets an error. "TypeError: PatternFill.__init__() got an unexpected keyword argument 'extLst'".
If I run it through Libreoffice Calc, it offers to modify it for 2007-365. I can then manipulate it with Python.
Is there a way to make Planmaker save in a compatible format?
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 3196
Joined: Wed Mar 11, 2020 5:31 pm

Re: Planmaker 2024 and openpyxl

Post by SuperTech »

Thank you for reporting this problem. I have forwarded the details.

Please share that problematic file which you created with PlanMaker and giving error so that we can check it at our end.

If your file is private, please send it to forum[at]softmaker.com with the link of this post.
louyo
Posts: 7
Joined: Tue May 16, 2023 4:34 pm

Re: Planmaker 2024 and openpyxl

Post by louyo »

Not very complex. :)
from openpyxl import load_workbook
workbook = load_workbook(filename="test4py2.xlsx")
TypeError: PatternFill.__init__() got an unexpected keyword argument 'extLst'
Attachments
test4py2.xlsx
(5.79 KiB) Downloaded 252 times
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 3196
Joined: Wed Mar 11, 2020 5:31 pm

Re: Planmaker 2024 and openpyxl

Post by SuperTech »

Thank you for sharing the file. This problem is in openpyxl libraries, as it's unable to handle the keywords from the file. Ideally, it should skip the unknown keywords. So, we can't do anything here. :(
louyo
Posts: 7
Joined: Tue May 16, 2023 4:34 pm

Re: Planmaker 2024 and openpyxl

Post by louyo »

What keywords, may I ask?
louyo
Posts: 7
Joined: Tue May 16, 2023 4:34 pm

Re: Planmaker 2024 and openpyxl

Post by louyo »

No answer? Figures. Odd that the same spreadsheet opened and saved with Libreoffice is OK.
Still would like to know which keywords I need to change.
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 3196
Joined: Wed Mar 11, 2020 5:31 pm

Re: Planmaker 2024 and openpyxl

Post by SuperTech »

There are no keywords you can change, but the keywords from file format which openpyxl should ignore.
Woody44
Posts: 593
Joined: Wed May 22, 2019 11:56 pm

Re: Planmaker 2024 and openpyxl

Post by Woody44 »

The sample file also opens in Excel 2019, so there's nothing wrong with PlanMaker's implementation of the .xlsx file format.
petermross
Posts: 16
Joined: Sat Sep 13, 2008 1:08 pm

Re: Planmaker 2024 and openpyxl

Post by petermross »

I believe this is a minor problem with openpyxl rather than with any version of planmaker. I use openpyxl a lot and whenever I upgrade that package I have to edit the source file [somehere on your system]/ openpyxl/styles/fills.py. In the class PatternFill, find the def __init__ and add this:
, extLst=None
as the final argument, just after end_color=None. It is the absence of a default value for the parameter extLst that causes the error. I do wish that the developers of openpyxl would fix that!
Post Reply

Return to “PlanMaker NX and 2024 for Linux”