ImportExcel

4.0.12

Set-CellStyle.ps1

1
2
3
4
5
6
7
8
9
10
11
12
13

                                function Set-CellStyle {

    param(

        $WorkSheet,

        $Row,

        $LastColumn,

        [OfficeOpenXml.Style.ExcelFillStyle]$Pattern,

        [System.Drawing.Color]$Color

    )

    $t=$WorkSheet.Cells["A$($Row):$($LastColumn)$($Row)"]

    $t.Style.Fill.PatternType=$Pattern

    $t.Style.Fill.BackgroundColor.SetColor($Color)

}