ImportExcel/__tests__/AddTrendlinesToAChart.tests.ps1 at AddToExcelMethod · robertcatgithub/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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
if (-not (Get-command Import-Excel -ErrorAction SilentlyContinue)) {
    Import-Module $PSScriptRoot\..\ImportExcel.psd1
}
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 = "TestDrive:\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
    }
}