Spire.XLS for Java 4.5.3

Spire.XLS for Java 4.5.3 adds a new method to get group boxes

We are happy to announce the release of Spire.XLS for Java 4.5.3. This update adds a new method to get group boxes, supports specifying the font file directory when converting Excel to PDF, enhances the conversions from Excel to PDF/Image and also fixes the issues that the inserted image was stretched. More details are listed as follows.

Here is a list of changes made in this release

Category ID Description
New feature SPIREXLS-3216 Adds a new method getGroupBoxes to get the group boxes.
Workbook workbook = new Workbook();
workbook.loadFromFile(inputFile);
Worksheet worksheet = workbook.getWorksheets().get(0);
IGroupBoxes groupBoxs = worksheet.getGroupBoxes();
New feature SPIREXLS-3219 Supports specifying the font file directory when converting Excel to PDF.
Workbook workbook = new Workbook();
workbook.loadFromFile(inputFile);
workbook.setCustomFontFileDirectory(new String[]{.DataFont});
Hashtable hashtable = workbook.getCustomFontParsedResult();
workbook.saveToFile(outputFile, FileFormat.PDF);
workbook.dispose();
Bug SPIREXLS-3196
SPIREXLS-3227
Fixes the issue that the content was incorrect after converting Excel to PDF.
Bug SPIREXLS-3227 Fixes the issue that the inserted image was stretched.
Bug SPIREXLS-3228 Fixes the issue that the application threw the error NullPointerException when determining whether a cell contains a formula.
Bug SPIREXLS-3237 Fixes the issue that the application threw the error NullPointerException when converting Excel to PDF.
Bug SPIREXLS-3240 Fixes the issue that the content was incorrect after converting Excel to images.
Adjustment SPIREXLS-3252 Adjusts the name of the method to determine whether a document is password protected or not.
Click the link to download Spire.XLS for Java 4.5.3: