eSign Spreadsheet with Metadata signature

Overview

GroupDocs.Signature provides SpreadsheetMetadataSignature class to specify different Metadata signature objects for MetadataSignOptions instance to sign Spreadsheet document files. Spreadsheet document metadata is hidden attributes, some of them are visible only over viewing standard document properties like Author, Creation Date, Producer, Entry, Keywords etc.
Spreadsheet document metadata contains pair of Name and Value, Name should be unique within the document.
Spreadsheet document metadata could keep big amount of data that allows provides ability to keep serialized custom objects with additional encryption in there.

Here are the steps to add metadata signatures into Spreadsheet document with GroupDocs.Signature:

How to eSign Spreadsheet with Metadata signature

This example shows how to add Metadata e-signature to a Spreadsheet document.

from datetime import datetime

from groupdocs.signature import Signature
from groupdocs.signature.options import MetadataSignOptions
from groupdocs.signature.domain import SpreadsheetMetadataSignature


def sign_xlsx():
    with Signature("sample.xlsx") as signature:
        options = MetadataSignOptions()

        # Create a few Spreadsheet Metadata signatures
        signatures = [
            SpreadsheetMetadataSignature("Author", "Mr.Scherlock Holmes"),
            SpreadsheetMetadataSignature("DateCreated", datetime.now()),
            SpreadsheetMetadataSignature("DocumentId", 123456),
            SpreadsheetMetadataSignature("SignatureId", 123.456),
        ]

        # Add them to the options
        options.signatures.add_range(signatures)

        # Sign the spreadsheet and save the result
        result = signature.sign("signed.xlsx", options)
        print(f"Signed with {len(result.succeeded)} metadata signature(s):")
        for item in result.succeeded:
            print(f"  {item.name}")


if __name__ == "__main__":
    sign_xlsx()

sample.xlsx is the sample file used in this example. Click here to download it.

Binary file (XLSX, 39 KB)

Download full output

More resources

GitHub Examples

You may easily run the code above and see the feature in action in our GitHub examples:

Free Online Apps

Along with the full-featured Python library, we provide simple but powerful free online apps.

To sign PDF, Word, Excel, PowerPoint, and other documents you can use the online apps from the GroupDocs.Signature App Product Family.

Close
Loading

Analyzing your prompt, please hold on...

An error occurred while retrieving the results. Please refresh the page and try again.