数字签名

Workbook workbook = new Workbook();
ISignature signature = workbook.getSignatures().addSignatureLine(workbook.getActiveSheet(), 100.0, 50.0);

// Add Signature lines
ISignatureSetup setup = signature.getSetup();
setup.setShowSignDate(false);
setup.setAllowComments(false);
setup.setSigningInstructions("Please check the content before signing.");
setup.setSuggestedSigner("Shinzo Nagama");
setup.setSuggestedSignerEmail("shinzo.nagama@ea.com");
setup.setSuggestedSignerLine2("Commander (Balanced)");

// Save to an excel file
workbook.save("AddSignatureLines.xlsx");

// Copy signature line with Range.Copy
IRange srcRange = activeSheet.getRange("A1:I15");
IRange destRange = activeSheet.getRange("A16:I30");
srcRange.copy(destRange);

// Copy signature line with Shape.Duplicate
signature.getSignatureLineShape().duplicate();

// Copy signature line with Worksheet.Copy
activeSheet.copy();

// Create a new signature line and delete with Signature.Delete
ISignature signatureForTest = newSignatureLine.call();
signatureForTest.delete();

// Create a new signature line and delete with Shape.Delete
signatureForTest = newSignatureLine.call();
IShape signatureLineShape = signatureForTest.getSignatureLineShape();
signatureLineShape.delete();

// Move signature line
IShape signatureLineShape = signatureShinzo.getSignatureLineShape();
signatureLineShape.setTop(signatureLineShape.getTop() + 100);
signatureLineShape.setLeft(signatureLineShape.getLeft() + 50);

// Add first signature line
ISignature signatureShinzo = signatures.addSignatureLine(activeSheet, 100.0, 50.0);
ISignatureSetup setup1 = signatureShinzo.getSetup();
setup1.setShowSignDate(false);
setup1.setAllowComments(false);
setup1.setSigningInstructions("Please check the content before signing.");
setup1.setSuggestedSigner("Shinzo Nagama");
setup1.setSuggestedSignerEmail("shinzo.nagama@ea.com");
setup1.setSuggestedSignerLine2("Commander (Balanced)");

ISignature signatureKenji = signatures.addSignatureLine(activeSheet, 100.0, 350.0);
ISignatureSetup setup2 = signatureKenji.getSetup();
setup2.setShowSignDate(true);
setup2.setAllowComments(true);
setup2.setSigningInstructions("Please check the content before signing!");
setup2.setSuggestedSigner("Kenji Tenzai");
setup2.setSuggestedSignerEmail("kenji.tenzai@ea.com");
setup2.setSuggestedSignerLine2("Commander (Mecha)");

// List signatures with indexes
for (int i = 0; i < signatures.getCount(); i++) {
    ISignature signature = signatures.get(i);
    // change SuggestedSigner
    if (i == 0)
        signature.getSetup().setSuggestedSigner("Shinzo Nagama 123");
    // change SuggestedSignerLine2
    if (i == 1)
        signature.getSetup().setSuggestedSignerLine2("Commander (Mecha 1234)");
}

// Create a new workbook
Workbook workbook = new Workbook();
ISignature signature = workbook.getSignatures().addSignatureLine(workbook.getActiveSheet(), 100.0, 50.0);
ISignatureSetup setup = signature.getSetup();
setup.setShowSignDate(true);
setup.setAllowComments(true);
setup.setSigningInstructions("");
setup.setSuggestedSigner("");
setup.setSuggestedSignerEmail("example@microsoft.com");
setup.setSuggestedSignerLine2("");

SignatureDetails details = new SignatureDetails();
details.setAddress1("");
details.setAddress2("

// Create a new workbook
Workbook workbook = new Workbook();
ISignature signature = workbook.getSignatures().addNonVisibleSignature();
SignatureDetails details = new SignatureDetails();
details.setAddress1("");
details.setAddress2("

// Open a digitally signed workbook
workbook.open("signsignaturelines.xlsx");

// Modify
workbook.getWorksheets().get(0).getRange("A1").setValue("Modified");

// Countersign
workbook.getSignatures().get(0).countersign(ks, password);

// Save to an excel file
workbook.save("CounterSignSignatureLines.xlsx");

workbook.Open("signsignaturelines.xlsx");
        
// Use DigitalSignatureOnly mode, because the workbook was already signed.
// If you don't open it with digital signature only mode,
// all existing signatures will be removed after saving the workbook.
XlsxOpenOptions openOption = new XlsxOpenOptions();
openOption.setDigitalSignatureOnly(true);
        
// Add signature to this workbook
ISignature signature = workbook.getSignatures().addNonVisibleSignature();
signature.sign(ks, password, details);

// Commit signatures
workbook.save("AddNonVisibleSignatureToSignedWorkbook.xlsx");

// Create a new workbook
Workbook workbook = new Workbook();
workbook.open("signsignaturelines.xlsx");
ISignatureSet signatures = workbook.getSignatures();
boolean signed = false;
boolean valid = false;
X509Certificate certificate = null;

// Verify the first signature
for (ISignature signature : signatures) {
    if (signature.getIsSigned()) {
        // Save the result in locals. You can print them later.
        signed = true;
        certificate = signature.getDetails().getSignatureCertificate();
        valid = signature.getIsValid();
        break;
    }
}
// Verify the first certificate
boolean certificateIsValid = true;
// Check expiration date and start date
try {
    certificate.checkValidity();
} catch (CertificateExpiredException e) {
    certificateIsValid = false;
    return;
} catch (CertificateNotYetValidException e) {
    certificateIsValid = false;
    return;
}

// Create a new workbook
Workbook workbook = new Workbook();
        
// This file contains 1 signed signature line and
// a not signed signature line.
workbook.open("signsignaturelines.xlsx");
        
// Use DigitalSignatureOnly mode, because the workbook was already signed.
// If you don't open it with digital signature only mode,
// all existing signatures will be removed after saving the workbook.
XlsxOpenOptions openOption = new XlsxOpenOptions();
openOption.setDigitalSignatureOnly(true);
        
// Remove signature of signed signature line.
for (ISignature signature : workbook.getSignatures()) {
if (signature.getIsSignatureLine() && signature.getIsSigned()) {
    // Remove digital signature.
    // The signature line will not be removed from the SignatureSet
    // in digital signature only mode.
    // Because signature lines are shapes.
    signature.delete();
    break;
}
        
//commit signatures
workbook.save("DeleteDigitalSignature.xlsx");