Copy Excel to CSV with PowerShell
Having opened up the same Excel spreadsheet to save the data as a CSV for the third time, I wrote a PowerShell script to do it for me.
Simply set the source and destination files and the script takes care of the rest.
& { $sourceFile = "C:\Temp\data.xlsx" $outFile = "C:\Temp\data.csv" $excelApplication = New-Object -ComObject Excel.Application try { $excelApplication.visible = $false; $excelApplication.DisplayAlerts = $false $workbook = $excelApplication.Workbooks.Open($sourceFile) $workbook.WorkSheets.item("MySheetName").Activate() $workbook.SaveAs($outFile, [Microsoft.Office.Interop.Excel.XlFileFormat]::xlCSV) $workbook.Close() } finally { $excelApplication.Quit() } }
Written by Steve Fenton on