Convert Excel to PDF using Java and Optimize Memory Usage for Large Excel Files

Aspose's picture
Printer-friendly versionPrinter-friendly version

Aspose.Cells for Java API now supports optimizing memory usage when working with big Microsoft Excel files and large data sets and can set time for generating a PDF documents during Excel to PDF conversion.

Lane Cove, NSW, Australia., April 14, 2014 - (PressReleasePoint) -

The long awaited version of Aspose.Cells for Java 8.0.0 has been released. This release supports optimizing memory usage when working with big Microsoft Excel files in java 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 the 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.
Aspose.Cells also allows to get/set the time of generating the PDF documents for Excel to PDF conversion in java, sometimes user might need to set their 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 using Java. User can show formulas instead of the calculated values in Microsoft Excel using the Show Formulas option from the Formulas ribbon. Once, user enable it, Microsoft Excel displays formulas inside the worksheet.
They have added a number of enhancements and fixes to this release. They have also fixed some exceptions which were thrown when reading and writing Excel files and rendering images from worksheets. They have improved the chart to image and sheet to image modules and fixed issues with manipulating charts and shapes as well.
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 and exporting Excel workbooks to PDF format in java have been resolved in this release. A few other improvements are also made to Aspose.Cells for Java’s formula calculation engine.
This release includes plenty of improved features and bug fixes 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.
Newly added documentation pages and articles
Some new tips and articles have now been added into Aspose.Cells for Java documentation that may guide user briefly how to use Aspose.Cells for performing different tasks like the followings.

Overview: Aspose.Cells for Java
Aspose.Cells is a Java component for spreadsheet reporting without using Microsoft Excel. Other features include creating spreadsheets, opening encrypted excel files, macros, VBA, unicode, formula settings, pivot tables, importing data from JDBC ResultSet and support of CSV, SpreadsheetML, PDF, ODS and all file formats from Excel 97 to Excel 2007. It is compatible with Windows, Linux & Unix and supports all advanced features of data management, formatting, worksheet, charting and graphics.

Press Contact:
Zarfishan Zahid
Suite 163, 79 Longueville Road
Email partially hidden to block spam. Please use the contact form here.
Contact Zarfishan Zahid

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


Post new comment

3 + 3 =

Press Release

Syndicate content
Post date
05/02/2016 - 01:14 Aspose.Newsletter May 2016: .NET, Java APIs for Working with Business Files & Other News
04/29/2016 - 00:19 Detect Flattened PSD, DWG File to PDF Conversion, Apply Median & Wiener Filters using Java
04/28/2016 - 01:17 Search Messages with Paging Support using IMAP & Sending Calendar Invitation using .NET
04/26/2016 - 03:36 Glued Visio Shapes Retrieval, VSD to VDX & PDF Export are Enhanced using .NET
04/25/2016 - 01:17 List Searched Messages with Paging Support & Move Message using IMAP in Java Apps
04/22/2016 - 00:52 Saving Shape & Office-Math Nodes to SVG, RC4 Encryption Support in Java or .NET Apps
04/19/2016 - 03:20 Export Presentation to PDF Notes with Custom Slide Size & Set Series Plot Options using .NET
04/18/2016 - 00:54 Protect Glued Shapes Data & Enhanced Content Formatting of Visio Diagram using Java
04/15/2016 - 00:06 Use Aspose.Words for Jasper Reports via REST Web Service & JasperServer 6.2 Support
04/14/2016 - 01:17 Universal 3D Format Export & Protect Vertex Element Data While Triangulating Mesh using .NET
04/12/2016 - 01:05 Add Alternative Text for Image & Read OneNote Online (SharePoint) File Format inside .NET Apps
04/11/2016 - 01:06 Add Transparent Text in PDF, Merge Large PDFs & Control Z-Order of Rectangle using Java
04/08/2016 - 00:36 Add Custom XML Parts to Spreadsheets & Implement Custom Calculation Engine using Java
04/07/2016 - 01:22 Change DataSet without Rebuilding Entire DataSet & Improved Rows/Columns Formatting
04/05/2016 - 01:03 Aspose.Newsletter April 2016: Powerful APIs for Working with 3D File Formats & Other News
04/04/2016 - 00:23 SmartArt Text Extraction & Rendering to PDF/Image, Setting Presentation Slide Frame using Java
03/31/2016 - 23:30 Read Project Data from Primavera SQLite Database & New Date Time Format Rendering using Java
03/31/2016 - 02:17 Perform OCR Operation on Transparent Images & Busy Indicator in Template Editor using .NET
03/28/2016 - 23:31 Apply Median/Wiener Filters, Detect Flattened PSD & Improved DWG to PDF Conversion using .NET
03/27/2016 - 22:57 Fast Extraction of Plain Text Support & Improved Font Substitution in Word Docs using Java or .NET
Copy and paste this code to display this page on your website .
Syndicate content