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

Aspose's picture
Printer-friendly versionPrinter-friendly versionPDF versionPDF version

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, NSW, Australia., February 2, 2014 - (PressReleasePoint) -

The latest version of Aspose.Cells for Android 4.0.0 has been released. In this release, user can 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 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 your worksheet as a transparent image. For example, user 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 user need to read data from a huge Microsoft Excel workbook with millions of records and user 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 conversion in android and sheet to image conversion in android 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 user briefly how to use Aspose.Cells for performing different tasks like the followings.
 

 
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.


Press Contact:
Zarfishan Zahid
Suite 163, 79 Longueville Road
888.277.6734
http://aspose.com
*********.*****@*s**s*.com
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.
6 + 12 =


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

Comments

Post new comment

1 + 5 =