SpreadsheetInspectionPackage class

Contains information about spreadsheet parts that can be considered as metadata in some cases.

Inheritance: SpreadsheetInspectionPackage → CustomPackage → MetadataPackage

The SpreadsheetInspectionPackage type exposes the following members:

Property	Description
metadata_type	Gets the metadata type.
keys	Gets a collection of the metadata property names.
property_descriptors	Gets a collection of descriptors that contain information about properties accessible through the GroupDocs.Metadata search engine.
count	Gets the number of metadata properties.
comments	Gets an array of the user comments.
hidden_sheets	Gets an array of the hidden sheets.
digital_signatures	Gets an array of digital signatures presented in the document.

Method	Description
contains	Determines whether the package contains a metadata property with the specified name.
find_properties	Finds the metadata properties satisfying a specification. The search is recursive so it affects all nested packages as well.
update_properties	Updates known metadata properties satisfying a specification. The operation is recursive so it affects all nested packages as well.
remove_properties	Removes metadata properties satisfying a specification.
add_properties	Adds known metadata properties satisfying the specification. The operation is recursive so it affects all nested packages as well.
set_properties	Sets known metadata properties satisfying the specification. The operation is recursive so it affects all nested packages as well. This method is a combination of `MetadataPackage.add_properties` and `MetadataPackage.update_properties`. If an existing property satisfies the specification its value is updated. If there is a known property missing in the package that satisfies the specification it is added to the package.
sanitize	Removes writable metadata properties from the package. The operation is recursive so it affects all nested packages as well.
clear_comments	Removes all detected user comments from the spreadsheet.
clear_hidden_sheets	Removes all detected hidden sheets from the spreadsheet.
clear_digital_signatures	Removes all detected digital signatures from the spreadsheet.

Learn more | | |

This code sample shows hot to remove inspection properties from a spreadsheet.