Amjad Sahi March 23, 20170 Comments

Customize Pivot Tables in Excel Files and Call Client-side Scripts for GridWeb in .NET

Customize Pivot Tables in Excel Files and Call Client-side Scripts for GridWeb in .NET

March 23, 2017
Share on FacebookTweet about this on TwitterShare on LinkedIn

Aspose.Cells for .NET logoWe are pleased to announce our next version of Aspose.Cells for .NET v17.3.0. The new release includes some valuable features and other enhancements with critical bug fixes. It adds a new feature to enhance the API control over the Pivot Tables. Developers can retrieve and set globalization settings of a Pivot Table for their requirements. They can also call client-side scripts on the page change event of Aspose.Cells.GridWeb control. Our clients may get the powerful Aspose for .NET APIs directly from NuGet repository. Please see the detailed release notes in order to get an idea about what is new and what has been fixed with this version of Aspose.Cells for .NET. The release notes also list any changes made to the public API such as added, renamed, removed or deprecated members (if any) as well as any non-backward compatible change made to Aspose.Cells for .NET.

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 add the fields (they require), they often want to enhance the layout and formatting 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 their 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 the report: Customize Globalization Settings for Pivot Table

Call a Client Side Script on Page Change Event of GridWeb

Aspose.Cells for .NET also includes an independent web-based grid control (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 .NET 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 on how to validate the entire Excel worksheet of GridWebValidate entire worksheet instead of only the updated cells

Other Enhancements and Fixes

Aspose.Cells for .NET 17.3.0 has enhanced its core for more stability as well as fixed many critical bugs. Moreover, there are numerous minor enhancements in order to improve the overall usage of the API. A few of the worth mentioning enhancements are as follow.

  • An enhancement is made when changing pivot data source that was adding additional LinkSource
  • Handled an exception, “Index out of Array exception”.

Furthermore, in this release, we have fixed several other issues. For example, issues around reading/writing MS Excel file formats, manipulating Pivot Tables, rendering shapes and drawing objects, rendering and manipulating charts, rendering HTML to Excel and vice versa, rendering images from Excel worksheets, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. The formula calculation engine is further enhanced in the new release.

Changes to the Public API

This version of Aspose.Cells for .NET has made some changes to the Public API. A few of the worth mentioning changes are as follow:

  • 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 .NET Resources

The resources, you may need to accomplish your tasks:

Leave a comment

Posted inAspose.Cells Product Family
 

Related Articles