Filter VBA Project while Loading a Workbook & Export Print Area Range to HTML using Java

What’s new in this release?

Aspose team is pleased to announce the new release of Aspose.Cells for Java 18.12. It provide a detailed information about the new features, enhancements and bug fixes in the new release. Workbook can have multiple sheets which are rendered as multiple tab pages when converted to HTML using Excel. Similarly if a workbook contains single sheet, it shows one tab page when converted to HTML using Excel. This conversion was working fine for multiple sheets while using Aspose.Cells. However for single sheet workbook, there was no tab page and only HTML file was created without creating the separate folder containing CSS. Now Aspose.Cells has enhanced its library to create similar output for single sheet workbooks as compared to output created by Excel. In complex Excel files (XLSM/XSLB) there can be large amount of macros which can be very very long. Many times there is a need to load the workbooks without loading these VBA projects like just extracting the sheet names from loaded workbook. In this case we need a filter which can load VBA projects in when they are actually required. This time Aspose.Cells has introduced a filter option LoadDataFilterOptions.VBA which can be used for this purpose. Textbox is very common control which can be used in a worksheet. This is not necessary that text in the textbox is fixed. It may have tags which can be replaced with some text at runtime. It helps users to configure the controls as per the data on the sheet or from some other source. Worksheet.replace can be used for this purpose and textbox can be set with the desired text. Users can convert worksheet to HTML but rendering entire sheet at once may not be required always. Users may require just a selected area of the sheet to be rendered to HTML. Worksheets contain page setup where print area can be set. There was a need that only this print area shall be rendered to HTML if required. HtmlSaveOptions is extended by adding a new enumerator ExportPrintAreaOnly which enables users to render only print area in the HTML. A worksheet can have different types of validations including dropdown. There can be a need where user may want to detect the type of validation and take some decision based on this information. Validation object can be obtained from a cell and a new function is defined for this validation which returns if validation is a dropdown or not. There are some other enhancements included and a few exceptions handled in the new release for the users, such as Does not get connection points as its returned type is ‘zo[]’, Data bars are missing when XLSX is converted to HTML, LightCells API fails to load a huge file, Validation always returns true for ‘getInCellDropDown()’ method, Wrong culture custom format gets returned for different locales (Germany, French, Italy and Spain), Text formatting is missing in HTML output of MS Excel range, Excel To PDF conversion – Gauge chart rendering issue and PDF rendition throws OutOfMemoryError exception. Below are some important new features, enhancement and bug fixes part of this release.

• Does not get connection points as its returned type is 'zo[]'
• Provide ability to export range as HTML
• Data bars are missing when XLSX is converted to HTML
• Value still exists when XLSX is converted to HTML file format
• LightCells API fails to load a huge file
• Text formatting is missing in HTML output of MS Excel range
• Icon Sets become misaligned when XLSX is converted to HTML
• Exporting named range data is not correctly rendered to HTML (Java)
• An issue found in Named Range
• Validation always returns true for 'getInCellDropDown()' method
• Wrong culture custom format gets returned for different locales (Germany, French, Italy and Spain)
• Excel To PDF conversion - Gauge chart rendering issue
• PDF rendition throws OutOfMemoryError exception

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

- Export single sheet workbook to HTML: https://docs.aspose.com/display/cellsjava/Export+Worksheet+CSS+Separately+in+Output+HTML#ExportWorksheetCSSSeparatelyinOutputHTML-ExportsinglesheetworkbooktoHTML

- Replace tag with text in a textbox inside the Worksheet: https://docs.aspose.com/display/cellsjava/Replace+tag+with+text+in+a+textbox+inside+the+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: https://products.aspose.com/cells/java

- Download Aspose.Cells for Java: https://downloads.aspose.com/cells/java

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

Aspose Pty Ltd was founded in March 2002 in Sydney, Australia. The corporate portal was firstly launched in October 2002. Aspose strives to provide the richest component choices for global .NET programmers. Thousands of organizations from tens of countries have acquired Aspose products, including Microsoft, IBM, PricewaterhouseCoopers, Ernst & Young, DuPont, Hilton Hotels, Reader's Digest, Bank of America, Boeing, Siemens, etc.

Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia

This release was published on openPR.