0

I have a process that generates some large XML files which I then import into Excel manually. I would like to automate this Excel sheet conversion using some type of command batch or script language like powershell but not sure if this is possible.

The manual steps in Excel are:

Data --> FormXML Data Import --> Browse for XML file --> Excel creates schema using existing XML table in workshee ($A$1) .

What's the best way to accomplish this?

Thanks in advance.

Geddon
  • 1,266
  • 1
  • 11
  • 31

1 Answers1

0

If you have a macro that once executed imports the XML into Excel then execute the macro via VBscript: Run Excel Macro from Outside Excel Using VBScript From Command Line

See here how to add a macro to import XML to Excel from VBA: Excel VBA import xml file

Community
  • 1
  • 1
AnalystCave.com
  • 4,884
  • 2
  • 22
  • 30