__tests__/AddTrendlinesToAChart.tests.ps1
|
Import-Module $PSScriptRoot\..\ImportExcel.psd1 -Force if (-not $env:TEMP) {$env:TEMP = [IO.Path]::GetTempPath() -replace "/$","" } $notWindows = ($PSVersionTable.os -and $PSVersionTable.os -notMatch 'Windows' ) Describe "Test adding trendlines to charts" { BeforeAll { $script:data = ConvertFrom-Csv @" Region,Item,TotalSold West,screws,60 South,lemon,48 South,apple,71 East,screwdriver,70 East,kiwi,32 West,screwdriver,1 South,melon,21 East,apple,79 South,apple,68 South,avocado,73 "@ } BeforeEach { $xlfile = "$env:TEMP\trendLine.xlsx" Remove-Item $xlfile -ErrorAction SilentlyContinue } It "Should add a linear trendline".PadRight(90) { $cd = New-ExcelChartDefinition -XRange Region -YRange TotalSold -ChartType ColumnClustered -ChartTrendLine Linear $data | Export-Excel $xlfile -ExcelChartDefinition $cd -AutoNameRange $excel = Open-ExcelPackage -Path $xlfile $ws = $excel.Workbook.Worksheets["Sheet1"] $ws.Drawings[0].Series.TrendLines.Type | Should Be 'Linear' Close-ExcelPackage $excel } It "Should add a MovingAvgerage trendline".PadRight(90) { $cd = New-ExcelChartDefinition -XRange Region -YRange TotalSold -ChartType ColumnClustered -ChartTrendLine MovingAvgerage $data | Export-Excel $xlfile -ExcelChartDefinition $cd -AutoNameRange $excel = Open-ExcelPackage -Path $xlfile $ws = $excel.Workbook.Worksheets["Sheet1"] $ws.Drawings[0].Series.TrendLines.Type | Should Be 'MovingAvgerage' Close-ExcelPackage $excel } } |