Add and Delete Digital Signature in Excel with Java

A digital signature is a type of electronic signature that helps verify the authenticity of documents. In this blog, I will show you how to sign an Excel file with digital signature and delete the digital signature from the result Excel file programmatically in Java using Spire.XLS for Java API.

Add maven dependencies

Before coding, you need to add needed dependencies for including Spire.XLS for Java into your Java project.

1. <repositories>    
2.         <repository>    
3.             <id>com.e-iceblue</id>    
4.             <name>e-iceblue</name>    
5.             <url>http://repo.e-iceblue.com/nexus/content/groups/public/</url>    
6.         </repository>    
7. </repositories>    
8. <dependencies>    
9.     <dependency>    
10.         <groupId>e-iceblue</groupId>    
11.         <artifactId>spire.xls</artifactId>    
12.         <version>4.4.6</version>    
13.     </dependency>    
14. </dependencies>  

The latest Spire.XLS for Java version number can be found here.

Add digital signature

Spire.XLS for Java API provides a Workbook class that represents an Excel workbook. To add digital signature to an Excel file, you first need to create a workbook object, after that load the Excel file using  the loadFromFilemethod with the workbook object, finally call the addDigitalSignature and the saveToFilemethods to add digital signature and save the result file.

1. import com.spire.xls.ExcelVersion;  
2. import com.spire.xls.Workbook;  
3. import com.spire.xls.digital.CertificateAndPrivateKey;  
4.   
5. import java.util.Date;  
6.   
7. public class AddDigitalSignature {  
8.     public static void main(String []args) throws Exception {  
9.         //Load an Excel file  
10.         Workbook workbook=new Workbook();  
11.         workbook.loadFromFile("Sample.xlsx");  
12.   
13.         //Add digital signature  
14.         CertificateAndPrivateKey cap = new CertificateAndPrivateKey("test.pfx","123456");  
15.         workbook.addDigitalSignature(cap, "123456",new Date());  
16.   
17.         //Save the result file  
18.         workbook.saveToFile("AddDigitalSignature.xlsx", ExcelVersion.Version2013);  
19.     }  
20. }  

The result file:

Delete digital signature

The following example demonstrates how to remove the digital signature from the Excel file using the removeAllDigitalSignatures method in Workbook class.

1. import com.spire.xls.ExcelVersion;  
2. import com.spire.xls.Workbook;  
3.   
4. public class DeleteDigitalSignature {  
5.     public static void main(String []args){  
6.         //Load an Excel file  
7.         Workbook workbook=new Workbook();  
8.         workbook.loadFromFile("AddDigitalSignature.xlsx");  
9.   
10.         //Remove digital signature  
11.         workbook.removeAllDigitalSignatures();  
12.   
13.         //Save the result file  
14.         workbook.saveToFile("RemoveDigitalSignature.xlsx", ExcelVersion.Version2013);  
15.     }  
16. }  

The result file: