Apply Advanced Microsoft Excel Filter & Import Data to Worksheet from Access Database using Java

2024-10-31 08:07:43 Computer

1022

Aspose team is pleased to announce the new release of Aspose.Cells for Java 17.7.0. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the APIs. It is recommended for clients to use the powerful Aspose for Java APIs directly in their Maven Projects with simple configurations. Microsoft Excel allows users to apply Advanced Filter on worksheet data to display records that meet complex criteria. Developers can apply Advanced Filter with Microsoft Excel via its Data > Advanced command as shown in this screenshot. Aspose.Cells also allows users to apply the Advanced Filter using the Worksheet.advancedFilter() method. For more detail. 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 users can use it in general. If users 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. Users can achieve the similar behavior of Microsoft Excel using Aspose.Cells with the GlobalizationSettings class. 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. 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 documentation article. 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. Below are some important new features, enhancement and bug fixes part of this release.

? Support Advanced Filter (MS Excel) feature to display records that meet a complex criteria
? ResultSet imports zero instead of null value in XLSX file
? Enhancements needed for data filters and paging features - Aspose.Cells.GridWeb (Java)
? SaveCustomStyleFile is not present in GridWeb (Java)
? CellsHelper.setSignificantDigits() should not be (global) static function
? Some shapes are distorted and changed in Excel to PDF rendering
? Mdashes and ndashes inserted into TextBoxes in charts are not rendered properly in chart's PDF
? Wrong results when using SUMIFS formulas
? Aspose.Cells is unable to calculate the value of cell B4 of Calculations worksheet
? Weird result when converting from Excel to PDF or PDF/A using threads
? Changes to comment author field are not preserved
? Wrong IconSet returned
? Chart's background is missing after setting a picture's data
? Exception in thread "Thread-2" java.lang.OutOfMemoryError: GC overhead limit exceeded
? Exception "Error for ZipFile" is thrown when using OutputFileStream
? com.aspose.cells.CellsException: Invalid password on opening the Excel file

Other most recent bug fixes are also included in this release

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for Java documentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings.

- Apply Advanced Filter of Microsoft Excel to Display Records Meeting Complex Criteria: https://docs.aspose.com/display/cellsjava/Apply+Advanced+Filter+of+Microsoft+Excel+to+Display+Records+Meeting+Complex+Criteria

- Import Data from Microsoft Access Database ResultSet Object to the Worksheet: https://docs.aspose.com/display/cellsjava/Import+Data+from+Microsoft+Access+Database+ResultSet+Object+to+the+Worksheet

Overview: Aspose.Cells for Java

Aspose.Cells is a Java component for spreadsheet reporting without using Microsoft Excel. Other features include creating spreadsheets, opening encrypted excel files, macros, VBA, unicode, formula settings, pivot tables, importing data from JDBC ResultSet and support of CSV, SpreadsheetML, PDF, ODS and all file formats from Excel 97 to Excel 2007. It is compatible with Windows, Linux & Unix and supports all advanced features of data management, formatting, worksheet, charting and graphics.

More about Aspose.Cells for Java

- Homepage of Aspose.Cells for Java: http://www.aspose.com/products/cells/java

- Download Aspose.Cells for Java: http://www.aspose.com/downloads/cells/java

- Online documentation of Aspose.Cells for Java: http://www.aspose.com/docs/display/cellsjava/Home

- Demos of Aspose.Cells for Java: http://www.aspose.com/demos/java-components/aspose.cells/default.aspx

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
http://www.aspose.com/
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465