Merging multiple csv into one excel without excel installed

See more:

PowerShell

I am working on a script where I am trying to merge multiple csv into single excel file with csv filename as different sheet.

All the csv's are having same number of columns and name.

I don't have excel installed in my server so written below code using ImportExcel

What I have tried:

#Install-Module ImportExcel -scope CurrentUser
$path="C:\Scripts" #target folder
cd $path;
$csvs = Get-ChildItem .\* -Include *.csv
$csvCount = $csvs.Count
Write-Host "Detected the following CSV files: ($csvCount)"
foreach ($csv in $csvs) {
    Write-Host " -"$csv.Name
}

$excelFileName = $path + "\" + $(get-date -f yyyyMMdd) + "_combined-data.xlsx"
Write-Host "Creating: $excelFileName"

foreach ($csv in $csvs) {
    $csvPath = $path + $csv.Name
    $worksheetName = $csv.Name.Replace(".csv","")
    Write-Host " - Adding $worksheetName to $excelFileName"
    Import-Csv -Path $csvPath | Export-Excel -Path $excelFileName -WorkSheetname $worksheetName

The script is taking time and executing without any issue but the excel sheet is not generating.

Please can you help me with the issue in the script.