• Home
  • Android Themes
  • Optimized Memory Usage for Big Excel Files with Large Data Sets in Android Apps

Optimized Memory Usage for Big Excel Files with Large Data Sets in Android Apps

What is new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for Android 6.0.0 . It supports optimizing memory usage when working with big Microsoft Excel files with large data sets. When building a workbook with large data sets, or reading a big template file, the total amount of RAM the process will use is always a concern. Aspose.Cells provides measures that can be adopted to cope with this challenge. Aspose.Cells provides some relevant options to lower, reduce and optimize memory usage. For example, the MemorySetting.MEMORY_PREFERENCE option optimizes memory use for the cells data to decrease the overall memory cost. It also allows to get/set the time of generating the PDF documents for Excel to PDF conversion, sometimes you might need to set your desired custom DateTime for the PDF files. There is another valuable Microsoft Excel’s features is to show formulas instead of values in a worksheet. You can show formulas instead of the calculated values in Microsoft Excel using the Show Formulas option from the Formulas ribbon. Once, you enable it, Microsoft Excel displays formulas inside the worksheet. You can achieve this using Aspose.Cells APIs. Aspose.Cells provides a Worksheet.setShowFormulas() method which you can set to true to set Microsoft Excel to display formulas. We have added a number of enhancements and fixes in the new release. We have improved the chart to image and sheet to image modules. Several other important issues have also been addressed. For example, issues with rendering Excel files to HTML file format, applying formatting, auto-filtering data in List objects/Tables. A few other improvements are also made to Aspose.Cells for Android’s formula calculation engine. This release includes plenty of new & enhanced features as listed below

Get Starting Row/Column and Ending Row/Column indexes for a page of worksheet
Support for Show Formulas MS Excel feature
Aspose.Cells and Maven dependencies
Set the creation time in the generated PDF
Typo in method name – SeriesCollection.setSecondCategoryData
Custom Series DataLabel Separator
Cell.DisplayStringValue did not calculate accurately for spaces determined by column width and ‘*’ in style’s custom
setExportActiveWorksheetOnly change align of table in HTML
Background image is now copied to destination workbook when calling Workbook.copy
Text inside an image appears to be Mirrored while saving an excel workbook as PDF is now fixed.
Some words are separated when saving to PDF is now fixed
Table autofilter is enhanced and work in xls and xlsx format properly
When export to HTML, cells covered by image loses background color is fixed
Background image path is now corrected
Vertical text issue is resolved
Formatting issue of shapes/controls in Excel to PDF conversion are fixed
Incorrect wrapping of Axis Labels is fixed when converting XLSX to PDF
DateTime columns now correctly read from CSV with European locale
Image output mirrored while transforming an excel worksheet into PDF is now fixed
Apose.Cells: embedded sigma plot chart now rendered correctly to PDF/images
Incorrect wrapping of Axis Labels is fixed when converting XLSX to PDF
Data is now corrected in the output pdf
Background image path is now corrected
Export Shapes to html with error background color is fixed
Recalculation cell’s formula
Row hidden and row height issues are resolved

Other most recent bug fixes are also included in this release.

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
Download Aspose.Cells for Android
Online documentation of Aspose.Cells for Android
Demos of Aspose.Cells for Android

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Aspose – The .NET and Java component publisher
[email protected]
Phone: 888.277.6734
Fax: 866.810.9465

MIRROR LINK (If the above links doesn’t work or there is no link, Try this one)

Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,