powershell export csv add header?

Question

 $employees = @()

#Add newly created object to the array
#$employees += $employee
for ($i=1;$i -le 2;$i++)
{
    $employee = New-Object System.Object
    $employee | Add-Member -MemberType NoteProperty -Name "Creation Time" -Value $(Get-date)
    $employee | Add-Member -MemberType NoteProperty -Name "Employee ID" -Value $($i.ToString("D2"))
    $employees += $employee
    Start-Sleep -Seconds 1
}


#Finally, use Export-Csv to export the data to a csv file
$employees | Export-Csv -NoTypeInformation -Path "c:\temp\test\EmployeeList.csv"

the result is

Creation Time     Employee ID

2014/10/14 1530      1

2014/10/14 1530      2

2014/10/14 1532      1

2014/10/14 1532      2

how can add the header...for examples

report<--title

Creation Time       Employee ID

2014/10/14 1530      1

2014/10/14 1530      2

2014/10/14 1532      1

2014/10/14 1532      2

Raf · Accepted Answer · 2014-10-16 08:48:38Z

1

It is not possible using Export-Csv cmdlet. You have to read the file into temp variable, write the header line and add csv content:

$csvPath = "c:\temp\test\EmployeeList.csv"
$eList = gc $csvPath
echo "report<--title" > $csvPath
$eList >> $csvPath

edited Oct 16, 2014 at 8:48

answered Oct 14, 2014 at 9:17

Raf

10.2k1 gold badge34 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

powershell export csv add header?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related