Saving Excel File as XML with PowerShell

Question

I'm currently writing a script in powershell that searches for XLS files recursivly through a file tree. I'd like to save all the files to xml to be able to read through them and change data as needed.

Is there anyway to save Excel files as XML with Powershell ?

Thanks for your help !

---- Update ----

I found a script here that creates an excel file and save it as an xml.

Using the same principle i did the following, which basically open a file and save it to xml:

$xlXMLSpreadsheet = 46

$Excel = New-Object -Com Excel.Application
 
$WorkBook = $Excel.Workbooks.Open("c:\Test.xlsx")
 
$WorkBook.SaveAs("c:\Test.xml", $xlXMLSpreadsheet)
 
$Excel.Quit()

And it works really well. But i wasnt aware of the second saveas() parameter.

xashcorex · Accepted Answer · 2023-10-16 13:56:06Z

5

I found a script here that create an excel file and save it as an xml.

Using the same principle i did the following, which basically open a file and save it to xml:

$xlXMLSpreadsheet = 46

$Excel = New-Object -Com Excel.Application
 
$WorkBook = $Excel.Workbooks.Open("c:\Test.xlsx")
 
$WorkBook.SaveAs("c:\Test.xml", $xlXMLSpreadsheet)
 
$Excel.Quit()

And it works really well. But i wasnt aware of the second saveas() parameter.

edited Oct 16, 2023 at 13:56

answered Mar 25, 2013 at 6:55

xashcorex

1341 gold badge3 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ansgar Wiechers · Accepted Answer · 2013-03-24 15:33:55Z

0

The general process of exporting an Excel sheet to XML is described here. You could record this as a macro and then adopt that into PowerShell. You could also hand-craft the XML from the data in the sheet(s). Either way you're going to need some kind of definition of how the data from the Excel sheet should be mapped into the XML structure.

answered Mar 24, 2013 at 15:33

Ansgar Wiechers

202k27 gold badges286 silver badges363 bronze badges

1 Comment

xashcorex Over a year ago

Thanks for your help :) I will try that.Nevertheless i guess there is a way to actually save a file as XML.

Collectives™ on Stack Overflow

Saving Excel File as XML with PowerShell

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related