Adding XML Source to xlsx file in python

Question

I am trying to create a xlsx from a template exported from Microsoft dynamics NAV, so I can upload my file to the system.

I am able to recreate and fill the template using the library xlsxwriter, but unfortunately I have figured out that the template file also have an attached XML source code file(visible in the developer tab in Excel).

I can easily modify the XML file to match what I want, but I can't seem to find a way to add the XML source code to the xlsx file. I have searched for "python adding xlsx xml source" but it doesn't seem to give me anything I can use.

Any help would be greatly appreciated.

Best regards Martin

Xlsx file is basically a zip archive. Open it as archive and you'll probably be able to find the XML file and modify it. — Mak Sim
– Mak Sim, Commented Jan 11, 2022 at 13:37
I wish I could mark your comment as the answer. It has led me to solving my issues. — Martin Pedersen
– Martin Pedersen, Commented Jan 12, 2022 at 19:51

Martin Pedersen · Accepted Answer · 2022-01-12 19:52:18Z

2

Xlsx file is basically a zip archive. Open it as archive and you'll probably be able to find the XML file and modify it. – Mak Sim yesterday

answered Jan 12, 2022 at 19:52

Martin Pedersen

1731 silver badge12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Adding XML Source to xlsx file in python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related