SpreadsheetRootPackage Leave feedback
On this page
Represents the root package allowing working with metadata in a spreadsheet.
public class SpreadsheetRootPackage : DocumentRootPackage<SpreadsheetPackage>
| Name | Description |
|---|---|
| Count { get; } | Gets the number of metadata properties. |
| virtual DocumentProperties { get; } | Gets the native metadata properties presented in the document. |
| DocumentStatistics { get; } | Gets the document statistics package. |
| FileType { get; } | Gets the file type metadata package. (2 properties) |
| InspectionPackage { get; } | Gets a metadata package containing inspection results for the document. The package contains information about document parts that can be considered as metadata in some cases. |
| Item { get; } | Gets the MetadataProperty with the specified name. |
| Keys { get; } | Gets a collection of the metadata property names. |
| MetadataType { get; } | Gets the metadata type. |
| PropertyDescriptors { get; } | Gets a collection of descriptors that contain information about properties accessible through the GroupDocs.Metadata search engine. |
| Name | Description |
|---|---|
| virtual AddProperties(Func<MetadataProperty, bool>, PropertyValue) | Adds known metadata properties satisfying the specified predicate. The operation is recursive so it affects all nested packages as well. |
| Contains(string) | Determines whether the package contains a metadata property with the specified name. |
| virtual FindProperties(Func<MetadataProperty, bool>) | Finds the metadata properties satisfying the specified predicate. The search is recursive so it affects all nested packages as well. |
| GetEnumerator() | Returns an enumerator that iterates through the collection. |
| virtual RemoveProperties(Func<MetadataProperty, bool>) | Removes metadata properties satisfying the specified predicate. |
| override Sanitize() | Removes writable metadata properties from the package. The operation is recursive so it affects all nested packages as well. |
| virtual SetProperties(Func<MetadataProperty, bool>, PropertyValue) | 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 and UpdateProperties. 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. |
| virtual UpdateProperties(Func<MetadataProperty, bool>, PropertyValue) | Updates known metadata properties satisfying the specified predicate. The operation is recursive so it affects all nested packages as well. |
Learn more
This code snippet demonstrates how to extract built-in metadata properties from a spreadsheet.
/// using (Metadata metadata = new Metadata(Constants.InputXlsx))
{
var root = metadata.GetRootPackage<SpreadsheetRootPackage>();
Console.WriteLine(root.DocumentProperties.Author);
Console.WriteLine(root.DocumentProperties.CreatedTime);
Console.WriteLine(root.DocumentProperties.Company);
Console.WriteLine(root.DocumentProperties.Category);
Console.WriteLine(root.DocumentProperties.Keywords);
Console.WriteLine(root.DocumentProperties.Language);
Console.WriteLine(root.DocumentProperties.ContentType);
// ...
}
- class DocumentRootPackage<TPackage>
- class SpreadsheetPackage
- namespace GroupDocs.Metadata.Formats.Document
- assembly GroupDocs.Metadata
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.