Spire.XLS for Java 13.12.12 supports retrieving embedded images added with WPS tools

2023-12-20 09:57:03

We are delighted to announce the release of Spire.XLS for Java 13.12.12. This version supports retrieving embedded images added with WPS tools. Besides, it enhances the conversion from XLSM to PDF. Moreover, some known issues are fixed successfully in this version, such as the issue that the program suspended when loading an Excel document. More details are listed below.

Here is a list of changes made in this release

Category ID Description
New feature SPIREXLS-4971 Adds the worksheet.getCellImages() method to retrieve embedded images added with WPS tools.
Workbook workbook = new Workbook();
workbook.loadFromFile("sample.xlsx");
Worksheet sheet = workbook.getWorksheets().get(0);
ExcelPicture[] picture = sheet.getCellImages();
for (int i = 0; i < picture.length; i++) {
 ExcelPicture ep = picture[i];
 BufferedImage image = ep.getPicture();
 ImageIO.write(image,"PNG", new File(outputFile + String.format("pic_%d.png",i)));
}
Bug SPIREXLS-4971 Fixes the issue that the program threw an exception "Index is less than 0 or more than or equal to the list count." when getting inline pictures added with WPS tools.
Bug SPIREXLS-4996 Fixes the issue that the program suspended when loading Excel documents.
Bug SPIREXLS-5010 Fixes the issue that the font size of the retrieved text was incorrect.
Bug SPIREXLS-5021 Fixes the issue that the coordinate axes data of charts in the saved Excel document were incorrect.
Bug SPIREXLS-5024 Fixes the issue that the program threw a java.lang.StringIndexOutOfBoundsException when converting an XLSM document to PDF.
Click the link to download Spire.XLS for Java 13.12.12: