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