Contact Info

Crumbtrail » Administration » Powershell » Powershell 1.0 » Export-Csv

Export-Csv - Powershell 1.0 CmdLet

ActiveXperts Network Monitor ships with integrated Powershell scripts to monitor complex network. The scripts run out of the box
Download the ActiveXperts Network Monitor FREE version now »


Export to Comma Separated Values (spreadsheet)

Export-Csv [-path] string -inputObject psobject [Options]

-Path path
       The path to the CSV to create

   -inputObject psobject
       Accepts objects that the cmdlet will represents as a CSV file. Enter a 
       variable that contains the objects or type a command or expression that
       gets the objects.

       Omits the #TYPE header from the CSV file.
       By default the first line of the CSV file will contain the 
       string "#TYPE " followed by the object type (fully qualified).

       Overwrite without warning, this is the default.
       Do not overwrite the contents of an existing file.
       The default is to overwrite without warning.
    -encoding string
       The type of encoding for the target file. Valid values are:
       ASCII, UTF7, UTF8, Unicode.
       Describe what would happen if you executed the command without actually
       executing the command.
       Prompt for confirmation before executing the command.
        -Verbose, -Debug,-ErrorAction,-ErrorVariable, -OutVariable.

Save details of the spooler process to a CSV file:

PS C:>get-process spoolsv | select-object ID,Path,sessionid | export-csv -path c:\spoolerdata.csv