Add Signature line to the worksheet

Possible Usage Scenarios

Aspose.Cells provides the Picture.SignatureLine property to add the signature line of the worksheet.

Add Signature Line to the worksheet

The following sample code demonstrated how to make use of Picture.SignatureLine property to add the signature line of the worksheet. The screenshot shows the effect of the sample code on the sample Excel file after execution.

Sample Code

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
// Instantiating a Workbook object
Workbook wb = new Workbook();

SignatureLine signatureLine = new SignatureLine();
signatureLine.Id = Guid.NewGuid();
signatureLine.ProviderId = Guid.Empty;
signatureLine.Signer = "Aspose.Cells";
signatureLine.Title = "signed by Aspose.Cells";
wb.Worksheets[0].Shapes.AddSignatureLine(1, 1, signatureLine);

System.Security.Cryptography.X509Certificates.X509Certificate2 certificate = new System.Security.Cryptography.X509Certificates.X509Certificate2(dataDir + "rsa2048.pfx", "123456");
Aspose.Cells.DigitalSignatures.DigitalSignature signature =
    new Aspose.Cells.DigitalSignatures.DigitalSignature(certificate, "test Microsoft Office signature line", DateTime.UtcNow);
signature.Id = signatureLine.Id;
signature.ProviderId = signatureLine.ProviderId;


Aspose.Cells.DigitalSignatures.DigitalSignatureCollection dsCollection = new Aspose.Cells.DigitalSignatures.DigitalSignatureCollection();
dsCollection.Add(signature);
wb.SetDigitalSignature(dsCollection);
wb.Save(dataDir + "signatureLine.xlsx");