ExcelORM/ExcelORM/ExcelORMTests/ReaderWriterTests.cs

using ExcelORM;

namespace ExcelORMTests;

public class ReaderWriterTests
{
    private const string regularFile = "testFiles/first.xlsx";
    private const string filteredFile = "testFiles/filtered.xlsx";
    
    class Test
    {
        [Column("First name" )]
        public string? Name { get; set; }

        [Column("Last name")]
        public string? Source { get; set; }

        [Column(new string[]{"Occupation", "Job"})]
        public string? Target { get; set; }
    }
    
    [Fact]
    public void Read()
    {
        var reader = new ExcelReader(regularFile);
        var results = reader.Read<Test>();
        Assert.NotNull(results);
        Assert.NotEmpty(results);
    }
    
    [Fact]
    public void ReadFiltered()
    {
        var reader = new ExcelReader(filteredFile);
        var results = reader.Read<Test>();
        Assert.NotNull(results);
        Assert.NotEmpty(results);

        var readerFilter = new ExcelReader(filteredFile) { ObeyFilter = true };
        var resultsFiltered = readerFilter.Read<Test>();
        Assert.NotNull(resultsFiltered);
        Assert.NotEmpty(resultsFiltered);
    }
}