I really need some help. I am a relatively new Python programmer, and a little bit familiar with XML. I have been tasked with creating an XML file from an Excel spreadsheet. The structure of the XML file is set by my vendor. I have a sample XML file, but I am not sure how to progress.

What basically I need to do is in my XML file there are some attributes in columns that need to be updated and XML is generated at the end of each column data. I can provide my XML code and Excel sheet.

I just need to learn how to do the batch processing by importing Excel column data in the XML attributes and generate in large numbers.(but truthfully, I don't know how to script that).

I am not opposed to doing the work, and I would love to actually learn how to do this, but I could really use some assistance.

Thanks in advance!!