/
diev
/
dfinke-ImportExcel
Обзор
Документация
Войти
/
diev
/
dfinke-ImportExcel
Код
Запросы
0
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
Examples/ConditionalFormatting/TextComparisons.ps1
29 строк
1 KB
MikeyBronowski
Standardising examples
01 июл 2020, 23:04
01 июл 2020, 23:04
8a20963
Код
Авторство
О чём код?
try {Import-Module ..\..\ImportExcel.psd1 -Force} catch {throw ; return} $data = $( New-PSItem 100 @('test', 'testx') New-PSItem 200 New-PSItem 300 New-PSItem 400 New-PSItem 500 ) #Get rid of pre-exisiting sheet $xlSourcefile1 = "$env:TEMP\ImportExcelExample1.xlsx" $xlSourcefile2 = "$env:TEMP\ImportExcelExample2.xlsx" Write-Verbose -Verbose -Message "Save location: $xlSourcefile1" Write-Verbose -Verbose -Message "Save location: $xlSourcefile2" Remove-Item $xlSourcefile1 -ErrorAction Ignore Remove-Item $xlSourcefile2 -ErrorAction Ignore $data | Export-Excel $xlSourcefile1 -Show -ConditionalText $( New-ConditionalText -ConditionalType GreaterThan 300 New-ConditionalText -ConditionalType LessThan 300 -BackgroundColor cyan ) $data | Export-Excel $xlSourcefile2 -Show -ConditionalText $( New-ConditionalText -ConditionalType GreaterThanOrEqual 275 New-ConditionalText -ConditionalType LessThanOrEqual 250 -BackgroundColor cyan )