Refresh Children Pivot Tables of Pivot Table and Parse Pivot Cached Records while loading Excel file with Aspose.Cells for Java 18.1

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

Aspose.Cells for JavaWe are pleased to announce the release of Aspose.Cells for Java 18.1. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the APIs. We also recommend our clients to use the powerful Aspose for Java APIs directly in their Maven Projects with simple configurations. 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 Java. Here is a look at the major features in this release.

Find and Refresh the Nested or Children Pivot Tables of Parent Pivot Table

Sometimes, one pivot table uses other pivot table as a data source, so it is called a child pivot table or nested pivot table. You can find the children pivot tables of a parent pivot table using the PivotTable.getChildren() method. For more detail, please see the following article.

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.

//Load sample Excel file
Workbook wb = new Workbook("sampleRefreshChildrenPivotTables.xlsx");

//Access first worksheet
Worksheet ws = wb.getWorksheets().get(0);

//Access third pivot table
PivotTable ptParent = ws.getPivotTables().get(2);

//Access the children of the parent pivot table
PivotTable[] ptChildren = ptParent.getChildren();

//Refresh all the children pivot table
int count = ptChildren.length;
for (int idx = 0; idx < count; idx++)
{
	//Access the child pivot table
	PivotTable ptChild = ptChildren[idx];

	//Refresh the child pivot table
	ptChild.refreshData();
	ptChild.calculateData();
}

Parsing Pivot Cached Records while loading Excel file

When you create a Pivot Table, Microsoft Excel takes a copy of the source data and stores it in the Pivot Cache. The Pivot Cache is held inside the memory of Microsoft Excel. When you load your Excel file inside the Workbook object, you can decide whether you also want to load the records of Pivot Cache or not, using the LoadOptions.ParsingPivotCachedRecords property. The default value of this property is false. If Pivot Cache is quite big, it can increase the performance. For more detail, please see the following article.

Export Document, Workbook and Worksheet Properties in Excel to HTML conversion

When Microsoft Excel file is exported to HTML using Microsoft Excel or Aspose.Cells APIs, it also exports various types of Document, Workbook and Worksheet properties. You can avoid exporting these properties by setting the HtmlSaveOptions.ExportDocumentProperties, HtmlSaveOptions.ExportWorkbookProperties and HtmlSaveOptions.ExportWorksheetProperties as false. The default value of these properties is true. For more detail, please see the following article.

Exclude unused Styles during Excel to HTML conversion

Microsoft Excel file may contain many unnecessary unused styles. When you export the Excel file to HTML file format, these unused styles are also exported. This could increase the size of HTML. You can exclude the unused styles during the conversion of Excel file to HTML using the HtmlSaveOptions.ExcludeUnusedStyles property. For more detail, please see the following article.

Handle Automatic Units of Chart Axis like Microsoft Excel

Early versions of Aspose.Cells were not able to handle automatic units of chart axis properly when chart is rendered to image or pdf. Now, Aspose.Cells supports the handling of automatic units of chart axis. There is no code change. Just convert your chart into image or pdf and it will render chart axis just like Microsoft Excel renders it. For more detail, please see the following article.

Create PdfBookmarkEntry for Chart Sheet

Earlier, Aspose.Cells would create PdfBookmarkEntry for normal sheet. But now Aspose.Cells can also create PdfBookmarkEntry for chart sheet. Since, chart sheet does not have any other cell except cell A1, so it will create PdfBookmarkEntry for cell A1 only. For more detail, please see the following article.

Aspose.Cells for Java Resources

The resources, you may need to accomplish your tasks:


To keep up with our news, you can follow us on Twitter or follow our Facebook page.