Accord.Tests.IO.ExcelReaderTest.testData1 C# (CSharp) Method

testData1() private static method

private static testData1 ( ExcelReader withHeader, ExcelReader sansHeader ) : void
withHeader Accord.IO.ExcelReader
sansHeader Accord.IO.ExcelReader
return void
        private static void testData1(ExcelReader withHeader, ExcelReader sansHeader)
        {
            var sheets1 = withHeader.GetWorksheetList();
            var sheets2 = sansHeader.GetWorksheetList();

            Assert.AreEqual(1, sheets1.Length);
            Assert.AreEqual(1, sheets2.Length);

            Assert.AreEqual("testnormal", sheets1[0]);
            Assert.AreEqual("testnormal", sheets2[0]);

            var dataWithHeader = withHeader.GetWorksheet("testnormal");
            var dataSansHeader = sansHeader.GetWorksheet("testnormal");

            Assert.AreEqual(119, dataWithHeader.Rows.Count);
            Assert.AreEqual(17, dataWithHeader.Columns.Count);

            Assert.AreEqual(120, dataSansHeader.Rows.Count);
            Assert.AreEqual(17, dataSansHeader.Columns.Count);

            var firstRowWithHeader = dataWithHeader.Rows[0].ItemArray;
            Assert.AreEqual("90", firstRowWithHeader[0]);
            Assert.AreEqual("0", firstRowWithHeader[1]);
            Assert.AreEqual("0", firstRowWithHeader[2]);
            Assert.AreEqual("0", firstRowWithHeader[3]);
            Assert.AreEqual("0", firstRowWithHeader[4]);

            var firstRowSansHeader = dataSansHeader.Rows[0].ItemArray;
            Assert.AreEqual("1", firstRowSansHeader[0]);
            Assert.AreEqual("2", firstRowSansHeader[1]);
            Assert.AreEqual("3", firstRowSansHeader[2]);
            Assert.AreEqual("4", firstRowSansHeader[3]);
            Assert.AreEqual("5", firstRowSansHeader[4]);
        }