Anybody know a way to convert a spreadsheet into an XML document, where the column headings are the markup tags? Or point me me in the direction of maybe figuring this out?
we ended up having to use a different workflow so i don't need help on this anymore, but the excel file would be a native .xls sheet, and i wanted to turn that into an xml with each row as a record with the column headings as markup, like:
<record>
<heading1>data</heading1>
<heading2>data</heading2>
<heading3>data</heading3>
</record>
<record>
<heading1>another</heading1>
<heading2>another</heading2>
<heading3>another</heading3>
</record>
if someone knows a simple way though i'd still be interested