convert csv to xlsx with excel

csv-to-xlsx.ps1

param(
  [parameter(mandatory=$true)]
  [string]$infile,

  [parameter(mandatory=$true)]
  [string]$outfile
)

# https://msdn.microsoft.com/en-us/vba/excel-vba/articles/workbook-saveas-method-excel

$xlOpenXMLWorkbook	= 51
$xlLocalSessionChanges = 2

$xl = New-Object -comobject excel.application
$wb = $xl.workbooks.open($infile)
#    SaveAs(FileName  , FileFormat         , Password , WriteResPassword , ReadOnlyRecommended , CreateBackup , AccessMode , ConflictResolution     , AddToMru , TextCodepage , TextVisualLayout , Local)
# $wb.saveas($outfile , $xlOpenXMLWorkbook , $Null    , $Null            , $Null               , $Null        , $Null      , $xlLocalSessionChanges , $Null    , $Null        , $Null            , $Null)
# I could never get the xlLocalSessionChanges to work out, so you just have to make sure the outfile doesn't exist yet (or you could add a line to delete it in in this script)

$wb.saveas($outfile , $xlOpenXMLWorkbook)
$wb.close($False)
$xl.quit()