automatic generation xml(vdx) file base on another xml file

Question

I need some help with generating XML files. I need to generate a new vdx file based on an original vdx file using some kind of template. New files must differ from orginal file only in one way, such as ID numbers. This distinction should be read from an xls file (every vdx file should be generated with anothed data). Which tools can help me with this task (is this possible using only XML code)?

Answer 1

Here are some steps to extract the data:

• Save each xsl file as xlsx
• Parse the unique identifiers from the resulting SpreadsheetML
• Save the extracted data in an XML file
• Transform the XML file to vdx using XSLT

References

• Reading Data from SpreadsheetML
• XLSX- how to get rid of the default namespace prefix x:?
• From SpreadsheetML Stylesheet
• Create and Process SpreadsheetML
• Transforming Open XML documents using XSLT