Skip to content

Instantly share code, notes, and snippets.

@groupdocs-com-kb
Last active April 19, 2024 14:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save groupdocs-com-kb/832a4e6530941e6be655f628a7d4fe00 to your computer and use it in GitHub Desktop.
Save groupdocs-com-kb/832a4e6530941e6be655f628a7d4fe00 to your computer and use it in GitHub Desktop.
Remove Metadata from XLS using C#. For more information, please follow link: https://kb.groupdocs.com/metadata/net/remove-metadata-from-xls-using-csharp/
using GroupDocs.Metadata;
using GroupDocs.Metadata.Common;
using GroupDocs.Metadata.Tagging;
namespace RemoveMetadatafromXLSUsingCSharp
{
internal class Program
{
static void Main(string[] args)
{
// Set License to avoid the limitations of Metadata library
License lic = new License();
lic.SetLicense(@"GroupDocs.Metadata.lic");
using (Metadata metadata = new Metadata("input.xls"))
{
// Remove all the properties satisfying the predicate:
// property contains the name of the document author OR
// it refers to the last editor OR
// the property value is a string that contains the substring "John"
// (to remove any mentions of John from the detected metadata)
var affected = metadata.RemoveProperties(
p => p.Tags.Contains(Tags.Person.Creator) ||
p.Tags.Contains(Tags.Person.Editor) ||
p.Value.Type == MetadataPropertyType.String
&& p.Value.ToString().Contains("John"));
Console.WriteLine("Properties removed: {0}", affected);
metadata.Save("output.xls");
}
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment