Spire.XLS for Java 4.2.0

Spire.XLS for Java 4.2.0 supports adding digital signature

We are happy to announce the release of Spire.XLS for Java 4.2.0. This version supports adding digital signature and adds Group/Ungroup feature or Pivot Table. In addition, it also enhances the conversions from Excel to PDF/Image. More details are listed below.

Here is a list of changes made in this release

Category ID Description
New Feature - Supports adding digital signature.
GetCertAndPrivateKeyFromPFX certAndPrivateKeyFromPFX=new GetCertAndPrivateKeyFromPFX();
HashMap<X509Certificate,PrivateKey> hashMap=certAndPrivateKeyFromPFX.getCertAndPrivateKeyFromPFX(inputFile_pfx);
IDigitalSignatures dsc = workbook.addDigitalSignature(hashMap.keySet().iterator().next(), hashMap.get(hashMap.keySet().iterator().next()), "e-iceblue", calendar.getTime());
workbook.isDigitallySigned();
workbook.removeAllDigitalSignatures();
New Feature SPIREXLS-2921 Supports Group/Ungroup function for Pivot Table.
//Group
Workbook wb = new Workbook();
wb.loadFromFile(inputFile);
Worksheet sheet = wb.getWorksheets().get("Sheet1");
XlsPivotTable pt = (XlsPivotTable)sheet.getPivotTables().get(0);
PivotField r1 = (PivotField)pt.getPivotFields().get("Count");
pt.setManualGroupField(r1,7,15, EnumSet.of(PivotGroupByType.RangeOfValues),5);
wb.saveToFile(outputFile, ExcelVersion.Version2013);
wb.dispose();
//Ungroup
Workbook wb = new Workbook();
wb.loadFromFile(inputFile);
Worksheet sheet = wb.getWorksheets().get("Sheet1");
XlsPivotTable pt = (XlsPivotTable)sheet.getPivotTables().get(0);
PivotField r1 = (PivotField)pt.getPivotFields().get("Count");
pt.setUngroup(r1);
wb.saveToFile(outputFile, ExcelVersion.Version2013);
wb.dispose();
Bug SPIREXLS-2981 Fixes the issue that an error prompted when opening the result file after inserting special symbols into Excel.
Bug SPIREXLS-3035 Fixes the issue that the inserted OLE object in the result file could not be opened normally.
Bug SPIREXLS-3039 Fixes the issue that the chart data was missing after converting Excel to images.
Bug SPIREXLS-3043 Fixes the issue that the application threw the error “Specified argument was out of the range of valid values” when converting Excel to PDF on Linux.
Bug SPIREXLS-3081 Fixes the issue that the application threw the error “NumberFormatException” when converting Excel to PDF.
Click the link to download Spire.XLS for Java 4.2.0: