Hi All
I am writing a csv file and then trying to put it in an existing excel file. I am using ImportExcel and PSExcel modules
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
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"")"
Error
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
Can you please tell me what is the issue? Is it the data which I am trying to write to csv?