Python Script for Excel to XML Conversion

I need a Python script that converts a specific Excel file into an XML format for data migration purposes. The Excel file is a spreadsheet, with nested data beyond the columns reflecting the structure of the XML The resulting XML file must reflect this complexity and contain hierarchical elements with nested data. The spreadsheet will be continuously expanded and should incorporate the additions in the Excel into the XML. Alternatively, it can be completely rewritten.

Ideal skills are:
- Proficiency with Python, particularly libraries useful for Excel and XML manipulation (such as pandas and xml.etree.ElementTree).
- Strong understanding of data structures and hierarchies.
- Experience with data migration processes.

Please provide examples of similar projects you have completed in the past.


Translated with www.DeepL.com/Translator (free version)