Spire.XLS for Java 15.7.7 supports Array data binding in MarkerDesigner

Spire.XLS for Java 15.7.7 supports Array data binding in MarkerDesigner

2025-07-18 03:50:14

We’re glad to announce the release of Spire.XLS for Java 15.7.7. The latest version supports Array data binding in MarkerDesigner. Moreover, some known bugs are fixed successfully in the new version, such as the issue that font rendering was incorrect when converting Excel to PDF in Linux environments. More details are listed below.

Here is a list of changes made in this release:

Category ID Description
New feature SPIREXLS-5874 Supports Array data binding in MarkerDesigner.
Workbook workbook = new Workbook();
// Get the first worksheet from the workbook
Worksheet sheet = workbook.getWorksheets().get(0);
// Set the value of cell range A1 to "&=Array"
sheet.getCellRange("A1").setValue("&=Array");
// Add a parameter named "Array" with an array of strings as its value
workbook.getMarkerDesigner().addArray("Array", new String[] { "Spire.Xls", "Spire.Doc", "Spire.PDF", "Spire.Presentation", "Spire.Email" });
// Apply the marker design to the workbook
workbook.getMarkerDesigner().apply();
// Calculate all the values in the workbook
workbook.calculateAllValue();
// Auto-fit the rows and columns in the allocated range of the worksheet
sheet.getAllocatedRange().autoFitRows();
sheet.getAllocatedRange().autoFitColumns();
// Save the workbook to the specified file path using Excel 2013 format
workbook.saveToFile(outputFile, ExcelVersion.Version2013);
// Clean up and release resources used by the workbook
workbook.dispose();
Bug SPIREXLS-5861
SPIREXLS-5873
Fixes the issue that font rendering was incorrect when converting Excel to PDF in Linux environments.
Bug SPIREXLS-5869 Fixes the issue that the behavior of isWriteUnMergedColSpan(false) was incorrect when converting Excel to HTML.
Bug SPIREXLS-5870 Fixes the issue that "Invalid formula: =#REF!" error happened when loading Excel documents.
Bug SPIREXLS-5875 Fixes the issue that the layout rendering was incorrect when converting Excel to PDF.
Bug SPIREXLS-5876 Fixes the issue that the program threw a java.lang.NullPointerException error when loading Excel files.
Bug SPIREXLS-5877 Removed dependencies on sun.misc.BASE64Decoder.
Click the link to download Spire.XLS for Java 15.7.7: