I am not sure on how to take an excel file and transform it into xml. But if you want to take an existing xml file and transform it into XML, then you have to create a xsl file with a looping statement and then attach the xsl file to your xml file.
Here is an example of your xml file
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="test.xsl"?>
<Root>
<Element1>A</Element1>
<Element2>B</Element2>
<Element3>C</Element3>
</Root>
Here is an example of your xsl file
<?xml version='1.0'?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/TR/WD-xsl">
<xsl:template match="/">
<html>
<body>
<table border="1">
<xsl:for-each select="StoreExport/Products/Product">
<tr>
<td><xsl:value-of select="Element1"/></td>
<td><xsl:value-of select="Element2"/></td>
<td><xsl:value-of select="Element3"/></td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
1
