I would like to generate an xml file from a Microsoft Excel Spreadsheet...
The XML file should look like so...
<?xml version="1.0" encoding="utf-8"?>
<company currentbalance="" creditlimit="" availablebalance="" creditdecision=""></company>
currentbalance, creditlimit, availablebalance, creditdecision and company will all be pulled from an Excel spreadsheet.
The company names need to be pulled from column C starting from Row 9 until there is no content.
The currentbalance from coloumn D down to where coloumn C stops.
The creditlimit comes from coloumn E down to where coloumn C stops.
The availablebalance comes from coloumn F down to where coloumn C stops.
The creditdecision comes from coloumn K down to where coloumn C stops.
I dont mind how this is done. C# would be preferred but vb, vbs or batch scripting are fine too.
Thanks in advance!