Aspose.Cells for Java

Aspose team is pleased to announce the release of Aspose.Cells for Java 17.5. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the API. We also recommend our clients 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.

Support PDF/A-1a compliance in PdfSaveOptions

Aspose.Cells now allows you to create PDF with PDF/A-1a – Level A (accessible) conformance. It already supports PDF/A-1b – Level B (basic) conformance. Following code snippet demonstrates how to convert an Excel file to PDF compatible with PDFA-1a.

//Open an Excel file.
Workbook wb = new Workbook("Book1.xlsx");
//Create pdf save options and set its compliance to PDFA-1a.
PdfSaveOptions opts = new PdfSaveOptions();
//Save the output pdf"outputCompliancePdfA1a.pdf", opts);

Please see this article that explains how to convert your Excel file into PDF with PDF/A-1a conformance.

Remove existing Printer Settings in Excel file

Sometimes developers want to remove existing Printer Settings in Excel file. These settings are found inside the “[file “root”]\xl\printerSettings” folder in the form of .bin files. Aspose.Cells can remove existing printer settings in the Excel workbook. For more detail, please see this article.

Implement Custom Page Size Options for the Worksheet

There is no direct option available to create custom paper sizes in MS Excel, however, you can set custom paper size of your desired worksheets when rendering Excel file to the PDF file format. This document explains how to set a custom paper size of a worksheet using Aspose.Cells APIs.

Shift First Row down when inserting Cells Data Table Rows

Earlier, Aspose.Cells does not shift first row down when inserting rows. But for some users’ requirements, it has supported this feature now. Please see this article for more detail about this feature. It also shows an example of ICellsDataTable implementation.

Copy Page Setup Settings from Source Worksheet into Destination Worksheet

When you copy the worksheet into another worksheet, then page setup settings of the source worksheet are not copied to the destination worksheet. Please use PageSetup.copy() method to copy the setting of the page setup from source to destination worksheet. Please see the following article for more detail.

Changes to the Public API

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

  • Added PageSetup.copy(PageSetup source,CopyOptions copyOptions) method that copies the settings of the Page Setup.
  • Added PageSetup.customPaperSize() method that sets the custom paper size, in the unit of inches.
  • Added PageSetup.getPrinterSettings()/setPrinterSettings() property that gets and sets the settings of the default printer.
  • Added enum member PdfCompliance.PDF_A_1_A that represents PDF format compatible with PDFA-1a.

Aspose.Cells for Java Resources

The resources, you may need to accomplish your tasks: