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); }