RhSolutions.Tests/WorkbookValidationTests.cs


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

using RhSolutions.AddIn;
using RhSolutions.Tools;

namespace RhSolutions.Tests;

[ExcelTestSettings(OutOfProcess = true)]
public class WorkbookValidationTests : IDisposable
{
    private readonly RhSolutionsAddIn _addIn;

    public WorkbookValidationTests()
    {
        Environment.SetEnvironmentVariable("ISTESTING", "true");
        _addIn = new RhSolutionsAddIn();
        _addIn.AutoOpen();
        Util.Application.Workbooks.Add();
    }

    [ExcelFact(Workbook = @"..\..\..\TestWorkbooks\EmptyTestTable.xlsx")]
    public void WorksheetIsCorrect()
    {
        Worksheet worksheet = Util.Workbook.Sheets[1];
        Assert.True(worksheet.IsValidSource());
    }

    [ExcelFact(Workbook = @"..\..\..\TestWorkbooks\EmptyWorkbook.xlsx")]
    public void EmptyWorkbookIsNotCorrect()
    {
        Worksheet worksheet = Util.Workbook.Sheets[1];
        Assert.False(worksheet.IsValidSource());
    }

    public void Dispose()
    {
        _addIn.AutoClose();
        Util.Application.ActiveWindow.Close(SaveChanges: false);
    }
}