Planmaker 2024 and openpyxl

Post Reply
louyo
Posts: 6
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: 3102
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: 6
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 31 times
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 3102
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: 6
Joined: Tue May 16, 2023 4:34 pm

Re: Planmaker 2024 and openpyxl

Post by louyo »

What keywords, may I ask?
Post Reply

Return to “PlanMaker NX and 2024 for Linux”