public void CellsAutoFilterPutWorksheetCustomFilterExample()
{
string name = "Book1.xlsx";
string sheetName = "SHEET1";
string range = "a1:a10";
int? fieldIndex = 0;
string operatorType1 = "LessOrEqual";
string criteria1 = "test";
bool? isAnd = false;
string operatorType2 = "LessOrEqual";
string criteria2 = "test";
bool? matchBlanks = true;
bool? refresh = false;
string folder = null;
new Config().UpdateDataFile(null, "Book1.xlsx");
var response = instance.CellsAutoFilterPutWorksheetCustomFilter(name, sheetName, range, fieldIndex, operatorType1, criteria1, isAnd, operatorType2, criteria2, matchBlanks, refresh, folder);
Console.WriteLine(response);
}
public void CellsAutoFilterPutWorksheetCustomFilterTest()
{
// TODO uncomment below to test the method and replace null with proper value
string name = BOOK1;
string sheetName = SHEET1;
string range = RANGE;
int? fieldIndex = 0;
string operatorType1 = "LessOrEqual";
string criteria1 = "test";
bool? isAnd = false;
string operatorType2 = "LessOrEqual";
string criteria2 = "test";
bool? matchBlanks = true;
bool? refresh = false;
string folder = TEMPFOLDER;
UpdateDataFile(TEMPFOLDER, BOOK1);
var response = instance.CellsAutoFilterPutWorksheetCustomFilter(name, sheetName, range, fieldIndex, operatorType1, criteria1, isAnd, operatorType2, criteria2, matchBlanks, refresh, folder);
Assert.IsInstanceOf <SaaSposeResponse>(response, "response is SaaSposeResponse");
Assert.AreEqual(response.Code, 200);
}
