SpreadsheetInspectionPackage class Leave feedback
On this page
Contains information about spreadsheet parts that can be considered as metadata in some cases.
Learn more
- Working with metadata in Spreadsheets (https://docs.groupdocs.com/display/metadatanet/Working+with+metadata+in+Spreadsheets)
The SpreadsheetInspectionPackage type exposes the following members:
| Method | Description |
|---|---|
| clear_comments | Removes all detected user comments from the spreadsheet. |
| clear_digital_signatures | Removes all detected digital signatures from the spreadsheet. |
| clear_hidden_sheets | Removes all detected hidden sheets from the spreadsheet. |
| remove_properties | Removes metadata properties satisfying the specified predicate. |
| remove_properties_func | |
| sanitize | Removes writable metadata properties from the package recursively, affecting all nested packages. |
| add_properties | Adds known metadata properties satisfying the specified predicate. The operation is recursive so it affects all nested packages as well. (inherited from MetadataPackage) |
| add_properties_func | (inherited from MetadataPackage) |
| contains | Returns True if the package contains a metadata property with the specified name; otherwise, False. (inherited from MetadataPackage) |
| contains_file | (inherited from MetadataPackage) |
| contains_string | (inherited from MetadataPackage) |
| find_properties | Finds metadata properties that satisfy the specified predicate, searching recursively through all nested packages. (inherited from MetadataPackage) |
| find_properties_func | (inherited from MetadataPackage) |
| get | (inherited from MetadataPackage) |
| get_enumerator | Returns an enumerator that iterates through the collection. (inherited from MetadataPackage) |
| get_file | (inherited from MetadataPackage) |
| get_string | (inherited from MetadataPackage) |
| set_properties | Sets known metadata properties satisfying the specified predicate. (inherited from MetadataPackage) |
| set_properties_func | (inherited from MetadataPackage) |
| update_properties | Updates known metadata properties that satisfy the specified predicate, recursively affecting all nested packages. (inherited from MetadataPackage) |
| update_properties_func | (inherited from MetadataPackage) |
| Property | Description |
|---|---|
| comments | The user comments. |
| digital_signatures | The digital signatures presented in the document. |
| hidden_sheets | The hidden sheets. |
| count | The number of metadata properties. (inherited from MetadataPackage) |
| keys | The collection of metadata property names. (inherited from MetadataPackage) |
| know_property_descriptors | The collection of descriptors that contain information about properties accessible through the GroupDocs.Metadata search engine. (inherited from MetadataPackage) |
| metadata_type | The metadata type of the package. (inherited from MetadataPackage) |
| property_descriptors | The collection of descriptors that contain information about properties accessible through the GroupDocs.Metadata search engine. (inherited from MetadataPackage) |
from groupdocs.metadata import Metadata, SpreadsheetRootPackage, Constants
with Metadata(Constants.InputXlsx) as metadata:
root = metadata.get_root_package(SpreadsheetRootPackage)
# Remove inspection properties
root.inspection_package.clear_comments()
root.inspection_package.clear_digital_signatures()
root.inspection_package.clear_hidden_sheets()
metadata.save(Constants.OutputXlsx)
Was this page helpful?
Any additional feedback you'd like to share with us?
Please tell us how we can improve this page.
Thank you for your feedback!
We value your opinion. Your feedback will help us improve our documentation.
