public void CellsAutoFilterPutWorksheetDateFilterExample()
{
string name = "Book1.xlsx";
string sheetName = "SHEET1";
string range = "a1:a10";
int? fieldIndex = 0;
string dateTimeGroupingType = "Day";
int? year = 2019;
int? month = 1;
int? day = 1;
int? hour = 1;
int? minute = 1;
int? second = 1;
bool? matchBlanks = true;
bool? refresh = true;
string folder = null;
new Config().UpdateDataFile(null, "Book1.xlsx");
var response = instance.CellsAutoFilterPutWorksheetDateFilter(name, sheetName, range, fieldIndex, dateTimeGroupingType, year, month, day, hour, minute, second, matchBlanks, refresh, folder);
Console.WriteLine(response);
}
public void CellsAutoFilterPutWorksheetDateFilterTest()
{
// 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 dateTimeGroupingType = "Day";
int? year = 2019;
int? month = 1;
int? day = 1;
int? hour = 1;
int? minute = 1;
int? second = 1;
bool? matchBlanks = true;
bool? refresh = true;
string folder = TEMPFOLDER;
UpdateDataFile(TEMPFOLDER, BOOK1);
var response = instance.CellsAutoFilterPutWorksheetDateFilter(name, sheetName, range, fieldIndex, dateTimeGroupingType, year, month, day, hour, minute, second, matchBlanks, refresh, folder);
Assert.IsInstanceOf <SaaSposeResponse>(response, "response is SaaSposeResponse");
Assert.AreEqual(response.Code, 200);
}