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); }
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); }