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