![]() ![]() Create a new signature line and delete with Signature.Delete To delete the signature line, use ISignature.Delete or IShape.Delete methods. With GcExcel, it is also possible to completely remove the signature line by deleting it. To cut a signature line to another range, use IRange.Cut method. Workbook.Save("copysignaturelines.xlsx") Copy signature line with Worksheet.Copy Copy signature line with Shape.Duplicate This is possible using the IRange.Copy, IShape.Duplicate or IWorksheet.Copy methods to copy signature line to another range or worksheet. The signature line added to the document can be copied to another range or worksheet. Setup.SuggestedSignerEmail = "Commander (Balanced)" Setup.SigningInstructions = "Please check the content before signing." ![]() ISignatureSetup setup = (activeSheet, 100.0, 50.0).Setup Below are the various operations supported by GcExcel to manage the signatures: Add signature line IWorksheet activeSheet = workbook.ActiveSheet GcExcel also enables the management of signatures (when the Excel file is already signed either via signatures or signature line, it is possible to modify, retrieve, and verify them). Workbook.Save("CountersignSignature.xlsx") ISignature signature = (workbook.ActiveSheet, 100.0, 50.0) To counter-sign a signature (add a signature to a workbook that is already signed), first create a signature line and a signature as above, then use ISignature.Countersign method with the same certificate to counter-sign the signature. To sign a signature line, add signature to the Excel spreadsheet as shown above and invoke the ISignature.Sign method. Using GcExcel, it is possible to perform this task in code completely that is, GcExcel will load the Excel file with the signature line, enable entering signature details, and sign the document using code. When an Excel spreadsheet contains a signature line, it displays a notification to sign the document and provide the signature details. TODO: Use your name or signature image Once the signature is defined, load the certificate via X509Certificate2 class, create signature packet using ISignature.Sign method and finally commit the signature by invoking the IWorkbook.Save method. To sign the workbook, first create a signature using the ISignatureSet.AddNonVisibleSignature method and input the signature details using SignatureDetails class. You can use the following methods to sign an Excel file in GcExcel: Add non-visible signature The features in this category demonstrate the signing of an Excel spreadsheet. The features supported can be divided into three categories. Digital Signature Features Supported in GcExcelĪpart from adding digital signatures to the Excel workbook, GcExcel supports many additional features. You can add invisible signatures, add/remove/update signature lines, export a signed workbook to PDF, and verify signatures. GcExcel provides several options for creating digital signatures. When an electronic copy of the file is sent to the intended signer, they can see the signature line and a notification that their signature is requested. When an Excel document has a signature added to it, no edits are permitted to the document without invalidating that signature.Ī signature line visually resembles a typical signature placeholder that might appear in a printed document.When a signature line is inserted into an Excel file, the author can specify information (name, title, and email address) about the intended signer, and instructions for the signer. GcExcel enables adding a digital signature into Excel in two forms, either as an actual Signature or as a 'Signature Line.'Ī signature is an actual copy of the digital certificate (PFX/PKCS12) that gets embedded into the document. The library supports digital signature in the Excel spreadsheets using the IWorkbook.Signatures and IWorksheet.Shapes properties. With the new release, GcExcel allows a user to digitally sign an Excel file to secure the content's authenticity. Digital Signature Support in Excel Spreadsheets The GrapeCity Documents for Excel v3.2 release introduces support for digital signatures in Excel spreadsheets. Supporting digital signature is becoming a standard in digital documentation. Simply put, a digital signature is an electronic fingerprint that confirms the signer's identity and the authenticity of the document. In the current digital landscape, traditional signing and authenticating documents are quickly being replaced by digital signatures.Ī digital signature is an electronic, encrypted stamp of authentication on digital information, such as e-mail messages, electronic documents, etc. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |