4.1.2 Merge multiple XML files and convert to Excel(XLS) using the command line

Excel uses a smart merge technology to automatically merge data from multiple XML files. This comes in very handy if you have similar data in many XML files (maybe you receive this everyday), and you need to convert data in these XML files to a single Excel spreadsheet.

The conversion is very simple: just list out all the XML files you need to merge and extract to Excel. In the following example, sales data for each month is merged and extracted to an XLS file.

Exultcmd.exe -t XLS -f sales.xls -w sales-062007.xml sales-072007.xml sales-082007.xml

Soon gets tedious if you need to explicitly list out all the XML files for conversion. Just use a wildcard.

Exultcmd.exe -t XLS -f sales.xls -w sales*.xml

What if you need to merge all XML files in a directory and extract to Excel?

Exultcmd.exe -t XLS -f sales.xls -w C:\Dir\*.xml

How about merging XML files in multiple directories? Follow this example:

Exultcmd.exe -t XLS -f sales.xls -w C:\DirA\*.xml C:\DirB\*.xml