GroupDocs.Metadata for .NET API

Remove Metadata From XLS File In C#

Remove metadata information from a variety of documents, images, audio & video file formats using GroupDocs.Metadata for .NET API

NuGet Download

Start Free Trial

Steps for Removing XLS Metadata in C#

GroupDocs.Metadata makes it easy for .NET developers to remove metadata details to XLS files from within their applications by implementing a few easy steps.

Load XLS with an instance of Metadata class.
Use a predicate to find desired metadata properties.
Use Metadata.RemoveProperties method to remove the properties.
Save the changes back in XLS format.

Copy

// Remove XLS file metadata
using (var metadata = new GroupDocs.Metadata.Metadata("input.xls"))
{
    // Remove all mentions of any people contributed in file creation
    // Remove all properties with the specified name
    var affected = metadata.RemoveProperties(
        p => p.Tags.Any(t => t.Category == Tags.Person) 
        || p.Name == "CustomProperty");
                
    Console.WriteLine("Affected properties: {0}", affected);

    // Save result
    metadata.Save("output.xls");
}

dotnet add package GroupDocs.Metadata

click to copy

copied

Manage Document Metadata Easily

Keep your files organized and searchable with our easy-to-use document metadata management. Access, edit, and update various details to find what you need quickly.

See Document Metadata Quickly

Get all the important information about a document instantly, like author, creation date, and more.

Edit Document Metadata Easily

Update metadata directly in your documents for better organization, searchability, and accuracy.

Powerful Document Metadata Management

Do more with your document metadata! Add custom information, remove unnecessary data, and ensure everything stays consistent.

Clear ZIP archive metadata

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

C#


    //  Load archive file for further processing
    using (Metadata metadata = new Metadata("input.zip"))
    {
        //  Get main metadata package
        var root = metadata.GetRootPackage<ZipRootPackage>();

        //  Remove archive comments
        root.ZipPackage.Comment = null;

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

About GroupDocs.Metadata for .NET API

GroupDocs.Metadata for .NET offers an advanced set of metadata manipulation features, allowing developers to easily read, edit, remove, search, compare, replace and export metadata information from images and document formats without using any external software. Use metadata management API to delete metadata details from PDF, Microsoft Office Word, Excel spreadsheets, PowerPoint presentations, Outlook, OneNote, Visio, Project, AutoCAD, Archive and Multimedia file formats along with many other metadata processing features.

Learn more