Read Excel file to XML

[thakral]

Hi

Was wondering if it is possible to create a XML file by reading its contents from an Excel file.

e.g.
<root>
<node1>Cell A7</node>
<node2>Cell A8</node>
<node3>Cell A9</node>
<node4>Cell A10</node>
<node5>Cell A11</node>
</root>

something similar to that ?
Any ideas ..
Thanks
anant

 

[jel]

First, have a look at:

http://msdn.microsoft.com/library/d...c_xl2003_ta/html/odc_xl_Excel2003XMLIntro.asp

(section "creating xml documents")
The article refers to excel 2003.

For older versions, you could do it programmaticly, for example in VB or VBA.
XML is 'just' plain text, so if you write a structure that loops through all rows and cells, you can easily generate xml.
One warning: string-concatenation in VB and VBA gets slower the longer the string gets. Therefore you should either write each node dirctly to file, or not concatenate at all and use MSXMLDom (add a node for each cell, etc).