public void ExcelParser() { ExcelParser excel = new ExcelParser(); string path = @"TestFiles/ExcelFile.xlsx"; RawData data; bool success = excel.TryParseData(path, out data); Assert.IsTrue(success); string[] groupNames = new[] {"A", "B", "C", "D", "E"}; List<double[]> expectedArrays = new List<double[]> { new[] {1d, 4, 2, 7, 8, 3, 1, 2, 3, 3}, new[] {5.3, 2, 7.5, 54, 23, 16}, new[] {84d, 14, 34, 17, 26}, new[] {57.7334, 16.6543, 45, 35.333335, 45, 95.0000000001, 65, 33}, new[] {13.4444444444444, 1, 0, 100, 99, 8008135, 77777777777777} } ; List<double[]> actualArrays = new List<double[]> { data[0].Entries.ToArray(), data[1].Entries.ToArray(), data[2].Entries.ToArray(), data[3].Entries.ToArray(), data[4].Entries.ToArray() }; for (int i = 0; i < 5; i++) { double[] expectedDoubles = expectedArrays[i]; double[] actualDoubles = actualArrays[i]; for (int j = 0; j < expectedDoubles.Length; j++) { Assert.AreEqual(expectedDoubles[j], actualDoubles[j]); } } }
/* SmallCsvFile has the values: A: B: C: 1 6 11 2 7 12 3 8 13 4 9 14 5 10 15 --------- Averages: 3 8 13 Grand Mean = 8 SST = 280 SSW = 30 SSB = 250 dft = 14 dfw = 12 dfb = 2 msb = 125 msw = 2.5 F = 50 */ public AnovaTestsExcel() { rData = new RawData(); //CsvParser parser = new CsvParser(); ExcelParser parser = new ExcelParser(); bool parsed = parser.TryParseData(@"TestFiles/SmallExcelFile.xlsx", out rData); data = new AnovaOneway(rData); }
public void ExcelParserSmall() { ExcelParser excel = new ExcelParser(); string path = @"TestFiles/SmallExcelFile.xlsx"; RawData data; bool success = excel.TryParseData(path, out data); Assert.IsTrue(success); string[] groupNames = new[] {"A", "B", "C"}; List<double[]> expectedArrays = new List<double[]> { new[] {1d, 2, 3, 4, 5}, new[] {6d, 7, 8, 9, 10}, new[] {11d, 12, 13, 14, 15} }; List<double[]> actualArrays = new List<double[]> { data[0].Entries.ToArray(), data[1].Entries.ToArray(), data[2].Entries.ToArray(), }; for (int i = 0; i < 3; i++) { double[] expectedDoubles = expectedArrays[i]; double[] actualDoubles = actualArrays[i]; for (int j = 0; j < expectedDoubles.Length; j++) { Assert.AreEqual(expectedDoubles[j], actualDoubles[j]); } } }