public void SearchPump1()
        {
            var excelWrapper = new EDRExcelWrapper(kennliste_path);
            var res          = excelWrapper.SearchRow("D954-2305");

            Assert.AreEqual(1, res.Count);
            string[] obj = res[0];
            Assert.AreEqual(obj[0].Trim(), "D954-2305");
            Assert.AreEqual(obj[1].Trim(), "HPR15A7RKP063KM28S2Z11");
        }
        public void FindLastPumpInList()
        {
            var excelWrapper = new EDRExcelWrapper(kennliste_path);
            var lastpump     = "D959Z5003";
            var retlist      = (excelWrapper.SearchRow(lastpump));

            Assert.IsNotNull(retlist);
            Assert.AreEqual(1, retlist.Count);
            Assert.AreEqual("D959Z5003", retlist[0][0]);
        }
        public void SearchCaseInsensitive()
        {
            var excelWrapper = new EDRExcelWrapper(kennliste_path);
            var res          = excelWrapper.SearchRow("d951-5001");

            Assert.AreEqual(1, res.Count);
            string[] obj = res[0];
            Assert.AreEqual(obj[0].Trim(), "D951-5001");
            Assert.AreEqual(obj[1].Trim(), "HPR18B1RKP019SM28F1Y00RKP019SM28F1Y00");
        }