Powersell Script for Converting CSV to Excel File

  1. $FileName = "$env:temp\Report"  
  2. # create some CSV data  
  3. Get-Process | Export-Csv -UseCulture -Path "$FileName.csv" -NoTypeInformation -Encoding UTF8  
  4. # load into Excel  
  5. $excel = New-Object -ComObject Excel.Application  
  6. $excel.Visible = $true  
  7. $excel.Workbooks.Open("$FileName.csv").SaveAs("$FileName.xlsx",51)  
  8. $excel.Quit()  
  9. explorer.exe "/Select,$FileName.xlsx"