We are excited to announce the release of Spire.XLS for Java 13.8.1. This version supports setting images for the first page header and footer and getting the hyperlinks of pictures. It also enhances the conversion from Excel to PDF and images. Moreover, some known issues are fixed successfully in this version, such as the issue that Excel files saved in Tomcat had garbled formulas. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| New feature | SPIREXLS-4797 | Supports setting images for the first page header and footer.
//Set image for first page header worksheet.getPageSetup().setFirstLeftHeaderImage(img_LFH); worksheet.getPageSetup().setCenterHeaderImage(img_LCH); worksheet.getPageSetup().setRightHeaderImage(img_LRH); //Set image for first page footer worksheet.getPageSetup().setLeftFooterImage(img_LFF); worksheet.getPageSetup().setCenterFooterImage(img_LCF); worksheet.getPageSetup().setRightHeaderImage(img_LRF); //Set image size worksheet.getPageSetup().setFirstLeftHeaderPictureHeight(50); worksheet.getPageSetup().setFirstLeftHeaderPictureWidth(50); worksheet.getPageSetup().setFirstCenterHeaderPictureHeight(50); worksheet.getPageSetup().setFirstCenterHeaderPictureWidth(50); worksheet.getPageSetup().setFirstRightHeaderPictureHeight(50); worksheet.getPageSetup().setFirstRightHeaderPictureWidth(50); |
| New feature | SPIREXLS-4831 | Supports getting the hyperlinks of pictures.
ExcelPicture picture = sheet.getPictures().get(0); HyperLink link = picture.getHyperLink(); String address = link.getAddress(); |
| Bug | SPIREXLS-4078 | Fixes the issue that Excel files saved in Tomcat had garbled formulas. |
| Bug | SPIREXLS-4737 | Fixes the issue that opening files converted from Excel to PDF in Adobe resulted in an error. |
| Bug | SPIREXLS-4770 | Fixes the issue that the content formatting of files converted from Excel to images was incorrect. |
| Bug | SPIREXLS-4800 | Fixes the issue that setting the maximum row was not taking effect. |
| Bug | SPIREXLS-4821 SPIREXLS-4840 |
Fixes the issue that the program threw "NullPointerException" when converting Excel to PDF. |
| Bug | SPIREXLS-4822 | Fixes the issue that Excel files saved in WinServer2012 had garbled content in dropdown menus. |
| Bug | SPIREXLS-4829 | Fixes the issue that the program threw "NullPointerException" when loading Excel files created with the new version of WPS. |
| Bug | SPIREXLS-4837 SPIREXLS-4839 |
Fixes the issue that the program threw "NullPointerException" when loading Excel files. |
Click the link to download Spire.XLS for Java 13.8.1:
