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

            //new Range(10, 10.1, 1, 1, null, null, 2, 16.8), new Style (null ,new Font(null,19))
            rangeOperate.Style             = new Style();
            rangeOperate.Style.Font        = new Font();
            rangeOperate.Style.Font.IsBold = true;
            Range range = new Range(); //10,10.1,1,1,null,null,2,16.8

            range.ColumnCount  = 1;
            range.ColumnWidth  = 10.1;
            range.FirstColumn  = 1;
            range.FirstRow     = 1;
            range.RowCount     = 10;
            rangeOperate.Range = range;
            string folder = null;

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

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

            //new Range(10, 10.1, 1, 1, null, null, 2, 16.8), new Style (null ,new Font(null,19))
            rangeOperate.Style             = new Style();
            rangeOperate.Style.Font        = new Font();
            rangeOperate.Style.Font.IsBold = true;
            Range range = new Range(); //10,10.1,1,1,null,null,2,16.8

            range.ColumnCount  = 1;
            range.ColumnWidth  = 10.1;
            range.FirstColumn  = 1;
            range.FirstRow     = 1;
            range.RowCount     = 10;
            rangeOperate.Range = range;
            string folder = TEMPFOLDER;

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

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