New-HwCertTestCollectionExcelReport

New-HwCertTestCollectionExcelReport

Creates an HCK test summary report.

Syntax

Parameter Set: Default
New-HwCertTestCollectionExcelReport [-LiteralPath] <String[]> -ExcelPath <String> -ResultCount <Int32> [ <CommonParameters>]

Detailed Description

The New-HwCertTestCollectionExcelReport cmdlet creates a Windows Hardware Certification Kit (HCK) test summary report as a Microsoft Excel workbook. Specify one or more merged test collection .xml files. The cmdlet creates a separate worksheet for each merged test collection file, aggregates results, and compares the same test target from each file in a summary report. The summary shows total pass, pass with filter, fail, and N-1 regression data. For more information, see Windows Hardware Certification Kit (HCK) (https://msdn.microsoft.com/en-us/library/windows/hardware/hh833788.aspx) in the Microsoft Developer Network (MSDN) Library.

You can use up to ten results per test in the test result aggregation process. The most recent passing result takes precedence as the aggregate.

The maximum number of test collections for a summary report is eight. If you specify a single merged test collection, the report includes the summary for that test pass without N-1 regression comparisons.

To create merged test result collection files, use the Merge-HwCertTestCollectionFromHckx and Merge-HwCertTestCollectionFromXml cmdlets, along with the Export-HwCertTestCollectionToXml cmdlet.

Parameters

-ExcelPath<String>

Specifies a full path for the new Excel report.

Aliases

none

Required?

true

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-LiteralPath<String[]>

Specifies an array of full paths. These are file paths to merged test collection .xml files. You can specify up to eight files.

The cmdlet uses the order of the files in this parameter to determine the order of the N-1 regression data comparison. For example, the second file is compared with the first file, and the third file is compared with the second file.

Aliases

Input,MergedCollection

Required?

true

Position?

1

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-ResultCount<Int32>

Specifies the number of results. The cmdlet reports on these results and uses these results in the result aggregate process. The maximum value is ten.

Aliases

none

Required?

true

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

<CommonParameters>

This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see    about_CommonParameters (https://go.microsoft.com/fwlink/p/?LinkID=113216).

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

Outputs

The output type is the type of the objects that the cmdlet emits.

Examples

Example 1: Create a report for two merged test collections

This command creates an Excel report from two merged test collection .xml files from two test passes. The command specifies a report count value of one.

PS C:\> New-HwCertTestCollectionExcelReport -LiteralPath ("C:\Temp\Merged_TP001.xml", "C:\Temp\Merged_TP002.xml") -ExcelPath "C:\Temp\Report.xls" -ResultCount 1

Merge-HwCertTestCollectionFromHckx

Merge-HwCertTestCollectionFromXml

Export-HwCertTestCollectionToXml