Spire.XLS for Java 13.11.0 supports retrieving comments from the Name Manager

2023-11-07 09:56:49

We are pleased to announce the release of Spire.XLS for Java 13.11.0. This version supports retrieving comments from the Name Manager. The conversion of Excel to PDF has also been enhanced. Besides, some known issues are fixed successfully in this version, such as the issue that the program threw "Invalid ValidationAlertType " when reading an Excel file. More details are listed below.

Here is a list of changes made in this release

Category ID Description
New feature SPIREXLS-4919 Supports retrieving comments from the Name Manager.
Workbook workbook = new Workbook(); 
workbook.loadFromFile(inputFile); 
INameRanges nameManager = workbook.getNameRanges(); 
StringBuilder stringBuilder = new StringBuilder(); 
for (int i = 0; i < nameManager.getCount(); i++) { 
XlsName name = (XlsName) nameManager.get(i); 
stringBuilder.append("Name: " + name.getName() + ", Comment: " + name.getCommentValue() + "\r\n"); 
} 
workbook.dispose();
Bug SPIREXLS-4911 Improves the speed of converting Excel to PDF on Linux.
Bug SPIREXLS-4860 Fixes the issue that the page size setting failed after setting the setSheetFitToPage method when converting Excel to PDF.
Bug SPIREXLS-4894 Fixes the issue that removing pivot table borders failed.
Bug SPIREXLS-4906 Fixes the issue that text was reversed and cropped after converting Excel to PDF.
Bug SPIREXLS-4923 Fixes the issue that the program threw "Invalid ValidationAlertType" when reading an Excel file.
Bug SPIREXLS-4924 Fixes the issue that the program threw "Input string was not in the correct format" when reading an Excel file.
Click the link below to download Spire.XLS for Java 13.11.0: