GroupDocs.Metadata for Java API

Remove XLSX Metadata In Java

Remove metadata properties from XLSX and many other popular documents, images and multimedia file formats using GroupDocs.Metadata for Java API

Maven Download

Start Free Trial

Steps for Removing Metadata to XLSX in Java

GroupDocs.Metadata makes it easy for Java developers to delete metadata information from XLSX files from within their applications by implementing a few easy steps.

Load the XLSX file to be updated.
Pass a search predicate to the RemoveProperties method.
Check the number of properties that were actually removed.
Save the changes.

Copy

// Clear XLSX document metadata
try (Metadata metadata = new Metadata("input.xlsx");
{
    // Remove all mentions of any people contributed in file creation
    // Remove a custom property with the specified name
    int affected = metadata.removeProperties(
        new FallsIntoCategorySpecification(Tags.getPerson()).
        or(new WithNameSpecification("CustomProperty")));
    
    System.out.println(String.format("Affected properties: %s", affected));
    
    // Save the cleared file
    metadata.save("output.xlsx");
}

<dependencies>
<dependency>
<groupId>com.groupdocs</groupId>
<artifactId>groupdocs-metadata</artifactId>
<version>24.8</version>
</dependency>
</dependencies>
<repositories>
<repository>
<id>repository.groupdocs.com</id>
<name>GroupDocs Repository</name>
<url>https://repository.groupdocs.com/repo/</url>
</repository>
</repositories>

click to copy

copied

Manage Document Metadata with Ease

Our solution simplifies managing your document metadata. Easily access, edit, and update various document properties to keep your files organized and searchable.

Effortless Metadata Control

Quickly get and process a document’s metadata. Gain valuable insights like author, creation date, and more.

Simple Metadata Updation

Directly edit document metadata. Update properties for better organization, searchability, and accurate information.

Powerful Metadata Management

Perform advanced operations on document metadata. Easily handle tasks like adding custom properties, removing unnecessary data, and ensuring data consistency.

Clear ZIP archive metadata

The following code snippet shows how to remove the user comment from a ZIP archive

Java


//  Load archive file for further processing
try (Metadata metadata = new Metadata("input.zip")) {

    //  Get main metadata package
    ZipRootPackage root = metadata.getRootPackageGeneric();

    //  Remove archive comments
    root.getZipPackage().setComment(null);

    //  Save cleaned file
    metadata.save("output.zip");
}

About GroupDocs.Metadata for Java API

GroupDocs.Metadata for Java is an advanced metadata fields manipulation solution to easily read, add, update, delete, find, compare, exchange and export metadata information from images and document formats without using any external software. Remove metadata details from Word documents, Excel spreadsheets, PowerPoint presentations, Outlook emails, OneNote, Visio, Project, PDF, AutoCAD, ZIp, Audio and Video file formats along with the support for working with many other metadata processing features.

Learn more