/
diev
/
dfinke-ImportExcel
Обзор
Документация
Войти
/
diev
/
dfinke-ImportExcel
Код
Запросы
0
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
Examples/TestRestAPI/RunAndShowUnitTests.ps1
37 строк
1 KB
jhoneill
aggressive linting
20 ноя 2019, 22:14
20 ноя 2019, 22:14
5aa841c
Код
Авторство
О чём код?
try {Import-Module $PSScriptRoot\..\..\ImportExcel.psd1} catch {throw ; return} $xlfilename=".\test.xlsx" Remove-Item $xlfilename -ErrorAction Ignore $ConditionalText = @() $ConditionalText += New-ConditionalText -Range "C:C" -Text failed -BackgroundColor red -ConditionalTextColor black $ConditionalText += New-ConditionalText -Range "C:C" -Text passed -BackgroundColor green -ConditionalTextColor black $r = .\TryIt.ps1 $xlPkg = $(foreach($result in $r.TestResult) { [PSCustomObject]@{ Name = $result.Name #Time = $result.Time Result = $result.Result Messge = $result.FailureMessage StackTrace = $result.StackTrace } }) | Export-Excel -Path $xlfilename -AutoSize -ConditionalText $ConditionalText -PassThru $sheet1 = $xlPkg.Workbook.Worksheets["sheet1"] $sheet1.View.ShowGridLines = $false $sheet1.View.ShowHeaders = $false Set-ExcelRange -Address $sheet1.Cells["A:A"] -AutoSize Set-ExcelRange -Address $sheet1.Cells["B:D"] -WrapText $sheet1.InsertColumn(1, 1) Set-ExcelRange -Address $sheet1.Cells["A:A"] -Width 5 Set-ExcelRange -Address $sheet1.Cells["B1:E1"] -HorizontalAlignment Center -BorderBottom Thick -BorderColor Cyan Close-ExcelPackage $xlPkg -Show