I have a task where I need to generate a bunch of individual xml files based on data in an excel spreadsheet. The outputted xml is well defined in that there are a set of instructions that each individual xml file requires.
For example, the requirements include:
If Column F is empty, pass. If it contains a Value, proceed.
Take house Number from Column T & Enter into Filename.
Open XML Record.
Take house Number + "_SP" from Column T & Enter into and all attributes.
Essentially it will need to make a new .xml file for each row in the excel sheet with a value in column F.
I have previously used Visual Studio to do data transformation, but have been unable to find anything regarding producing xml files from VS. Is VS a good tool for this task?
Or is there a better option?