ConvertTo-OfficeCsv

Examples

Convert objects to CSV text.

PS>$csv = $data | ConvertTo-OfficeCsv
        

Generates CSV text from the input objects.

Export with a stable schema order.

PS>$rows = @(
[ordered]@{ Id = 1; Name = 'Alpha'; Total = 10.5 },
[ordered]@{ Id = 2; Name = 'Beta'; Total = 7.25 }
)
$rows | ConvertTo-OfficeCsv -OutputPath .\export.csv -Delimiter ';'
        

Uses ordered dictionaries to enforce column order and a custom delimiter.

Write CSV without headers.

PS>$data | ConvertTo-OfficeCsv -IncludeHeader:$false -OutputPath .\noheader.csv
        

Writes rows only when a downstream system expects headerless CSV.