Learn How to Manually Create a CSV File in PowerShell

re: Learn How to Manually Create a CSV File in PowerShell

JKevinParker — Fri, 16 Nov 2012 19:27:23 GMT

jrv, that bit of script was very helpful! However, to get it to work right, I had to modify the last line:

$csv=@()

$csv+=New-Object PSObject -Property @{Index=1;Name='John'}

$csv+=New-Object PSObject -Property @{Index=2;Name='Mary'}

$csv+=New-Object PSObject -Property @{Index=3;Name='Kate'}

$csv | Export-CSV C:\temp\mycsv.csv -notype

That change to "Export-CSV" made the values and headings display in columns in Excel as expected, whereas using "ConvertTo-Csv" crammed the strings into one column.

re: Learn How to Manually Create a CSV File in PowerShell

K_Schulte — Sat, 24 Mar 2012 22:12:23 GMT

Hi Ed, Hi Teresa

using CSV files is always a good idea in Powershell environments.

They are automatically converted to objects by Import-Csv and can easily be created.

Of course @jrv is right ... we could use other datastructures to produce CSVs.

Many roads lead to rome ...

btw: If you need help with your new book, ... let me know!

I installed WIN8 in a virtual machine just to have PS3 available :-)

So ... let the future begin! ( and the games in 9 days :-)

Klaus

re: Learn How to Manually Create a CSV File in PowerShell

jrv — Sat, 24 Mar 2012 11:15:22 GMT

$csv=@()

$csv+=New-Object PSObject -Property @{Index=1;Name='John'}

$csv+=New-Object PSObject -Property @{Index=2;Name='Mary'}

$csv+=New-Object PSObject -Property @{Index=3;Name='Kate'}

$csv|ConvertTo-Csv -notype > c:\fso\mycsv.csv