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]);
}