Process Large Excel Files with Less Time & Memory Using LightCells API in Java Apps

Aspose's picture
Printer-friendly versionPrinter-friendly version

Aspose.Cells for Java enables Java developers to read large Excel files with LightCells API and can now create transparent images of Microsoft Excel worksheet. It can help to read data from huge Microsoft Excel workbooks with less time & memory usage.

Lane Cove, NSW, Australia., February 17, 2014 - (PressReleasePoint) -

The long awaited version of Aspose.Cells for Java 7.7.1 has been released. This new release supports reading large Excel files with LightCells API. This is a useful feature. Sometimes user need to read data from a huge Microsoft Excel workbook with millions of records and user are always worried about the performance. User want it to take less time and memory to process big files.
The LightCells API is useful in that scenario: to read huge Excel spreadsheets, it uses less memory, so user get better performance and efficiency. The sample code given on the blog page reads a big file and retrieves the total number of cells, a count of strings and a count of formulas for each worksheet in the workbook. Another valuable feature is to find the cells with some particular style or formatting. Aspose.Cells supports finding all cells that have a common style or formatting. Aspose.Cells provides the FindOptions.setStyle() method which user can use to specify the style to search cells for.
User can now create transparent images of Microsoft Excel worksheet. Sometimes, user need to generate an image of their worksheet as a transparent image. For example, user might want to apply transparency to all the cells which have no fill color. We have added support to parse/ read ActiveX controls in the template files.
They have also added a number of enhancements in the new release. In this version, they have refactored the PivotTables module. They’ve made tremendous enhancements and fixed several issues. They have improved the chart to image and sheet to image modules. In this release, they have fixed the issues with manipulating charts and shapes. Several other important issues have also been addressed. For example, issues to do with rendering Microsoft Excel file formats, rendering images from Excel worksheets, rendering shapes and controls data and exporting/converting Excel workbooks to PDF format have been resolved. This release includes plenty of improved features and bug fixes as listed below:

  • Supports reading large files with LightCells
  • Refactor reading and writing pivot table of xlsb
  • Reading large template files with LightCells
  • Reading large template files with LightCells
  • ActiveX Support (Read ActiveX controls such as, buttons)
  • ActiveX Support (Read ActiveX controls such as, buttons)
  • Distinguish between ActiveX Picture or Normal Picture
  • Setting default column width issues are resolved
  • Using Aspose in an OSGi Environment
  • How to set quality in saved Charts
  • Negative value becomes positive after calculate is fixed
  • Header content is getting distorted in the output PDF file is now fixed
  • XLSX to PDF: Result now does have Left & Right Margins
  • Issue with PivotTable is resolved (Change the Filter to other value or label)
  • Cell.getDisplayStyle() now return correct color for Top 10 conditional formatting
  • Alignment of text in shape gets changed from center to left is now fixed
  • Bookmark was created for the blank sheet even though the sheet itself was not present in the output PDF is now fixed
  • Charter header missing is resolved after xlsx saved to PDF file
  • Data loss issues is resolved when excel file is converted to pdf
  • Pivot table is now getting refreshed properly
  • Value changes are fixed after calculation in xlsb file
  • Data Loss and Incorrect label alignment is fixed when excel is converted to PDF
  • Image in heading rows only appearing on first page in PDF is now fixed
  • Incorrect formula processing
  • The shape was transparent in the output pdf is now fixed

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 user briefly how to use Aspose.Cells for performing different tasks like the followings.

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

Press Contact:
Zarfishan Zahid
Suite 163, 79 Longueville Road
Email partially hidden to block spam. Please use the contact form here.
Contact Zarfishan Zahid
Email the contact person for this press release. Do not send spam or irrelevant message.
12 + 8 =

Copy this html code to your website/blog to embed this press release.


Post new comment

6 + 6 =

To prevent automated spam submissions leave this field empty.
Page execution time was 453.42 ms.

Memory usage:

Memory used at: devel_init()=2.13 MB, devel_shutdown()=22.58 MB.