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