SpreadsheetInspectionPackage Class
Contains information about spreadsheet parts that can be considered as metadata in some cases.
Inheritance Hierarchy
SystemObject
  GroupDocs.Metadata.CommonMetadataPackage
    GroupDocs.Metadata.CommonCustomPackage
      GroupDocs.Metadata.Formats.DocumentSpreadsheetInspectionPackage

Namespace: GroupDocs.Metadata.Formats.Document
Assembly: GroupDocs.Metadata (in GroupDocs.Metadata.dll) Version: 21.8
Syntax
public sealed class SpreadsheetInspectionPackage : CustomPackage

The SpreadsheetInspectionPackage type exposes the following members.

Properties
  NameDescription
Public propertyComments
Gets an array of the user comments.
Public propertyCount
Gets the number of metadata properties.
(Inherited from MetadataPackage.)
Public propertyDigitalSignatures
Gets an array of digital signatures presented in the document.
Public propertyHiddenSheets
Gets an array of the hidden sheets.
Public propertyItem
Gets the MetadataProperty with the specified name.
(Inherited from MetadataPackage.)
Public propertyKeys
Gets a collection of the metadata property names.
(Inherited from MetadataPackage.)
Public propertyKnowPropertyDescriptors Obsolete.
Gets a collection of descriptors that contain information about properties accessible through the GroupDocs.Metadata search engine.
(Inherited from MetadataPackage.)
Public propertyMetadataType
Gets the metadata type.
(Inherited from MetadataPackage.)
Public propertyPropertyDescriptors
Gets a collection of descriptors that contain information about properties accessible through the GroupDocs.Metadata search engine.
(Inherited from MetadataPackage.)
Methods
  NameDescription
Public methodAddProperties
Adds known metadata properties satisfying the specified predicate. The operation is recursive so it affects all nested packages as well.
(Inherited from MetadataPackage.)
Public methodClearComments
Removes all detected user comments from the spreadsheet.
Public methodClearDigitalSignatures
Removes all detected digital signatures from the spreadsheet.
Public methodClearHiddenSheets
Removes all detected hidden sheets from the spreadsheet.
Public methodContains
Determines whether the package contains a metadata property with the specified name.
(Inherited from MetadataPackage.)
Public methodEquals (Inherited from Object.)
Public methodFindProperties
Finds the metadata properties satisfying the specified predicate. The search is recursive so it affects all nested packages as well.
(Inherited from MetadataPackage.)
Public methodGetEnumerator
Returns an enumerator that iterates through the collection.
(Inherited from MetadataPackage.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Public methodRemoveProperties
Removes metadata properties satisfying the specified predicate.
(Overrides MetadataPackageRemoveProperties(FuncMetadataProperty, Boolean).)
Public methodSanitize
Removes writable metadata properties from the package. The operation is recursive so it affects all nested packages as well.
(Overrides MetadataPackageSanitize.)
Public methodSetProperties
Sets known metadata properties satisfying the specified predicate. The operation is recursive so it affects all nested packages as well. This method is a combination of AddProperties(FuncMetadataProperty, Boolean, PropertyValue) and UpdateProperties(FuncMetadataProperty, Boolean, PropertyValue). If an existing property satisfies the predicate its value is updated. If there is a known property missing in the package that satisfies the predicate it is added to the package.
(Inherited from MetadataPackage.)
Public methodToString (Inherited from Object.)
Public methodUpdateProperties
Updates known metadata properties satisfying the specified predicate. The operation is recursive so it affects all nested packages as well.
(Inherited from MetadataPackage.)
Remarks
Examples
This code sample shows hot to remove inspection properties from a spreadsheet.
C#
using (Metadata metadata = new Metadata(Constants.InputXlsx))
{
    var root = metadata.GetRootPackage<SpreadsheetRootPackage>();

    root.InspectionPackage.ClearComments();
    root.InspectionPackage.ClearDigitalSignatures();
    root.InspectionPackage.ClearHiddenSheets();

    metadata.Save(Constants.OutputXlsx);
}
See Also