Mit Powershell Excel auslesen und in CSV schreiben

Add-Type -A Microsoft.Office.Interop.Excel
# Quelldatei
$excelfile = 'C:\temp\orders.xlsx'  
# Zieldatei
$csvfile = 'C:\temp\orders.csv'  
# -----
# Excel öffnen
$objExcel = New-Object -Com Excel.Application -Property @{
    # unsichtbar starten
    Visible = $false
    # Dialoge unterdrücken
    DisplayAlerts = $false
}
# Workbook öffnen
$wb = $objExcel.Workbooks.Open($excelfile)
# Erstes Worksheet auswählen
$ws = $wb.Sheets.Item(1)
# Gemeinsame Werte auslesen
$name = $ws.Range("B14:B15").Value() -join ' '  
$street = $ws.Range("B19").Value()  
$postalcode = $ws.Range("B20").Value()  
$city = $ws.Range("B21").Value()  
$country = $ws.Range("B22").Value()  
# Bestellungen auslesen
$orders = $ws.Range("A31:A" + $ws.Cells($ws.Rows.Count,"A").End([Microsoft.Office.Interop.Excel.XlDirection]::xlUp).Row) | %{  
    [pscustomobject][ordered]@{
        Name = $name
        Straße = $street
        PLZ = $postalcode
        Ort = $city
        Land = $country
        Artikel = $_.Offset(0,2).Value()
        Menge = $_.Offset(0,8).Value()
    }
}
# Bestellungen in CSV speichern
$orders | export-csv -LiteralPath $csvfile -Delimiter ";" -NoTypeInformation -Encoding UTF8  
# Mappe und Excel schließen
$wb.Close($false)
$objExcel.DisplayAlerts = $true
$objExcel.Quit()
# COM-Müll zur Tonne bringen
[void][System.Runtime.InteropServices.Marshal]::ReleaseComObject($objExcel)