/
diev
/
dfinke-ImportExcel
Обзор
Документация
Войти
/
diev
/
dfinke-ImportExcel
Код
Запросы
0
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
Examples/Styles/MultipleStyles.ps1
35 строк
970 B
jhoneill
remove LoadPSD calls & 72 empty catch blocks from examples
18 ноя 2019, 01:45
18 ноя 2019, 01:45
66bf3ad
Код
Авторство
О чём код?
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