Optimize Memory for Existing Worksheets and Identity Corrupt Excel Files in Android
Online, June 12, 2014 (Newswire.com) - The new release of Aspose.Cells for Android v7.0.0 is out now. Aspose.Cells for Android provided memory optimization settings for newly created worksheets by exposing the setMemorySetting method for the Workbook.Settings class. The previously provided approach was useful for minimizing the overall memory cost while working with existing large Microsoft Excel spreadsheets containing huge datasets.
With release 7.0.0, they have enhanced this feature for existing worksheets by exposing a similar method for the Cells class. Now you may use setMemorySetting method provided by the Cells class to cope with the memory issues for situations where large data sets have to be built in memory. The setMemorySettingmethod accepts a parameter of type MemorySetting with the default value NORMAL.
In order to properly utilize this newly introduced feature, memory optimization settings have to be explicitly specified for existing worksheets. Please check the detailed technical article on how to optimize the memory while working with large data sets from our documentation.
http://www.aspose.com/docs/display/cellsandroid/Optimizing+Memory+Usage+while+Working+with+Big+Files+having+Large+Datasets
They have also enhanced the CellsException class to identify potentially damaged or corrupted files when loaded with the Workbook constructor. With the new enhancements integrated, Aspose.Cells for Android API now throws an error of type CellsException whenever it encounters a damaged file.
Aspose.Cells for Android 7.0.0 has also provided fixes for several important issues. For example, problems with converting Excel files to PDF format, rendering & manipulating charts, retrieving & removing OLE objects.
Moreover, they have improved the overall performance as well as the accuracy of results for the formula calculation engine when working with Excel formulas.
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.
- Optimizing Memory Usage while Working with Big Files having Large Datasets: http://www.aspose.com/docs/display/cellsandroid/Optimizing+Memory+Usage+while+Working+with+Big+Files+having+Large+Datasets
- 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.
Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
Phone: 888.277.6734
Fax: 866.810.9465