In powershell how to output an ArrayList to CSV

Question

I am trying to export an ArrayList object to a CSV file. The object is a list of 3 element arrays.

I have been trying something like the following however I just get information about the object (number of elements, length, etc).

$CsvArrayList | Export-Csv "./Output.csv"

Is it possible to output the values contained in an array list into csv format? Ideally one line per array and one element per cell.

You need to force your inner arrays to enumerate before sending to the CSV command. $csvarraylist | foreach-object {$_} | export-CSV output.csv -notype — AdminOfThings
– AdminOfThings, Commented Jan 27, 2020 at 3:32

mjsqu · Accepted Answer · 2020-01-27 03:12:37Z

1

You could create the CSV manually using -join, however this may be slow if there are lots of arrays:

$CSVArrayList = new-Object System.Collections.ArrayList

[void]$CSVArrayList.Add(@('1','2','3'))
[void]$CSVArrayList.Add(@('4','5','6'))

Set-Content "./Output.csv" -Value $null

Foreach ($arr in $CSVArrayList) {
      $arr -join ',' | Add-Content "./Output.csv"
}

answered Jan 27, 2020 at 3:12

mjsqu

5,4721 gold badge19 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

In powershell how to output an ArrayList to CSV

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