• 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 ...
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
  • Mikalai Zaikin

Load Only Visible Worksheets from Existing Spreadsheet & Create Excel’s Built-in Styles using 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 8.6.3 has been released. This month’s 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
- 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
- Download Aspose.Cells for Java
- Online documentation of Aspose.Cells for Java
- Demos of Aspose.Cells for Java

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
    Bookmark Topic Watch Topic
  • New Topic