Create a program to combine multiple XML file and convert it to an XLSX file

Create a program to combine multiple XML file and convert it to an XLSX file
for example, inside a folder there has few type of the xml files named A and B and C etc
eg A-00000.xml A-00001.xml - A-99999.xml up to ~90000 xml
B-00000.xml B-00001.xml - B-99999.xml up to ~90000 xml
convert / combine A-00000.xml to- A-99999.xml data into a xlsx file in A sheet tab
also same B-00000.xml - B-99999.xml data will combine into same xlsx file in B sheet tab

- error handling -
in some cases some of the xml files maybe collapsed (incomplete info/empty)
require the batch script scan the xml files and show up the xml file name which is broken and not able to combine/convert
name of the xml which is broken.

- how to use the batch exe -
ideal is cmd, exe + 2 variable . first one is the source folder , second one is the xlsx output folder
eg, C:\Users\Tom>xml2xlsx.exe "C:\XMLfolder" "C:\XMLfolder\xlsx_output"
get the xml from "C:\XMLfolder" and output to "C:\XMLfolder\xlsx_output"