Extract metadata from Microsoft Office Excel spreadsheets Leave feedback

To extract metadata from Microsoft Office Excel spreadsheets getMetadata method is used. This method allows to extract the following metadata:

Here are the steps to extract metadata from Microsoft Office Excel spreadsheet:

• Instantiate Parser object for the initial spreadsheet;
• Call getMetadata method and obtain collection of document metadata objects;
• Iterate through the collection and get metadata names and values.

Warning

getMetadata method returns null value if metadata extraction isn’t supported for the document. For example, metadata extraction isn’t supported for CSV files. Therefore, for CSV file getMetadata method returns null. If Microsoft Office Excel spreadsheet has no metadata, getMetadata method returns an empty collection.

The following example demonstrates how to extract metadata from Excel spreadsheet:

// Create an instance of Parser class
try (Parser parser = new Parser(Constants.SampleXlsx)) {
    // Extract metadata from the spreadsheet
    Iterable<MetadataItem> metadata = parser.getMetadata();
    // Iterate over metadata items
    for (MetadataItem item : metadata) {
        // Print an item name and value
        System.out.println(String.format("%s: %s", item.getName(), item.getValue()));
    }
}

You may easily run the code above and see the feature in action in our GitHub examples:

• GroupDocs.Parser for .NET examples
• GroupDocs.Parser for Java examples

Along with full featured .NET library we provide simple, but powerful free Apps.

You are welcome to parse documents and extract data from PDF, DOC, DOCX, PPT, PPTX, XLS, XLSX, Emails and more with our free online Free Online Document Parser App.