使用Powershell将XML转换为Excel

$xmlData = Import-Clixml -Path "path/to/xml/file.xml"

$excel = New-Object -ComObject Excel.Application
$workbook = $excel.Workbooks.Add()
$worksheet = $workbook.Worksheets.Item(1)

$row = 1
foreach ($item in $xmlData) {
    $column = 1
    foreach ($property in $item.PSObject.Properties) {
        $worksheet.Cells.Item($row, $column) = $property.Value
        $column++
    }
    $row++
}

$workbook.SaveAs("path/to/excel/file.xlsx")
$workbook.Close()
$excel.Quit()