BAT file that copies XML cells to excel

[tsokid]

Hello everyone.

I have the below issue.

Three XML files that I need to copy their contents into a One New Excel File with 3 sheets of the same name.

Source Filenames:
Main-list-details.xml
alllists.xml
campaigns.xml

Target Filename:
Report.xlsx

Is this possible??

BR

[ShadowThief]

It's technically possible since .xlsx files are just archives containing xml files, but you really, really, really don't want to do it this way. I seriously can't stress enough how much editing an .xlsx file with a text editor sucks.

You definitely want to use vbscript for this instead, since that can manipulate Excel files.