public void CellsAutoFilterDeleteWorksheetDateFilterExample()
        {
            string name                 = "Book1.xlsx";
            string sheetName            = "SHEET1";
            int?   fieldIndex           = 1;
            string dateTimeGroupingType = "Day";
            int?   year                 = 2010;
            int?   month                = 10;
            int?   day    = 1;
            int?   hour   = 1;
            int?   minute = 1;
            int?   second = 1;
            string folder = null;

            new Config().UpdateDataFile(null, "Book1.xlsx");
            var response = instance.CellsAutoFilterDeleteWorksheetDateFilter(name, sheetName, fieldIndex, dateTimeGroupingType, year, month, day, hour, minute, second, folder);

            Console.WriteLine(response);
        }
Exemplo n.º 2
0
        public void CellsAutoFilterDeleteWorksheetDateFilterTest()
        {
            // TODO uncomment below to test the method and replace null with proper value
            string name                 = BOOK1;
            string sheetName            = SHEET1;
            int?   fieldIndex           = 1;
            string dateTimeGroupingType = "Day";
            int?   year                 = 2010;
            int?   month                = 10;
            int?   day    = 1;
            int?   hour   = 1;
            int?   minute = 1;
            int?   second = 1;
            string folder = TEMPFOLDER;

            UpdateDataFile(TEMPFOLDER, BOOK1);
            var response = instance.CellsAutoFilterDeleteWorksheetDateFilter(name, sheetName, fieldIndex, dateTimeGroupingType, year, month, day, hour, minute, second, folder);

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