Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
03-20-2017, 08:41 AM #1
- Join Date
- Mar 2017
- Thanked 0 Times in 0 Posts
Excel to XML with Python_Batch processing
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!!