public void CellsRangesPostWorksheetCellsRangeOutlineBorderTest()
        {
            string name      = "Book1.xlsx";
            string sheetName = "SHEET1";
            RangeSetOutlineBorderRequest rangeOperate =
                new RangeSetOutlineBorderRequest();

            //new Range(10,10.1,1,1,null,null,2,16.8), "LeftBorder", "None"
            rangeOperate.BorderEdge    = "LeftBorder";
            rangeOperate.BorderStyle   = "Dotted";
            rangeOperate.BorderColor   = new Color();
            rangeOperate.BorderColor.R = 255;
            Range range = new Range(); //10,10.1,1,1,null,null,2,16.8

            range.ColumnCount  = 10;
            range.FirstColumn  = 1;
            range.FirstRow     = 1;
            range.RowCount     = 2;
            range.RowHeight    = 10;
            rangeOperate.Range = range;
            string folder = null;

            new Config().UpdateDataFile(folder, name);
            var response = instance.CellsRangesPostWorksheetCellsRangeOutlineBorder(name, sheetName, rangeOperate, folder);

            Console.WriteLine(response);
        }
Ejemplo n.º 2
0
        public void CellsRangesPostWorksheetCellsRangeOutlineBorderTest()
        {
            // TODO uncomment below to test the method and replace null with proper value
            string name      = BOOK1;
            string sheetName = SHEET1;
            RangeSetOutlineBorderRequest rangeOperate =
                new RangeSetOutlineBorderRequest();

            //new Range(10,10.1,1,1,null,null,2,16.8), "LeftBorder", "None"
            rangeOperate.BorderEdge    = "LeftBorder";
            rangeOperate.BorderStyle   = "Dotted";
            rangeOperate.BorderColor   = new Color();
            rangeOperate.BorderColor.R = 255;
            Range range = new Range(); //10,10.1,1,1,null,null,2,16.8

            range.ColumnCount  = 10;
            range.FirstColumn  = 1;
            range.FirstRow     = 1;
            range.RowCount     = 2;
            range.RowHeight    = 10;
            rangeOperate.Range = range;
            string folder = TEMPFOLDER;

            UpdateDataFile(folder, name);
            var response = instance.CellsRangesPostWorksheetCellsRangeOutlineBorder(name, sheetName, rangeOperate, folder);

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