• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Junilu Lacar
  • Liutauras Vilda
  • Paul Clapham
  • Jeanne Boyarsky
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Piet Souris
  • Carey Brown
  • Jesse Duncan
  • Frits Walraven
  • Mikalai Zaikin

Create Transparent Images from Worksheets & Reading Large Excel Files in Java

Ranch Hand
Posts: 714
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What is new in this release?

The long awaited version of Aspose.Cells for Java 7.7.1 has been released. This new release supports reading large Excel files with LightCells API. This is a useful feature. Sometimes you need to read data from a huge Microsoft Excel workbook with millions of records and you are always worried about the performance. You want it to take less time and memory to process big files. The LightCells API is useful in that scenario: to read huge Excel spreadsheets, it uses less memory, so you get better performance and efficiency. The sample code given on the blog page reads a big file and retrieves the total number of cells, a count of strings and a count of formulas for each worksheet in the workbook. Another valuable feature is to find the cells with some 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 the cells which have no fill color. We have added support to parse/ read ActiveX controls in the template files. We have also added a number of enhancements in the new release. In this version, we have refactored the PivotTables module. We’ve made tremendous enhancements and fixed several issues. We have improved the chart to image and sheet to image modules. In this release, we have fixed the issues with manipulating charts and shapes. 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 controls data and exporting Excel workbooks to PDF format have been resolved. This release includes plenty of improved features and bug fixes 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 issues are resolved
- Using Aspose in an OSGi Environment
- How to set quality in saved Charts
- Negative value becomes positive after calculate is fixed
- Header content is getting distorted in the output PDF file is now fixed
- XLSX to PDF: Result now does 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 is now fixed
- Charter header missing is resolved after xlsx saved to PDF file
- Data loss issues is resolved when excel file is converted to pdf
- Pivot table is now getting refreshed properly
- Value changes are fixed after calculation in xlsb file
- 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 is now fixed
- Incorrect formula processing
- The shape was transparent in the output pdf is now fixed

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 you briefly how to use Aspose.Cells for performing different tasks like the followings.

- Converting Worksheet to Image
- Create Transparent Image of Excel Worksheet

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.

More about Aspose.Cells for Java

- Homepage of Aspose.Cells for Java
- Download Aspose.Cells for Java
- Online documentation of Aspose.Cells for Java
- Demos of Aspose.Cells for Java
- Post your technical questions/queries to Aspose.Cells for Java Forum
- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for Java blog

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Aspose - The .NET and Java component publisher
Phone: 888.277.6734
Fax: 866.810.9465
Consider Paul's rocket mass heater.
    Bookmark Topic Watch Topic
  • New Topic