Read Large Excel Files with LightCells API and Search Cells Based on Formatting Using Android App

Online, February 2, 2014 (Newswire.com) - The latest version of Aspose.Cells for Android 4.0.0 has been released. It enables Android Developers to find cells with 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 you can use to specify the style to search cells for.

You can now create transparent images of Microsoft Excel worksheet. Sometimes, you need to generate an image of your worksheet as a transparent image. For example, you might want to apply transparency to all cells that have no fill color. Aspose.Cells provides the ImageOrPrintOptions.setTransparent() method which applies transparency to a worksheet image.

This new release also supports reading large Excel files with the LightCells API. This is a useful feature when you need to read data from a huge Microsoft Excel workbook with millions of records and you are worried about the performance. They have also added a number of enhancements in the new release.

In this version, they have refactored the PivotTables module. They've made great enhancements and fixed several issues. They have improved the chart to image and sheet to image modules. 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 exporting Excel workbooks to PDF format have been resolved. This release includes plenty of new & enhanced features 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 is enhanced
- Using Aspose in an OSGi Environment
- How to set quality in saved Charts
- Negative value becomes positive after calculate is now fixed
- Header content is getting distorted in the output PDF file is fixed
- XLSX to PDF: Result now 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
- Charter header missing after xlsx saved to PDF file is now fixed
- Data loss is corrected when excel file is converted to pdf
- Pivot table is now getting refreshed properly
- Value changes after calculation in xlsb file is now fixed
- 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
- Incorrect formula processing is corrected
- The shape is now transparent in the output pdf

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 Android documentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings.

- Find Cells with Specific Style: http://www.aspose.com/docs/display/cellsandroid/Find+cells+with+specific+style

- Create Transparent Image of Excel Worksheet: http://www.aspose.com/docs/display/cellsandroid/Create+Transparent+Image+of+Excel+Worksheet

Overview: Aspose.Cells for Android

Aspose.Cells for Android is a MS Excel spreadsheet component that allows programmer to develop android applications for reading, writing & manipulate Excel spreadsheets (XLS, XLSX, XLSM, SpreadsheetML, CSV, tab delimited) and HTML file formats without needing to rely on Microsoft Excel.It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, custom charts, spreadsheet formatting, drawing objects like images, OLE objects & importing or creating charts.

More about Aspose.Cells for Android

- Homepage of Aspose.Cells for Android:http://www.aspose.com/android/excel-component.aspx

- Download Aspose.Cells for Android: http://www.aspose.com/community/files/74/android-components/aspose.cells-for-android/default.aspx

- Online documentation of Aspose.Cells for Android:www.aspose.com/docs/display/cellsandroid/Home

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

- Post your technical questions/queries to Aspose.Cells for Android Forum:
http://www.aspose.com/community/forums/aspose.cells-product-family/19/showforum.aspx

- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for Android blog:http://www.aspose.com/community/blogs/aspose.cells-product-family/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