Antonio King
asked on
Convert Specific columns to specific nodes (XLS to XML)
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"?>
<companys>
<company currentbalance="" creditlimit="" availablebalance="" creditdecision=""></compan y>
</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!
The XML file should look like so...
<?xml version="1.0" encoding="utf-8"?>
<companys>
<company currentbalance="" creditlimit="" availablebalance="" creditdecision=""></compan
</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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Computer101
EE Admin