public void CellsAutoFilterPutWorksheetDynamicFilterExample()
        {
            string name              = "Book1.xlsx";
            string sheetName         = "SHEET1";
            string range             = "a1:a10";
            int?   fieldIndex        = 0;
            string dynamicFilterType = "May";
            bool?  matchBlanks       = true;
            bool?  refresh           = true;
            string folder            = null;

            new Config().UpdateDataFile(null, "Book1.xlsx");
            var response = instance.CellsAutoFilterPutWorksheetDynamicFilter(name, sheetName, range, fieldIndex, dynamicFilterType, matchBlanks, refresh, folder);

            Console.WriteLine(response);
        }
예제 #2
0
        public void CellsAutoFilterPutWorksheetDynamicFilterTest()
        {
            // TODO uncomment below to test the method and replace null with proper value
            string name              = BOOK1;
            string sheetName         = SHEET1;
            string range             = RANGE;
            int?   fieldIndex        = 0;
            string dynamicFilterType = "May";
            bool?  matchBlanks       = true;
            bool?  refresh           = true;
            string folder            = TEMPFOLDER;

            UpdateDataFile(TEMPFOLDER, BOOK1);
            var response = instance.CellsAutoFilterPutWorksheetDynamicFilter(name, sheetName, range, fieldIndex, dynamicFilterType, matchBlanks, refresh, folder);

            Assert.IsInstanceOf <SaaSposeResponse>(response, "response is SaaSposeResponse");
            Assert.AreEqual(response.Code, 200);
        }