first line getting added auto after running powershell script.

Question

first line getting added auto after running powershell script. I don't want this line to be added in excel data.

$Csv = @"  
Parameter,Status  
ComputerName, DDPC1  
one,1  
two,2  
three,3  
four,4  
five,5  
"@ | ConvertFrom-Csv  
  
$NewCSV = @"  
$($csv.Parameter -join ',')  
$($csv.Status -join ',')  
"@ | ConvertFrom-Csv  
  
  
$NewCSV |Export-Csv -Path C:\test.csv   

Answer 1

Hi @SURAJ KUMAR ,

just add -NoTypeInformation to the Export-Csv cmd in line 17:

$NewCSV | Export-Csv -Path C:\test.csv -NoTypeInformation  

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten