This post provides a simple example of how we can export data to a CSV and maintain the column order:
$csvFile = "c:\temp\alkane.csv"
$exampledata = @(@("John","37"),@("Peter","14"),@("Michelle","22"),@("Abdul","31"),@("Roger","22"),@("Rachel","50"))
$csvwrapper = @()
foreach($person in $exampledata) {
$name = $person[0]
$age = $person[1]
#append to a wrapper which we export to CSV at the end (Name and Age are the column names we want in the CSV)
$csvwrapper += New-Object PSObject -Property @{
Name = $name;
Age = $age;
}
}
$csvwrapper |
Select Name, Age | #we pipe our wrapper into this so we can define the order we want our columns to display in the CSV
Export-Csv -Path $csvFile -NoTypeInformation
