Last updated on October 13, 2020 by Imran Rafique
Blog Home

Customize an Excel Pivot Table and Validate the Entire Worksheet of GridWeb in Java

Aspose.Cells for Java

The Aspose team is pleased to announce the availability of the next version 17.3.0 of Aspose.Cells for Java API. With this release, we have opened up a new set of scenarios for developers, which they can utilize in their Java applications. It covers the new feature to enhance the API control over the pivot tables. Developers can retrieve and set globalization settings of a pivot table. They can also call the client-side script on the page change event of GridWeb control. GridWeb has support to validate the entire Excel worksheet instead of the updated cells. All the regular bug fixes and enhancements are also included. We recommend our clients use the powerful Aspose for Java APIs directly in their Maven Projects with simple configurations. For details on API fixes, please visit the product Release Notes section for this new version. The release notes page highlights any implication made to the public API as well as any non-backward compatible change. Let’s go into the more details of each feature one by one.

Customizing a Pivot Table by Using Globalization Settings

Using Aspose.Cells API, developers can apply various filters to build the corresponding pivot table. After they create a pivot table report and have added the fields that they require, they often want to enhance the layout and format of the report to improve readability and to make it more attractive. To achieve this, Aspose.Cells API allows developers to customize the globalization settings of a pivot table to deal with such scenarios. They can customize the Pivot Total, Sub Total, Grand Total, All Items, Multiple Items, Column Labels, Row Labels, Blank Values text as per the requirements.

Developers can derive a class from the base GlobalizationSettings class. GlobalizationSettings class has various methods to further enhance the Pivot Total, Sub Total, Grand Total, All Items, Multiple Items, Column Labels, Row Labels and Blank Values text. This article shows a code example which works with the layout and format of a report: Customize Globalization Settings for Pivot Table

Call a Client Side Script on Page Change Event of GridWeb

Aspose.Cells for Java includes an independent web-based grid control (com.aspose.cells.GridWeb) which is designed to work with the web applications. Developers can load an existing Excel file into its grid matrix, manipulate it and save it back. The GridWeb control can hold data in multiple pages via its paging feature. Developers might require to call a client side script on page index change event of GridWeb. This feature covers various scenarios. Developers may require to display the page number in their Java applications, so they can call client side script to get the page number. To achieve this, EnablePaging property of the GridWeb should be set as True. This article shows a code example which uses the OnPageChangeClientFunction property of GridWeb control to display the page number: Execute client side function on GridWeb page change

Validate the Entire Worksheet of GridWeb

In the past, GridWeb control was validating the updated cells and not validating the entire Excel worksheet. Using the recent version 17.3.0 of Aspose.Cells API, developers can now validate the entire worksheet on client side before the GridWeb requests to the server. They need to set the needValidateall variable inside the acwmain.js to true. This article explains about how to validate the entire Excel worksheet of GridWeb: Validate entire worksheet instead of only the updated cells

Other Enhancements and Fixes

Aspose.Cells for Java API improvement work never stops because we are listening to the requests of our clients and gradually integrating their needs. Aspose team has made an important enhancement along with other behind the scenes enhancements. It is about to set the long string literals inside the formula.

Several other bug fixes make the API more reliable and functional. It brings quality in rendering the borders of the cells while saving an Excel in other supported formats. The rendering speed of charts has been increased, especially with large data sets. The formula calculation engine is also further enhanced in the new release.

Public API Changes

This revision of Aspose.Cells for Java has made some changes to the Public API. A few of the worth mentioning changes are listed here:

  • GlobalizationSettings.getPivotTotalName() method is added to the GlobalizationSettings class.
  • GlobalizationSettings.getPivotGrandTotalName() method is added to the GlobalizationSettings class.
  • GlobalizationSettings.getMultipleItemsName() method is added to the GlobalizationSettings class.
  • GlobalizationSettings.getAllName() method is added to the GlobalizationSettings class.
  • GlobalizationSettings.getColumnLablesName() method is added to the GlobalizationSettings class.
  • GlobalizationSettings.getRowLablesName() method is added to the GlobalizationSettings class.
  • GlobalizationSettings.getEmptyDataName() method is added to the GlobalizationSettings class.
  • GlobalizationSettings.getSubTotalName(PivotFieldSubtotalType subTotalType) method is added to the GlobalizationSettings class.
  • OnPageChangeClientFunction property is added to the GridWeb Control.

Aspose.Cells for Java Resources

The resources, you may need to accomplish your tasks:

This entry was posted in Aspose.Cells Product Family and tagged , , , . .