Convert csv to xlsx

csv2xlsx.ps1

$excel = New-Object -ComObject Excel.Application
$excel.Visible = $false


ForEach ($dir in $args) {
    Write-Output "Converting all csv to xlsx inside $(Resolve-Path $dir)..."
    Get-ChildItem -Path $(Resolve-Path $dir) | ForEach {
        if ($_.Extension -ne ".csv") {
            continue
        }
        Write-Output "Converting $_..."
        $workbook = $excel.Workbooks.Open("$(Resolve-Path $dir)\$_")
        $workbook.SaveAs("$(Resolve-Path $dir)\$($_.BaseName).xlsx", 51)

        # 51 here stands for Open XML Workbook format
        # https://docs.microsoft.com/en-us/office/vba/api/excel.xlfileformat

        $workbook.Close()
    }
}

$excel.Quit()