<properties>
<entry key="type">exSafe:Nocontract</entry>
<entry key="aspects">cm:version,cm:title,cm:own,cm:author</entry>
<entry key="cm:creator">1122334455</entry>
<entry key="cm:autoVersion">true</entry>
<entry key="cm:title">XXXXXXXXXXXXXXX</entry>
<entry key="cm:modifier">1122334455</entry>
<entry key="cm:created">2013-07-28T08:30:51.000+01:00</entry>
<entry key="gwSafe:contractCustVend">XXXXXXXXXXXXXXXXXXX999</entry>
</properties>
I have following XML file and I would like to convert them into Excel file through PowerShell, Can anyone help me, please?
Here is what I have so far:
[xml]$inputFile = Get-Content "k1.xml"
#export xml as csv
$inputFile.Sites.ChildNodes | Export-Csv "k1.csv" -NoTypeInformation -Delimiter:";" -Encoding:UTF8
[xml]$inputFile = Get-Content "k1.xml" #export xml as csv $inputFile.Sites.ChildNodes | Export-Csv "k1.csv" -NoTypeInformation -Delimiter:";" -Encoding:UTF8Even I have tried to convert the XML file into CSV, but that did not work too.