public void CellsAutoFilterPutWorksheetFilterExample()
{
string name = "Book1.xlsx";
string sheetName = "SHEET1";
string range = "a1:a10";
int? fieldIndex = 0;
string criteria = "test";
bool? matchBlanks = true;
bool? refresh = true;
string folder = null;
new Config().UpdateDataFile(null, "Book1.xlsx");
var response = instance.CellsAutoFilterPutWorksheetFilter(name, sheetName, range, fieldIndex, criteria, matchBlanks, refresh, folder);
Console.WriteLine(response);
}
public void CellsAutoFilterPutWorksheetFilterTest()
{
// 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 criteria = "test";
bool? matchBlanks = true;
bool? refresh = true;
string folder = TEMPFOLDER;
UpdateDataFile(TEMPFOLDER, BOOK1);
var response = instance.CellsAutoFilterPutWorksheetFilter(name, sheetName, range, fieldIndex, criteria, matchBlanks, refresh, folder);
Assert.IsInstanceOf <SaaSposeResponse>(response, "response is SaaSposeResponse");
Assert.AreEqual(response.Code, 200);
}