public void CellsRangesPostWorksheetCellsRangesTest() { string name = "Book1.xlsx"; string sheetName = "SHEET1"; RangeCopyRequest rangeOperate = new RangeCopyRequest(); //"copydata", new Range(10, 10.1, 1, 1, null, null, 2, 16.8), new Range(20, 10.1, 1, 1, null, null, 2, 16.8), new PasteOptions(true) rangeOperate.Operate = "copydata"; rangeOperate.PasteOptions = new PasteOptions(); rangeOperate.PasteOptions.OnlyVisibleCells = 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; Range range2 = new Range(); //10,10.1,1,1,null,null,2,16.8 range2.ColumnCount = 1; range2.ColumnWidth = 10.1; range2.FirstColumn = 1; range2.FirstRow = 20; range2.RowCount = 10; rangeOperate.Source = range; rangeOperate.Target = range2; string folder = null; new Config().UpdateDataFile(folder, name); var response = instance.CellsRangesPostWorksheetCellsRanges(name, sheetName, rangeOperate, folder); Console.WriteLine(response); }
public void CellsRangesPostWorksheetCellsRangesTest() { // TODO uncomment below to test the method and replace null with proper value string name = BOOK1; string sheetName = SHEET1; RangeCopyRequest rangeOperate = new RangeCopyRequest(); //"copydata", new Range(10, 10.1, 1, 1, null, null, 2, 16.8), new Range(20, 10.1, 1, 1, null, null, 2, 16.8), new PasteOptions(true) rangeOperate.Operate = "copydata"; rangeOperate.PasteOptions = new PasteOptions(); rangeOperate.PasteOptions.OnlyVisibleCells = 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; Range range2 = new Range(); //10,10.1,1,1,null,null,2,16.8 range2.ColumnCount = 1; range2.ColumnWidth = 10.1; range2.FirstColumn = 1; range2.FirstRow = 20; range2.RowCount = 10; rangeOperate.Source = range; rangeOperate.Target = range2; string folder = TEMPFOLDER; UpdateDataFile(folder, name); var response = instance.CellsRangesPostWorksheetCellsRanges(name, sheetName, rangeOperate, folder); Assert.IsInstanceOf <SaaSposeResponse>(response, "response is SaaSposeResponse"); Assert.AreEqual(response.Code, 200); }