Export-CDExcel

From PowerGUI Wiki

Writes compare result to Excel file

Contents 1 Syntax 2 Detailed Description 3 Related Commands 4 Parameters 5 Examples 5.1 Example 1

Syntax

Export-CDExcel -InputObject <CDCompareResult> [-PassThru] [-Force] [-Path] <String> [<CommonParameters>]

Detailed Description

Writes compare result to Excel file

Related Commands

• Compare-CDObject

Parameters

Name	Description	Required?	Pipeline Input	Default Value
InputObject	Result of Compare-CDObject command	true	true (ByValue)
PassThru	Passes the input object through the pipeline. By default, this cmdlet does not pass any objects through the pipeline.	false	false
Force	Causes the cmdlet to clear the read-only attribute of the output file if necessary. The cmdlet will attempt to reset the read-only attribute when the command completes.	false	false
Path	File path	true	false

Examples

Example 1

$a=get-cddatabase myServ base1
$b=get-cddatabase servMain base2
$s = compare-cdobject $a $b | export-cdexcel 'c:\test.xls'

Compares two databases on sql servers and saves result in Excel file