Apply Excel Advanced Filter, Import Data from Microsoft Access Database and Localization of Errors using Aspose.Cells for Java 17.7

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 17.7. 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.

Apply Advanced Filter of Microsoft Excel to Display Records Meeting Complex Criteria

Microsoft Excel allows you to apply Advanced Filter on worksheet data to display records that meet complex criteria. You can apply Advanced Filter with Microsoft Excel via its Data > Advanced command as shown in this screenshot.

Aspose.Cells also allows you to apply the Advanced Filter using the Worksheet.advancedFilter() method. For more detail, please see this article.

Import Data from Microsoft Access Database ResultSet Object to the Worksheet

Aspose.Cells can import data to worksheet from ResultSet object which can be created from any database. However, the following article specifically creates ResultSet object from Microsoft Access Database. Since, the code is same for all types of databases, so you can use it in general.

Implement Errors and Boolean Value in Russian or Any Other Language

If you are using Microsoft Excel in Russian Locale or Language or any other Locale or Language, it will display Errors and Boolean values according to that Locale or Language. You can achieve the similar behavior of Microsoft Excel using Aspose.Cells with the GlobalizationSettings class. Please see the following article for more help.

Read Numbers Spreadsheet Developed by Apple Inc. using Aspose.Cells

Numbers is a spreadsheet application developed by Apple Inc. Aspose.Cells can read Numbers spreadsheet but it does not support writing to it. It can read Numbers spreadsheet’s Data, Style and Formulas. Here is the article link for more detail.

Set DefaultFont property of PdfSaveOptions and ImageOrPrintOptions

When saving to PDF or image, Aspose.Cells will first try to use Workbook’s default font. This behavior can be changed using DefaultFont attribute in PdfSaveOptions/ImageOrPrintOptions. For more detail, please see this article.

Determine if Paper Size of Worksheet is Automatic

Most of the time, paper size of the worksheet is automatic. When it is automatic, it is often set as Letter. Sometime user sets the paper size of the worksheet as per their requirements. In this case, the paper size is not automatic. You can find if the worksheet paper size is automatic or not using the Worksheet.getPageSetup().isAutomaticPaperSize() method.

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.

Leave a Reply