The Pivot Cache is held inside the memory of Microsoft Excel. When you create a Pivot Table, Microsoft Excel takes a copy of the source data and stores it in the Pivot Cache. Parsing Pivot Cached Records while loading Excel file The following sample code finds the children pivot tables of the pivot table using the PivotTable.getChildren() method and then refreshes them one by one.
Find and Refresh the Nested or Children Pivot Tables of Parent Pivot Table.For more detail, please see the following article. You can find the children pivot tables of a parent pivot table using the PivotTable.getChildren() method. Sometimes, one pivot table uses another pivot table as a data source, so it is called a child pivot table or nested pivot table. Find and Refresh the Nested or Children Pivot Tables of Parent Pivot Table While you are downloading the latest build, here is a look at the most worth mentioning features in this release. Please check the release notes in order to get an idea about what is new and what has been fixed with this revision of Aspose.Cells for Android via Java. We also recommend our clients to use the powerful Aspose for Java APIs directly in their Maven Projects with simple configurations. This release includes many new features, enhancements and other bug fixes that further improve the overall stability and usability of the API. We are pleased to announce the release of Aspose.Cells for Android via Java 18.3.
