Contact Info

Crumbtrail

ActiveXperts.com » 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-Csv

Description
Export to Comma Separated Values (spreadsheet)

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

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.

   -noTypeInformation 
       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).

   -force
       Overwrite without warning, this is the default.
	   
    -noClobber
       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.
        
   -whatIf
       Describe what would happen if you executed the command without actually
       executing the command.
       
   -confirm
       Prompt for confirmation before executing the command.
 
   CommonParameters:
        -Verbose, -Debug,-ErrorAction,-ErrorVariable, -OutVariable.

Example(s)
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