Aspose.Cells for Java

Aspose.Cells for Java API has been upgraded to 8.6.0, and we are pleased to announce, this month’s release contains many useful features and improvements along with some critical bug fixes. Please refer to the release notes of Aspose.Cells for Java 8.6.0 for a full list of enhancements. If you are planning to upgrade the API from any previous version, we strongly suggest you check the Public API Changes section to know what has been changed since your current revision of the API.

While you are downloading the latest build, here is a look at the biggest features in this release.

Assign Macros to Shapes in Excel

Aspose.Cells for Java now provides the Shape.MarcoName property to assign the macros to any control in the spreadsheet. This property is useful in scenarios where the application requirement is to add modules and assign them to the controls for user interaction.

The following sample code explains the usage of Shape.MarcoName property to assign a simple newly added module to button click event.

Manipulate Document Properties in Excel

Aspose.Cells for Java API has exposed the WorkbookMetadata class that is lightweight as compared to Workbook class and allows loading the spreadsheet in order to manipulate the document properties in a simpler & more efficient way. In addition to the aforesaid class, the Aspose.Cells for Java 8.6.0 has also exposed the MetadataOptions class and MetadataType enumeration that can be used to specify the type of properties to be updated.

The following code snippet demonstrates how to use the newly exposed WorkbookMetadata & MetadataOptions classes to add a custom property to the spreadsheet while using Aspose.Cells for Java API.

Restrict the Generation of Frame Scripts for HTML Conversion

Aspose.Cells for Java 8.6.0 has exposed the HtmlSaveOptions.ExportFrameScriptsAndProperties property that can be used to control the generation of scripts such as Frames & Document Properties while exporting the spreadsheets in HTML format. The aforesaid boolean type property has the default value of true, that means; the resultant HTML will contain the scripts related to the frames as per standards of Excel application. Moreover, the resultant HTML code will contain the conditional comments that detects the browser type and adjusts the layout accordingly. Setting this property to false will direct the Aspose.Cells APIs not to generate frame scripts and conditional comments. In this case, the resultant HTML can be viewed in any browser but it cannot be imported back while using Aspose.Cells APIs.

Other Enhancements & Improvements

The most notable enhancements in this release are as follow:

  • Exposed OoxmlSaveOptions.UpdateZoom property that can be used to update the PageSetup.Zoom if PageSetup.FitToPagesWide and/or PageSetup.FitToPagesTall properties have been used to control the Worksheet scaling.
  • Improved the HTML & PDF rendering engines for alignment, layout and shape rendering while handling ODS and other spreadsheet formats.
  • Improved the calculation engine to provide support for CORREL, RSQ, STEYX Excel functions.

Aspose.Cells for Java Resources

The resources, you may need to accomplish your tasks: