private void checkPivotTable(XSSFPivotTable pivotTableBack)
{
Assert.IsNotNull(pivotTableBack.GetPivotCacheDefinition());
Assert.IsNotNull(pivotTableBack.GetPivotCacheDefinition().GetCTPivotCacheDefinition());
CT_CacheFields cacheFields = pivotTableBack.GetPivotCacheDefinition().GetCTPivotCacheDefinition().cacheFields;
Assert.IsNotNull(cacheFields);
Assert.AreEqual(8, cacheFields.SizeOfCacheFieldArray());
Assert.AreEqual("A", cacheFields.cacheField[0].name);
}
private void checkPivotTables(XSSFWorkbook wb)
{
IList <XSSFPivotTable> pivotTables = (wb.GetSheetAt(0) as XSSFSheet).GetPivotTables();
Assert.IsNotNull(pivotTables);
Assert.AreEqual(3, pivotTables.Count);
XSSFPivotTable pivotTable = pivotTables[0];
checkPivotTable(pivotTable);
}
