Error while writing data to csv and exporting to existing excel

See more:

PowerShell

I am writing a csv file and then trying to put it in an existing excel file

While executing getting the below error. it is generating the csv

csv data

"Index"
"=HYPERLINK(""#10.124.0.0_27!A3"",""10.124.0.0_27"")"
"=HYPERLINK(""#10.124.0.32_27!A4"",""10.124.0.32_27"")"
"=HYPERLINK(""#10.124.0.64_27!A5"",""10.124.0.64_27"")"
"=HYPERLINK(""#10.124.1.0_26!A6"",""10.124.1.0_26"")"
"=HYPERLINK(""#10.124.1.128_26!A7"",""10.124.1.128_26"")"
"=HYPERLINK(""#10.124.1.192_26!A8"",""10.124.1.192_26"")"

Add-Worksheet : The input object cannot be bound to any parameters for the command either because the command does not take pipeline input or the input and its 
properties do not match any of the parameters that take pipeline input.
At C:\Program Files\WindowsPowerShell\Modules\ImportExcel\7.2.2\Public\Export-Excel.ps1:129 char:26
+             $ws = $pkg | Add-Worksheet @params
+                          ~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidArgument: (OfficeOpenXml.ExcelPackage:PSObject) [Add-Worksheet], ParameterBindingException
    + FullyQualifiedErrorId : InputObjectNotBound,Add-Worksheet
 
Could not get worksheet Index
At C:\Program Files\WindowsPowerShell\Modules\ImportExcel\7.2.2\Public\Export-Excel.ps1:135 char:16
+         catch {throw "Could not get worksheet $WorksheetName"}
+                ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : OperationStopped: (Could not get worksheet Index:String) [], RuntimeException
    + FullyQualifiedErrorId : Could not get worksheet Index

Please let me know what is the issue with this line

Import-Csv -Path "E:\Index.csv" | Export-Excel -Path "E:\ipaddress.xlsx" -WorkSheetname 'Index' -MoveToStart

What I have tried:

foreach($data in $WorkSheetNames)
{
    $obj = New-Object PSObject
    $final_data ="=HYPERLINK(`"#" + $data + "!A" +$count + """"+ "," + """" + "$data" + """)"

    if($final_data -match "Index")
    {
    }
    else
    {
    Add-Member -InputObject $obj -MemberType NoteProperty -Name "Index" -Value $final_data
    }
    $table +=$obj
    $count++
    
}
$table | Export-Csv -Path "E:\Index.csv" -Append -NoTypeInformation
#=HYPERLINK("#10.124.0.0_27!A2","10.124.0.0_27")
Import-Csv -Path "E:\Index.csv" | Export-Excel -Path "E:\ipaddress.xlsx" -WorkSheetname 'Index' -MoveToStart