Powershell - Bestimmte Daten aus Excel in neue Excel-Dateien in letzter freien Zeile schreiben und speichern

#Define locations and delimiter
$csv = "C:\Users\Hannes\Desktop\200319_10000_ProjektDaten_TXT_Datei" +".csv" #Location of the source file  
$xlsx = "C:\Users\Hannes\Desktop\CSV_TEST\Logs\Projektliste_Gesamt_Neu" +".xlsx" #Desired location of output  
$delimiter = ";" #Specify the delimiter used in the file  

# Create a new Excel workbook with one empty sheet
$excel = New-Object -ComObject excel.application 
#$workbook = $excel.Workbooks.Add(1)
$workbook = $excel.Workbooks.open($xlsx)
$worksheet = $workbook.worksheets.Item(1)

# Build the QueryTables.Add command and reformat the data
$TxtConnector = ("TEXT;" + $csv)  
$Connector = $worksheet.QueryTables.add($TxtConnector,$worksheet.Range("A2"))  
$query = $worksheet.QueryTables.item($Connector.name)
$query.TextFileOtherDelimiter = $delimiter
$query.TextFileParseType  = 1
$query.TextFileColumnDataTypes = ,1 * $worksheet.Cells.Columns.Count
$query.AdjustColumnWidth = 1

# Execute & delete the import query
$query.Refresh()
$query.Delete()

# Save & close the Workbook as XLSX.
$excel.DisplayAlerts = $False
$Workbook.SaveAs($xlsx,51)
$excel.Quit()