ImportExcel/Examples/Styles/MultipleStyles.ps1 at master · SQLvariant/ImportExcel · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
try {Import-Module $PSScriptRoot\..\..\ImportExcel.psd1} catch {throw ; return}

$xlfile = "$env:TEMP\test.xlsx"
Remove-Item $xlfile -ErrorAction SilentlyContinue

$data = ConvertFrom-Csv @"
Region,Item,TotalSold
North,melon,38
South,screwdriver,21
South,peach,33
South,saw,81
South,kiwi,70
North,orange,59
North,avocado,25
South,lime,48
South,nail,83
North,apple,2
"@

$styleParams = @{
    FontSize = 13
    Bold     = $true
}

$styles = $(
    New-ExcelStyle -BackgroundColor LightBlue -FontSize 14 -Bold -Range "A1:H1" -HorizontalAlignment Center -Merge

    New-ExcelStyle -BackgroundColor LimeGreen -Range "B10" @styleParams
    New-ExcelStyle -BackgroundColor PeachPuff -Range "B5" @styleParams
    New-ExcelStyle -BackgroundColor Orange -Range "B8" @styleParams
    New-ExcelStyle -BackgroundColor Red -Range "B12" @styleParams
)

$reportTitle = "This is a report Title"
$data | Export-Excel $xlfile -Show -AutoSize -AutoFilter -Title $reportTitle -Style $styles