34 lines
832 B
Plaintext
34 lines
832 B
Plaintext
## Create a CSV file
|
|
@"
|
|
C1,C2,C3,C4,C5
|
|
1,5,9,13,17
|
|
2,6,10,14,18
|
|
3,7,11,15,19
|
|
4,8,12,16,20
|
|
"@ -split "`r`n" | Out-File -FilePath .\Temp.csv -Force
|
|
|
|
## Import each line of the CSV file into an array of PowerShell objects
|
|
$records = Import-Csv -Path .\Temp.csv
|
|
|
|
## Sum the values of the properties of each object
|
|
$sums = $records | ForEach-Object {
|
|
[int]$sum = 0
|
|
foreach ($field in $_.PSObject.Properties.Name)
|
|
{
|
|
$sum += $_.$field
|
|
}
|
|
$sum
|
|
}
|
|
|
|
## Add a column (Sum) and its value to each object in the array
|
|
$records = for ($i = 0; $i -lt $sums.Count; $i++)
|
|
{
|
|
$records[$i] | Select-Object *,@{Name='Sum';Expression={$sums[$i]}}
|
|
}
|
|
|
|
## Export the array of modified objects to the CSV file
|
|
$records | Export-Csv -Path .\Temp.csv -Force
|
|
|
|
## Display the object in tabular form
|
|
$records | Format-Table -AutoSize
|