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