标签导航：

java如何批量为excel文件添加和删除数字签名？

批量给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");
}

删除数字签名

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...