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


Aspose.Cells for Android now enable Android Developers to create transparent images of Microsoft Excel worksheet and to find cells with particular style or formatting and read large Excel files with the LightCells API.

Lane Cove (I-Newswire) February 3, 2014 - 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






About Aspose Pty Ltd

Aspose is a leading vendor of .NET, Java and SharePoint development components, Android and renderin   More..g extensions for platforms such as Microsoft SQL Server Reporting Services and JasperReports. Aspose's core focus is to offer the most complete and powerful set of file management products on the market. Aspose products support some of the most popular file formats in business, including: Word documents, Excel spreadsheets, PowerPoint presentations, PDF documents, Microsoft Visio diagrams and Microsoft Project files. We also offer OCR and image manipulation tools.Less..

Contact Information

Aspose Pty Ltd
Aspose
Suite 163, 79 Longueville Road
2066
Phone : 888.277.6734

Published in:

Computer > Programming

Published On:

February 3, 2014

Print Release:

Print Release

If you have questions regarding information in this press release contact the company listed above. I-Newswire.com is a press release service and not the author of this press release.The information that is on or available through this site is for informational purposes only and speaks only as of the particular date or dates of that information. As some companies and PR Agencies submit their press releases once per week,month or quarter, make sure to check the official company website for accurate release dates as our site displays the I-Newswire.com press release distribution date only.We do not guarantee the accuracy or completeness of information on or available through this site, and we are not responsible for or omissions in that information or for actions taken in reliance on that information.


Related Releases

Naverisk - Powers Up Security with AuthAnvil by Scorpion Software.
Naverisk, the market leading unified RMM and Service Desk platform for MSP's and IT service providers, Powers up Security and Authentication with Scorpion Software's AuthAnvil Two Factor Auth and Single Sign On.

Zimory Appoints New CEO and Fortifies Management Team
Effective April 9, 2014, Dr. Randolf Roth (44) is becoming the new CEO of Zimory, the Berlin-based specialist for cloud management software. In addition, Josef Glöckl-Frohnholzer is strengthening Management Team as CSO.

Play & Enjoy The Excitement of IPL Online Cricket Games
Today, there are several online websites that offer the users to play IPL games totally free of cost.

MuseGlobal, in Conjunction with EduLib, a Member of the MuseGlobal Group, Announces the Availability of Muse Version 2.7.
MuseGlobal, in conjunction with EduLib, a member of the MuseGlobal group, announces the availability of Muse version 2.7.

Autosofted Releases Automation Software That Eliminates Monotonous Computer Tasks
Autosofted provides free software that helps automate actions involving the mouse and keyboard.