BAT file that copies XML cells to excel

Discussion forum for all Windows batch related topics.

Moderator: DosItHelp

Post Reply
Message
Author
tsokid
Posts: 1
Joined: 25 May 2016 00:47

BAT file that copies XML cells to excel

#1 Post by tsokid » 25 May 2016 01:07

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
Expert
Posts: 1160
Joined: 06 Sep 2013 21:28
Location: Virginia, United States

Re: BAT file that copies XML cells to excel

#2 Post by ShadowThief » 25 May 2016 01:49

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.

Post Reply