SpreadsheetPackage Class
Represents a native metadata package in a spreadsheet.
Inheritance Hierarchy
SystemObject
  GroupDocs.Metadata.CommonMetadataPackage
    GroupDocs.Metadata.CommonCustomPackage
      GroupDocs.Metadata.Formats.DocumentDocumentPackage
        GroupDocs.Metadata.Formats.DocumentSpreadsheetPackage

Namespace: GroupDocs.Metadata.Formats.Document
Assembly: GroupDocs.Metadata (in GroupDocs.Metadata.dll) Version: 21.8
Syntax
public class SpreadsheetPackage : DocumentPackage

The SpreadsheetPackage type exposes the following members.

Properties
  NameDescription
Public propertyAuthor
Gets or sets the document author.
Public propertyCategory
Gets or sets the category.
Public propertyComments
Gets or sets the comments.
Public propertyCompany
Gets or sets the company.
Public propertyContentStatus
Gets or sets the content status.
Public propertyContentType
Gets or sets the content type.
Public propertyContentTypeProperties
Gets the metadata package containing the content type properties.
Public propertyCount
Gets the number of metadata properties.
(Inherited from MetadataPackage.)
Public propertyCreatedTime
Gets or sets the document created date.
Public propertyHyperlinkBase
Gets or sets the hyperlink base.
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 propertyKeywords
Gets or sets the keywords.
Public propertyKnowPropertyDescriptors Obsolete.
Gets a collection of descriptors that contain information about properties accessible through the GroupDocs.Metadata search engine.
(Inherited from MetadataPackage.)
Public propertyLanguage
Gets or sets the document language.
Public propertyLastPrintedDate
Gets or sets the last printed date in UTC.
Public propertyLastSavedBy
Gets or sets the name of the last author.
Public propertyLastSavedTime
Gets or sets the time of the last saving in UTC.
Public propertyManager
Gets or sets the manager.
Public propertyMetadataType
Gets the metadata type.
(Inherited from MetadataPackage.)
Public propertyNameOfApplication
Gets or sets the name of application.
Public propertyPropertyDescriptors
Gets a collection of descriptors that contain information about properties accessible through the GroupDocs.Metadata search engine.
(Inherited from MetadataPackage.)
Public propertyRevision
Gets or sets the document revision number.
Public propertySubject
Gets or sets the subject.
Public propertyTemplate
Gets or sets the document template name.
Public propertyTitle
Gets or sets the title of the document.
Public propertyTotalEditingTime
Gets or sets the total editing time in minutes.
Public propertyVersion
Gets or sets the version number of the application that created the document.
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 methodClear
Removes all writable metadata properties from the package.
(Inherited from DocumentPackage.)
Public methodClearBuiltInProperties
Removes all built-in metadata properties.
(Inherited from DocumentPackage.)
Public methodClearCustomProperties
Removes all custom metadata properties.
(Inherited from DocumentPackage.)
Public methodContains
Determines whether the package contains a metadata property with the specified name.
(Inherited from MetadataPackage.)
Public methodEquals (Inherited from Object.)
Protected methodFinalize (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.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodRemove
Removes a writable metadata property by the specified name.
(Inherited from DocumentPackage.)
Public methodRemoveProperties
Removes metadata properties satisfying the specified predicate.
(Inherited from MetadataPackage.)
Public methodSanitize
Removes writable metadata properties from the package. The operation is recursive so it affects all nested packages as well.
(Inherited from MetadataPackage.)
Public methodSet(String, Boolean)
Adds or replaces the metadata property with the specified name.
Public methodSet(String, DateTime)
Adds or replaces the metadata property with the specified name.
Public methodSet(String, Double)
Adds or replaces the metadata property with the specified name.
Public methodSet(String, Int32)
Adds or replaces the metadata property with the specified name.
Public methodSet(String, String)
Adds or replaces the metadata property with the specified name.
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 example shows how to update built-in metadata properties in a spreadsheet.
C#
using (Metadata metadata = new Metadata(Constants.InputXlsx))
{
    var root = metadata.GetRootPackage<SpreadsheetRootPackage>();

    root.DocumentProperties.Author = "test author";
    root.DocumentProperties.CreatedTime = DateTime.Now;
    root.DocumentProperties.Company = "GroupDocs";
    root.DocumentProperties.Category = "test category";
    root.DocumentProperties.Keywords = "metadata, built-in, update";

    // ... 

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