Contact Info

Crumbtrail

ActiveXperts.com » Administration » Powershell » Powershell 1.0 » Export-Csv

Export-Csv - Powershell 1.0 CmdLet

Microsoft Windows PowerShell is a command-line shell and scripting tool based on the Microsoft .NET Framework. It is designed for system administrators, engineers and developers to control and automate the administration of Windows and applications.

More than hundred command-line tools (so called "cmdlets") can be used to perform system administration tasks and Windows Management Instrumentation (WMI). These cmdlets are easy to use, with standard naming conventions and common parameters, and standard tools for piping, sorting, filtering, and formatting data and objects.

Export-Csv

Description
Export to Comma Separated Values (spreadsheet)

Usage


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