Ejemplo n.º 1
0
        public static void Initialization(TestContext context)
        {
            excel   = new oExcel(DataTests.GetFullPathExcelFile);
            dtExcel = excel.ImportDataForExcel();

            listField         = excel.ListField("kmat");             // Functions.ListFieldKmatForExcel(dtExcel, "kmat");
            dictionaryGroupBy = excel._groupByFieldAndCount("kmat"); //DictionaryResourceAndCount(listField);

            listUnique = excel.ListUniqueField("kmat");              //new List<string>(); // Functions.ListUniqueFieldResource(dictionaryGroupBy);

            // = DoubleKmat.ToArray();
        }
Ejemplo n.º 2
0
        //[DataSource(
        //"System.Data.OleDb",
        //@"Provider=Microsoft.ACE.OLEDB.12.0;
        //    Data Source=..\..\DataTests\001 - 1301 - 1222333 - LastName - test_01.xlsx;
        //    Persist Security Info=False;
        //    Extended Properties='Excel 12.0 Xml; HDR=YES'",
        //"Sheet$",
        //DataAccessMethod.Sequential)]
        public void ListUniqueFieldResource_Test()
        {
            HashSet <string> hashSetUnique = new HashSet <string>();

            // arrange
            var expendetListUnique = excel.ListField("kmat_double");

            foreach (var row in expendetListUnique)
            {
                hashSetUnique.Add(row);
            }

            //act
            var actualListUnique = excel.ListUniqueField("kmat");

            CollectionAssert.AreEqual(expendetListUnique, actualListUnique);

            //Assert.IsTrue(hashSetUnique.SetEquals(actualListUnique));
        }