Examples/FormatCellStyles/PassInScriptBlock.ps1 - master - diev/dfinke-ImportExcel

Examples/FormatCellStyles/PassInScriptBlock.ps1

22 строки645 B

MikeyBronowski

Standardising examples

01 июл 2020, 23:04

01 июл 2020, 23:048a20963

try {Import-Module $PSScriptRoot\..\..\ImportExcel.psd1} catch {throw ; return}

#Get rid of pre-exisiting sheet
$xlSourcefile = "$env:TEMP\ImportExcelExample.xlsx"
Write-Verbose -Verbose -Message  "Save location: $xlSourcefile"
Remove-Item $xlSourcefile -ErrorAction Ignore

$RandomStyle = {
    param(
        $workSheet,
        $totalRows,
        $lastColumn
    )

    2..$totalRows | ForEach-Object{
        Set-CellStyle $workSheet $_ $LastColumn Solid (Get-Random @("LightGreen", "Gray", "Red"))
    }
}

Get-Process |
    Select-Object Company,Handles,PM, NPM|
    Export-Excel $xlSourcefile -Show  -AutoSize -CellStyleSB $RandomStyle