Script for reading values from file and writing them to another file

I want a script in python/batch file/vb script that reads values from an excel sheet and then writes the value to a particular tag in the xml file.

e.g The column A of the excel sheet contains 7 colors i,e Violet Indigo Blue Green Yellow Orange Red

I want the script to read the excel sheet, take first value i.e. ‘Violet’ then search in the xml for the tag < color> < /color>* and write this value inside the tag. So, now my xml will have < color> Violet < /color>. Similarly the tool writes all the color values in xml till the loop ends.

Any possible solution to achieve this? I have no idea as to how to start. If possible, kindly provide any hint/url from where I can start.

I want this in Windows OS.