re: Hey, Scripting Guy! How Do I Create a CSV File from Within Windows PowerShell?

jrv — Thu, 23 Jun 2011 13:21:11 GMT

UPDATE:

This blog was for POwerShellV1,

Here is the solution for PowerShell V2

$path = "c:\fso\bios1.csv"

Get-WmiObject -Class win32_bios | Select name,version | Export-Csv $path -NoTypeInfo

V2 has a CmdLet for creating a CSV.

thiru — Thu, 23 Jun 2011 07:41:17 GMT

When i execute this code i get the following error

Exception calling "CreateTextFile" with "2" argument(s): "Exception from HRESULT: 0x800A

004C (CTL_E_PATHNOTFOUND)"

At line:6 char:28

+ $file = $fso.CreateTextFile <<<< ($path,$true)

+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException

+ FullyQualifiedErrorId : ComMethodTargetInvocation

$path = "c:\fso\bios1.csv"

$bios = Get-WmiObject -Class win32_bios

$csv = "Name,Version`r`n"

$csv +=$bios.name + "," + $bios.version

$fso = new-object -comobject scripting.filesystemobject

$file = $fso.CreateTextFile($path,$true)

$file.write($csv)

$file.close()