Load Only Visible Worksheets from Existing Spreadsheet & Create Excels Built-in Styles using Java

2024-11-01 11:20:35 Computer

705

We are pleased to announce the new release of Aspose.Cells for Java 8.6.3. This months release contains many useful features and improvements along with some critical bug fixes. Aspose.Cells APIs provide a set of classes for the developers to influence the spreadsheet loading mechanism. While using the LoadOptions & LoadDataOptions classes, the developers can set a number of options such as force the API to load specific worksheets, where the worksheets can be specified via their indices or names. It has exposed another useful property for the LoadDataOptions class which allows to load only the visible worksheets from an existing spreadsheet, where the hidden worksheets will be simply ignored and will not be available in the Aspose.Cells object model for any processing. The newly exposed property is of type Boolean; setting it to true means that the API will ignore the hidden worksheets and load only the visible worksheets for further processing. It has exposed a method that can be used to create an object of the Style class that corresponds to one of the built-in styles offered by the Excel application. The Workbook.createBuiltinStyle method accepts a constant from the enumeration BuiltinStyleType. Please note, with previous releases of the Aspose.Cells APIs, same task could be accomplished via StyleCollection.createBuiltinStyle method but as the recent releases of Aspose.Cells APIs have removed the StyleCollection class from the public API therefore the newly exposed Workbook.createBuiltinStyle method can be considered as an alternative approach to achieve the same goal. The most notable enhancements in this release includes, It has exposed the ImportTableOptions.setHtmlString attribute which directs the API to parse the HTML tags while importing data onto the Worksheet and set the parsed result as cell value. Please note, Aspose.Cells APIs already provide the Cell.setHtmlString attribute to perform this task for a single cell, however, while importing data in bulk, the ImportTableOptions.setHtmlString attribute (when set to true) tries to parse all the supported HTML tags and sets the parsed results to the corresponding cells, This release has addressed some formatting issues reported for the XML Spreadsheet 2003 to XLSX conversion and Enhanced the PDF rending engine to maximize the fidelity for the Excel Chart objects. This release includes several enhanced features and bug fixes as listed below

How to create BuiltinStyleType with Workbook.Styles being obsoleted
Failure in processing upper-case image source tag when converting from HTML to Excel
Hidden cell is wrongly displayed in output HTML
Repeat All Item Labels option is not working for the PivotTable
Text in the Text Box is getting cut-off while rendering the spreadsheet to PDF
Extra column in the HTML output of Excel document
Cells.importCSV() not using existing cells' formatting
API returns #DIV/0! where Excel calculates the value correctly
Calculated formula values do not match with Excel
Issue with Cells.inserRange() method which is not inserting range fine
Formula calculation unexpectedly produces #NAME?
XLS to PDF Conversion - Font and Font Size are not correctly converted
DataBar to Image: Right borders are not rendered
Legends of the graph are formatted with different colors
Long hyphens don't display appropriately in the output PDF/Image for the chart
Wrong Chart-Area appears in chart's PDF
Wrong border color in Chart's PDF using Chart.toPdf
Small white line appears when generating Chart's PDF with Chart.toPdf
Vertical rule appears behind other graphics in Chart's PDF using Chart.toPdf
Wrong X-axis labels appear in Chart's PDF using Chart.toPdf
X axis scale interval has changed in Chart's PDF while using Chart.toPdf
Extra label and rule is added on Y-axis and labels of X-axis are lost in Chart's PDF while using Chart.toPdf
Xaxis line rendered in front of chart content in Chart's PDF while using Chart.toPdf
All x-axis labels missing in Chart's PDF while using Chart.toPdf
Legend icon in chart is smaller while rendering spreadsheet to PDF
Trendline in chart is shorter while rendering spreadsheet to PDF
Horizontal Grid-Lines of chart are not appearing properly in PDF
Legend is getting trimmed in chart while converting Chart to PDF
One image is missing and one is incorrectly rotated in the rendered PDF - Excel to PDF Conversion
Format of the Chart Data Labels has changed while rendering to PDF
Unable to change the one of the Data Label's text
Legend is getting trimmed in chart while converting spreadsheet to PDF
Axis title has been displaced in chart while converting spreadsheet to PDF
Hidden formula has been rendered in chart while converting spreadsheet to PDF
Source and Copyright elements in chart are not on the same height/location in the output PDF
Subscripts in the axis description of a chart is not shown properly in the output PDF file format
Chart data labels is error
Words appear to be concatenated in PDF/Image output of excel chart
Chart's Legend Sequence has Changed while rendering Spreadsheet to PDF format
Thickness of bar lines of Growth Chart is decreased
Font Size is not preserved while converting XML Spreadsheet 2003 to other formats
WorksheetCollection.getRangeByName returns null if referenced named range is in Worksheet with name containing exclamation mark
Macro gets removed from XLS after inserting OleObject
Column widths are not preserved when converting from "XML Spreadsheet 2003" format to XLSX format
Vertical alignment is not preserved when converting from "XML Spreadsheet 2003" format to XLSX format
Inserting Ole Objects cause popup error - Cannot start the source application for this object
Autofill feature re-produces the formula as a 'normal' formula instead of keeping the array characteristic
Could not load the excel sheet
setXValues does not work like Excel for workbook-scoped named ranges
Aspose.Cells not reading date from Excel 2013 xlsx document
Copying one sheet from one workbook to another does not keep the legend size in the graphs
Excel 2013 - Chart changes color after processing
Simple nested objects are not working in Smart Markers
Issue with List data validation in GridWeb
Selected Range is not correct in GridWeb Java

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.

- Load Visible Sheets Only: http://www.aspose.com/docs/display/cellsjava/Load+Visible+Sheets+Only

- Using Built-in Styles: http://www.aspose.com/docs/display/cellsjava/Using+Built-in+Styles

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: http://www.aspose.com/java/excel-component.aspx

- Download Aspose.Cells for Java: http://www.aspose.com/community/files/72/java-components/aspose.cells-for-java/default.aspx

- Online documentation of Aspose.Cells for Java: http://www.aspose.com/docs/display/cellsjava/Home

- Demos of Aspose.Cells for Java: http://www.aspose.com/demos/java-components/aspose.cells/default.aspx

- Post your technical questions/queries to Aspose.Cells for Java Forum:
http://www.aspose.com/community/forums/aspose.cells-product-family/19/showforum.aspx

- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for Java blog: http://www.aspose.com/community/blogs/aspose.cells-product-family/default.aspx

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
http://www.aspose.com/
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465