Spire.XLS for Java 4.2.0已发布。该版本支持数字签名,增加透视表分组和取消分组的功能。此外,该版本还增强了转换Excel到图片/PDF的功能。详情请阅读以下内容。
新功能:
- 支持数字签名
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();
//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();
问题修复:
- 修复了转换Excel到PDF行高不正确的问题
- 修复了插入特殊符号结果文档打开提示内容错误的问题
- 修复了插入的OLE文件双击无法打开的问题
- 修复了转Excel到图片图表数据丢失的问题
- 修复了Linux系统转Excel到PDF抛异常“Specified argument was out of the range of valid values”的问题
- 修复了转换Excel到PDF抛异常“NumberFormatException”的问题
下载Spire.XLS for Java 4.2.0,请点击: