cartographer.ElectorateImporter.ParseXLS C# (CSharp) Méthode

        public bool ParseXLS(string a_xls)
        {
            string _file = Directory.GetCurrentDirectory();
            string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + a_xls + ";Extended Properties=\"Excel 8.0;HDR=YES;\"";
            //|DataDirectory|\data\Qld_FederalResults by Electorate-2004.xls;

            OleDbConnection connection = new OleDbConnection(connectionString);
            connection.Open();

            //OleDbCommand commandtest = new OleDbCommand("SELECT * FROM [2004 Election$]", connection);
            OleDbDataAdapter _allData = new OleDbDataAdapter("SELECT * FROM [2004 Election$]", connection);
            DataSet ds = new DataSet();
            _allData.Fill(ds);
            var table = ds.Tables[0];
            int i = 1;
            foreach (DataRow row in table.Rows)
            {
                //Console.Out.WriteLine(row.ItemArray);
                 if (i == 149) { break; }

                List<String> _param = new List<String>();
                foreach (var thing in row.ItemArray)
                {

                    if (thing.ToString().Length != 0)
                    {
                        _param.Add(thing.ToString());
                    }

                }
                if (_param.Count() > 1)
                {
                    Electorate _electorate = new Electorate(_param);
                    m_ElectorateDataXLS.Add(_electorate);
                    Console.Out.WriteLine("Creating {0} size is {1}", _param[0], _param.Count());
                }

                i++;

            }

            return false;
        }

        public void ImporterTest()
        {
            ElectorateImporter electorateImporter = new ElectorateImporter();
            electorateImporter.ParseMID("QLD_Federal_Electoral_Boundaries.MID");
            electorateImporter.ParseMIF("QLD_Federal_Electoral_Boundaries.mif");
            electorateImporter.ParseXLS();
            List<Electorate> Electorates = new List<Electorate>();
            Electorates = electorateImporter.MergeData();
            Electorate testElectorate = Electorates[0];
            Assert.AreEqual(testElectorate.Name, "Blair");
            Assert.AreEqual(testElectorate.Actual, 87171);
            Assert.AreEqual(testElectorate.Projected, 92524);
            Assert.AreEqual(testElectorate.TotalPopulation, 87454);
            Assert.AreEqual(testElectorate.Over18, 87454);
            Assert.AreEqual(testElectorate.Area, 14859.51, 0.001);

            //Assert.AreEqual(testElectorate.ALPVotes, 31.44);
            Assert.AreEqual(testElectorate.LPVotes, 52.19);
            Assert.AreEqual(testElectorate.NPVotes, 0);
            Assert.AreEqual(testElectorate.DEMVotes, 1.28);
            Assert.AreEqual(testElectorate.GRNVotes, 2.94);
            Assert.AreEqual(testElectorate.OTHVotes, 12.15);
            Assert.AreEqual(testElectorate.LNP2PVotes, 61.21);
            Assert.AreEqual(testElectorate.ALP2PVotes, 38.79);
        }