
批量给excel文件添加数字签名及其删除
在java中,可以使用apache poi库来批量给excel文件添加和删除数字签名。下面是如何实现的:
添加数字签名
public void addsignature() {
workbook wb = new workbook();
isignature signature = wb.getsignatures().addsignatureline(wb.getactivesheet(), 100, 50);
isignaturesetup setup = signature.getsetup();
setup.setshowsigndate(false);
setup.setallowcomments(false);
setup.setsigninginstructions("please check the content before signing");
setup.setsuggestedsigneremail("example@example.com");
setup.setsuggestedsignerline2("commander (balanced)");
wb.save("output/signaturelines.xlsx");
}删除数字签名
立即学习“Java免费学习笔记(深入)”;
public void RemoveSignature() {
Workbook wb = new Workbook();
ISignature signature = wb.getSignatures().getSignatureLine(0);
wb.getSignatures().removeSignatureLine(signature);
wb.save("output/SignatureLines.xlsx");
}参考资料:
- apache poi数字签名文档:[https://www.grapecity.com.cn/developer/grapecitydocuments/exc...](https://www.grapecity.com.cn/developer/grapecitydocuments/exc...)










