<div>
Forced accept.<br />
<br />
Computer101<br />
EE Admin
</div>


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


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=""></company>
</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!

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...

&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;
&lt;companys&gt;
  &lt;company currentbalance=&quot;&quot; creditlimit=&quot;&quot; availablebalance=&quot;&quot; creditdecision=&quot;&quot;&gt;&lt;/company&gt;
&lt;/company&gt;

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!

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Batch files are text files containing a script of commands that are executed by the command interpreter on DOS, OS/2 and Windows systems. Most commonly, they are used to perform a series of functions that are repeated -- copying a set of files created daily with one step, for example.

Windows Batch

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.