public void CellsPivotTablesGetWorksheetPivotTableFilterTest()
{
string name = "TestCase.xlsx";
string sheetName = "SHEET4";
int? pivotTableIndex = 0;
PivotFilter pivotFilter = new PivotFilter();
pivotFilter.FieldIndex = 1;
pivotFilter.FilterType = "Count";
AutoFilter autoFilter = new AutoFilter();
autoFilter.FilterColumns = new List <FilterColumn>();
FilterColumn filterColumn = new FilterColumn();
filterColumn.FilterType = "Top10";
filterColumn.FieldIndex = 0;
filterColumn.Top10Filter = new Top10Filter();
filterColumn.Top10Filter.Items = 1;
filterColumn.Top10Filter.IsTop = true;
filterColumn.Top10Filter.IsPercent = false;
autoFilter.FilterColumns.Add(filterColumn);
pivotFilter.AutoFilter = autoFilter;
bool? needReCalculate = true;
string folder = "TEMPFOLDER";
new Config().UpdateDataFile(folder, name);
var response = instance.CellsPivotTablesPutWorksheetPivotTableFilter(name, sheetName, pivotTableIndex, pivotFilter, needReCalculate, folder);
int filterIndex = 0;
response = instance.CellsPivotTablesGetWorksheetPivotTableFilter(name, sheetName, pivotTableIndex, filterIndex, folder);
Console.WriteLine(response);
}
public void CellsPivotTablesGetWorksheetPivotTableFilterTest()
{
// TODO uncomment below to test the method and replace null with proper value
string name = PivTestFile;
string sheetName = SHEET4;
int? pivotTableIndex = 0;
PivotFilter pivotFilter = new PivotFilter();
pivotFilter.FieldIndex = 1;
pivotFilter.FilterType = "Count";
AutoFilter autoFilter = new AutoFilter();
autoFilter.FilterColumns = new List <FilterColumn>();
FilterColumn filterColumn = new FilterColumn();
filterColumn.FilterType = "Top10";
filterColumn.FieldIndex = 0;
filterColumn.Top10Filter = new Top10Filter();
filterColumn.Top10Filter.Items = 1;
filterColumn.Top10Filter.IsTop = true;
filterColumn.Top10Filter.IsPercent = false;
autoFilter.FilterColumns.Add(filterColumn);
pivotFilter.AutoFilter = autoFilter;
bool? needReCalculate = true;
string folder = TEMPFOLDER;
UpdateDataFile(folder, name);
var response = instance.CellsPivotTablesPutWorksheetPivotTableFilter(name, sheetName, pivotTableIndex, pivotFilter, needReCalculate, folder);
Assert.AreEqual(response.Code, 200);
int filterIndex = 0;
response = instance.CellsPivotTablesGetWorksheetPivotTableFilter(name, sheetName, pivotTableIndex, filterIndex, folder);
Assert.IsInstanceOf <PivotFilterResponse>(response, "response is PivotFilterResponse");
Assert.AreEqual(response.Code, 200);
}
