public void WorksheetRangeNoHeader_returns_7_companies() { var companies = from c in _factory.WorksheetRangeNoHeader("A2", "D8", "Sheet1") select c; Assert.AreEqual(7, companies.Count()); }
public void no_header_range_where_clause() { var ACompanies = from c in _factory.WorksheetRangeNoHeader("C5", "F11", "Range") where c[0].ToString().StartsWith("A") select c; Assert.AreEqual(2, ACompanies.Count(), "Company Count"); Assert.AreEqual(new DateTime(1917, 9, 1).ToShortDateString(), ACompanies.Last()[3].Cast <DateTime>().ToShortDateString(), "Last ACompany Date"); }
public void WorksheetRangeNoHeader_returns_7_companies() { List <ExcelRowNoHeader> companies = (from c in _factory.WorksheetRangeNoHeader("A2", "D8", "Sheet1") select c).ToList(); Assert.AreEqual(7, companies.Count); }