Add Workbook read tests

4 files changed, 9 insertions, 6 deletions

diff --git a/RhSolutions.Tests/CanReadProducts.cs b/RhSolutions.Tests/CanReadProducts.cs
index 1fa7357..df0ce73 100644
--- a/RhSolutions.Tests/CanReadProducts.cs
+++ b/RhSolutions.Tests/CanReadProducts.cs
@@ -45,14 +45,17 @@ public class CanReadProducts : IDisposable
         Assert.Equal(3, products.Count());
     }
 
-    [ExcelFact(Workbook = @"TestWorkbooks\Specifications\HeatingFloor.xlsx")]
+    [ExcelFact(Workbook = @"TestWorkbooks\TestSpecificaion.xlsx")]
     public void CanReadWorkbook()
     {
         Worksheet worksheet = Util.Workbook.Worksheets[1];
-        var products = _reader.ReadProducts(new[] { worksheet });
-
-        Assert.NotNull(products);
-        Assert.NotEmpty(products);
+        var result = _reader.ReadProducts(new[] { worksheet });
+        Assert.NotNull(result);
+        Assert.NotEmpty(result);
+        Assert.Equal("TestSpecificaion", result.First().Item1);
+        var products = result.First().Item2;
+        Assert.Equal(46, products.Count());
+        Assert.Equal(29266, products.Sum(p => p.Value));
     }
 
     public void Dispose()
diff --git a/RhSolutions.Tests/RhSolutions.Tests.csproj b/RhSolutions.Tests/RhSolutions.Tests.csproj
index 63b9ae5..c1a28e0 100644
--- a/RhSolutions.Tests/RhSolutions.Tests.csproj
+++ b/RhSolutions.Tests/RhSolutions.Tests.csproj
@@ -27,7 +27,7 @@
 	  <None Update="TestWorkbooks\ExcelTableTest.xlsx">
 	    <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
 	  </None>
-	  <None Update="TestWorkbooks\Specifications\HeatingFloor.xlsx">
+	  <None Update="TestWorkbooks\TestSpecificaion.xlsx">
 	    <CopyToOutputDirectory>Always</CopyToOutputDirectory>
 	  </None>
 	</ItemGroup>
diff --git a/RhSolutions.Tests/TestWorkbooks/Specifications/HeatingFloor.xlsx b/RhSolutions.Tests/TestWorkbooks/Specifications/HeatingFloor.xlsx
deleted file mode 100644
index 20416e0..0000000
--- a/RhSolutions.Tests/TestWorkbooks/Specifications/HeatingFloor.xlsx
+++ /dev/null
diff --git a/RhSolutions.Tests/TestWorkbooks/TestSpecificaion.xlsx b/RhSolutions.Tests/TestWorkbooks/TestSpecificaion.xlsx
new file mode 100644
index 0000000..e9a6441
--- /dev/null
+++ b/RhSolutions.Tests/TestWorkbooks/TestSpecificaion.xlsx