public void NoHeader_no_args() { var companies = from c in _factory.WorksheetNoHeader() select c; Assert.AreEqual(7, companies.Count(), "Company Count"); Assert.AreEqual("ACME", companies.First()[0].ToString(), "First Company Name"); Assert.AreEqual(455, companies.Last()[2].Cast <int>(), "Last Company Employee Count"); }
public void csv_file() { var csvFile = Path.Combine( Path.GetDirectoryName(_excelFileName), "NoHeader.csv"); _factory = new ExcelQueryFactory(csvFile); var companies = from c in _factory.WorksheetNoHeader() select c; Assert.AreEqual(7, companies.Count(), "Company Count"); Assert.AreEqual("ACME2", companies.First()[0].ToString(), "First Company Name"); Assert.AreEqual(4554, companies.Last()[2].Cast <int>(), "Last Company Employee Count"); }
public void csv_file() { var csvFile = Path.Combine( Path.GetDirectoryName(_excelFileName), "NoHeader.csv"); _factory = new ExcelQueryFactory(csvFile); var companies = from c in _factory.WorksheetNoHeader() select c; Assert.AreEqual(7, companies.Count(), "Company Count"); Assert.AreEqual("ACME2", companies.First()[0].ToString(), "First Company Name"); Assert.AreEqual(4554, companies.Last()[2].Cast<int>(), "Last Company Employee Count"); }