public void CellsRangesGetWorksheetCellsRangeValueTest()
{
string name = BOOK1;
string sheetName = SHEET1;
string folder = TEMPFOLDER;
UpdateDataFile(folder, name);
int?firstRow = 0;
int?firstColumn = 0;
int?rowCount = 3;
int?columnCount = 2;
var response = instance.CellsRangesGetWorksheetCellsRangeValue(name, sheetName, null, firstRow, firstColumn, rowCount, columnCount, folder);
Assert.IsInstanceOf <SaaSposeResponse>(response, "response is SaaSposeResponse");
Assert.AreEqual(response.Code, 200);
var rangeName = "A1:B3";
response = instance.CellsRangesGetWorksheetCellsRangeValue(name, sheetName, rangeName, null, null, null, null, folder);
Assert.IsInstanceOf <SaaSposeResponse>(response, "response is SaaSposeResponse");
Assert.AreEqual(response.Code, 200);
rangeName = "Name_2";
response = instance.CellsRangesGetWorksheetCellsRangeValue(name, sheetName, rangeName, null, null, null, null, folder);
Assert.IsInstanceOf <SaaSposeResponse>(response, "response is SaaSposeResponse");
Assert.AreEqual(response.Code, 200);
}
public void CellsRangesGetWorksheetCellsRangeValueTest()
{
string name = "Book1.xlsx";
string sheetName = "SHEET1";
string folder = null;
new Config().UpdateDataFile(folder, name);
int?firstRow = 0;
int?firstColumn = 0;
int?rowCount = 3;
int?columnCount = 2;
var response = instance.CellsRangesGetWorksheetCellsRangeValue(name, sheetName, null, firstRow, firstColumn, rowCount, columnCount, folder);
var rangeName = "A1:B3";
response = instance.CellsRangesGetWorksheetCellsRangeValue(name, sheetName, rangeName, null, null, null, null, folder);
rangeName = "Name_2";
response = instance.CellsRangesGetWorksheetCellsRangeValue(name, sheetName, rangeName, null, null, null, null, folder);
Console.WriteLine(response);
}