christhedonstar
Programmer
Hi,
I would like to do the following:
1) Take an xml file into Excel and display as range/table
2) Update or amend to that range/table
3) Save down the xml file and in exactly the same format as before
The caveats/points:
1) The XML format that comes out must be exactly the same as what it started of like. I.e. no extra office lines automatically added, no change of tag names etc.
2) NB The input XML format will always be the same. (Generalisation would be good/appreiciated, but not neccessary in this instance)
What possible solutions do I have? What is the simplest? Which one would be the least code? Any third party software suggestions should be FREE/opensource. Although I'd like to stay away from them if possible. C# type solutions with Excel also welcome (I have got some c# code that de/serialises the xml into a file)
Thanks,
Chris
I would like to do the following:
1) Take an xml file into Excel and display as range/table
2) Update or amend to that range/table
3) Save down the xml file and in exactly the same format as before
The caveats/points:
1) The XML format that comes out must be exactly the same as what it started of like. I.e. no extra office lines automatically added, no change of tag names etc.
2) NB The input XML format will always be the same. (Generalisation would be good/appreiciated, but not neccessary in this instance)
What possible solutions do I have? What is the simplest? Which one would be the least code? Any third party software suggestions should be FREE/opensource. Although I'd like to stay away from them if possible. C# type solutions with Excel also welcome (I have got some c# code that de/serialises the xml into a file)
Thanks,
Chris
