ImportExcel/__tests__/Remove-WorkSheet.tests.ps1 at master · gusadrodriguez/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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
#Requires -Modules Pester
if (-not (Get-command Import-Excel -ErrorAction SilentlyContinue)) {
    Import-Module $PSScriptRoot\..\ImportExcel.psd1
}
Describe "Remove Worksheet" {
    Context "Remove a worksheet output" {
        BeforeEach {
            # Create three sheets
            $data = ConvertFrom-Csv @"
Name,Age
Jane,10
John,20
"@
            $xlFile1 = "TestDrive:\RemoveWorsheet1.xlsx"
            Remove-Item $xlFile1 -ErrorAction SilentlyContinue

            $data | Export-Excel -Path $xlFile1 -WorksheetName Target1
            $data | Export-Excel -Path $xlFile1 -WorksheetName Target2
            $data | Export-Excel -Path $xlFile1 -WorksheetName Target3
            $data | Export-Excel -Path $xlFile1 -WorksheetName Sheet1

            $xlFile2 = "TestDrive:\RemoveWorsheet2.xlsx"
            Remove-Item $xlFile2 -ErrorAction SilentlyContinue

            $data | Export-Excel -Path $xlFile2 -WorksheetName Target1
            $data | Export-Excel -Path $xlFile2 -WorksheetName Target2
            $data | Export-Excel -Path $xlFile2 -WorksheetName Target3
            $data | Export-Excel -Path $xlFile2 -WorksheetName Sheet1
        }

        it "Should throw about the Path".PadRight(87)  {
            {Remove-Worksheet} | Should  -Throw 'Remove-Worksheet requires the and Excel file'
        }

        it "Should delete Target2".PadRight(87)  {
            Remove-Worksheet -Path $xlFile1 -WorksheetName Target2

            $actual = Get-ExcelSheetInfo -Path $xlFile1

            $actual.Count   | Should -Be 3
            $actual[0].Name | Should -Be "Target1"
            $actual[1].Name | Should -Be "Target3"
            $actual[2].Name | Should -Be "Sheet1"
        }

        it "Should delete Sheet1".PadRight(87)  {
            Remove-Worksheet -Path $xlFile1

            $actual = Get-ExcelSheetInfo -Path $xlFile1

            $actual.Count   | Should -Be 3
            $actual[0].Name | Should -Be "Target1"
            $actual[1].Name | Should -Be "Target2"
            $actual[2].Name | Should -Be "Target3"
        }

        it "Should delete multiple sheets".PadRight(87)  {
            Remove-Worksheet -Path $xlFile1 -WorksheetName Target1, Sheet1

            $actual = Get-ExcelSheetInfo -Path $xlFile1

            $actual.Count   | Should -Be 2
            $actual[0].Name | Should -Be "Target2"
            $actual[1].Name | Should -Be "Target3"
        }

        it "Should delete sheet from multiple workbooks".PadRight(87)  {

            Get-ChildItem "TestDrive:\RemoveWorsheet*.xlsx" | Remove-Worksheet

            $actual = Get-ExcelSheetInfo -Path $xlFile1

            $actual.Count   | Should -Be 3
            $actual[0].Name | Should -Be "Target1"
            $actual[1].Name | Should -Be "Target2"
            $actual[2].Name | Should -Be "Target3"
        }
    }
}