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