Examples/ConditionalFormatting/GetProcess.ps1
|
try {Import-Module $PSScriptRoot\..\..\ImportExcel.psd1} catch {throw ; return} Remove-Item "$env:TEMP\testExport.xlsx" -ErrorAction Ignore Get-Process | Where-Object Company | Select-Object Company, Name, PM, Handles, *mem* | #This example creates a 3 Icon set for the values in the "PM column, and Highlights company names (anywhere in the data) with different colors Export-Excel "$env:TEMP\testExport.xlsx" -Show -AutoSize -AutoNameRange ` -ConditionalFormat $( New-ConditionalFormattingIconSet -Range "C:C" ` -ConditionalFormat ThreeIconSet -IconType Arrows ) -ConditionalText $( New-ConditionalText Microsoft -ConditionalTextColor Black New-ConditionalText Google -BackgroundColor Cyan -ConditionalTextColor Black New-ConditionalText authors -BackgroundColor LightBlue -ConditionalTextColor Black New-ConditionalText nvidia -BackgroundColor LightGreen -ConditionalTextColor Black ) |