SpreadsheetInspectionPackage

Inheritance: java.lang.Object, com.groupdocs.metadata.core.MetadataPackage, com.groupdocs.metadata.core.CustomPackage

public final class SpreadsheetInspectionPackage extends CustomPackage

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

Learn more

Methods

Method Description
getComments() Gets an array of the user comments.
getHiddenSheets() Gets an array of the hidden sheets.
getDigitalSignatures() Gets an array of digital signatures presented in the document.
removeProperties(Specification specification) Removes metadata properties satisfying a specification.
clearComments() Removes all detected user comments from the spreadsheet.
clearHiddenSheets() Removes all detected hidden sheets from the spreadsheet.
clearDigitalSignatures() Removes all detected digital signatures from the spreadsheet.
sanitize() Removes writable metadata properties from the package.

getComments()

public final SpreadsheetComment[] getComments()

Gets an array of the user comments.

Returns: com.groupdocs.metadata.core.SpreadsheetComment[] - The user comments.

getHiddenSheets()

public final SpreadsheetSheet[] getHiddenSheets()

Gets an array of the hidden sheets.

Returns: com.groupdocs.metadata.core.SpreadsheetSheet[] - The hidden sheets.

getDigitalSignatures()

public final DigitalSignature[] getDigitalSignatures()

Gets an array of digital signatures presented in the document.

Returns: com.groupdocs.metadata.core.DigitalSignature[] - The digital signatures.

removeProperties(Specification specification)

public int removeProperties(Specification specification)

Removes metadata properties satisfying a specification.

Parameters:

Parameter Type Description
specification Specification A specification to test each metadata property for a condition.

Returns: int - The number of affected properties.

clearComments()

public final void clearComments()

Removes all detected user comments from the spreadsheet.

clearHiddenSheets()

public final void clearHiddenSheets()

Removes all detected hidden sheets from the spreadsheet.

clearDigitalSignatures()

public final void clearDigitalSignatures()

Removes all detected digital signatures from the spreadsheet.

sanitize()

public int sanitize()

Removes writable metadata properties from the package. The operation is recursive so it affects all nested packages as well.

Returns: int - The number of affected properties.