Remove OR Update Author Name from XLS Metadata in Java

What is Metadata Redaction?

Redaction refers to the removal of unwanted or confidential information from electronic documents. All the file formats including PDF, DOC, DOCX, PPT, PPTX, XLS, XLSX and others have some metadata properties. These properties include author name, category, company name, comments, creation time, last updated and many more. Sometimes you need to completely delete unwanted metadata fields or you might want to update their values. There are also some hidden data associated with the files which can be viewed using various tools and techniques. There are many cases when you don’t want this data to be accessed by anyone. With GroupDocs.Redaction API you can apply metadata redactions to any of these metadata properties. You can change or delete them by filtering the metadata you want. In this guide we will explain how you can redact author name from XLS metadata in Java.

Redact XLS Metadata in Java

Following code allows you to search and redact sensitive data from a XLS document. You can set scope for redaction by setting filter, e.g. to MetadataFilter.Author. It will leave the regular expressions matches undone in all metadata items, except “Author” property:

How to Redact XLS Metadata

Create an instance of Redactor class & upload XLS file
Create an instance of MetadataSearchRedaction class to find and replace sensitive data from document’s metadata
Set scope for redaction by setting filter, e.g. Use MetadataFilters.Author in below code
Call redactor.save method with object of MetadataSearchRedaction

	final Redactor redactor = new Redactor(filePath);
	try
	{
	MetadataSearchRedaction redaction = new MetadataSearchRedaction("Author Name", "--author--");
	redaction.setFilter(MetadataFilters.Author);
	redactor.apply(redaction);
	SaveOptions options = new SaveOptions();
	options.setAddSuffix(true);
	options.setRasterizeToPDF(false);
	// Save the document to "_Redacted." file in original format
	redactor.save(options);
	}
	finally { redactor.close(); }

view raw RedactAuthorMetadata.java hosted with ❤ by GitHub

Remove Author Metadata in Java

You can replace all or specific metadata in the document with empty (blank or minimal) values using EraseMetadataRedaction class. Following code shows how you can filter and then remove a metadata property from a XLS document.The example below blanks out all properties of the document:

Erase XLS Metadata

Create an instance of Redactor class & upload XLS file
Create an instance of MetadataSearchRedaction class to remove metadata of the document
Set scope for redaction by setting filter, e.g. Replace MetadataFilter.All with MetadataFilter.Author in below code
Call redactor.save method with object of MetadataSearchRedaction

	final Redactor redactor = new Redactor(filePath);
	try
	{
	redactor.apply(new EraseMetadataRedaction(MetadataFilters.All));
	SaveOptions options = new SaveOptions();
	options.setAddSuffix(true);
	options.setRasterizeToPDF(false);
	// Save the document to "_Redacted." file in original format
	redactor.save(options);
	}
	finally { redactor.close(); }

view raw CleanMetadata.java hosted with ❤ by GitHub

System Requirements

GroupDocs.Redaction for Java APIs are supported on all major platforms and operating systems. For complete system requirements guide, please visit system requirements Before executing the code below, please make sure that you have the following prerequisites installled on your system:

Operating Systems: Microsoft Windows, Linux, MacOS
Development Environment: NetBeans, Intellij IDEA, Eclipse etc
Java Runtime Environment: J2SE 6.0 and above
Get the latest version of GroupDocs.Redaction for Java from Maven

Why Use GroupDocs.Redaction

Allow users to add custom document formats and types of redactions
No additional software is required to remove sensitive information
Ability to set page range rendering document as PDF
Easy way to redact different types of metadata: author name, version, title, subject, description and many more
Document information extraction - file type, page count etc.

What is XLS File Format?

Files with XLS extension represent Excel Binary File Format. Such files can be created by Microsoft Excel as well as other similar spreadsheet programs such as OpenOffice Calc or Apple Numbers. File saved by Excel is known as Workbook where each workbook can have one or more worksheets. Data is stored and displayed to users in table format in worksheet and can span numeric values, text data, formulas, external data connections, images, and charts. Applications like Microsoft Excel lets you export workbook data to several different formats including PDF, CSV, XLSX, TXT, HTML, XPS, and several others. The XLS file format was replaced with a more open and structured format, XLSX, with the release of Microsoft Excel 2007. The latest versions still provide support for creating and reading XLS files, though XLSX is the first choice of use now.

Remove OR Update Author Name From XLS Metadata In Java

GroupDocs.Redactions provides a flexible API that allows to search & replace/remove any metadata property using filters.

What is Metadata Redaction?

Redact XLS Metadata in Java

How to Redact XLS Metadata

Remove Author Metadata in Java

Erase XLS Metadata

System Requirements

Why Use GroupDocs.Redaction

What is XLS File Format?

Popular Redaction Options

Redact BMP Files

Redact DOC Files

Redact DOCM Files

Redact DOCX Files

Redact DOT Files

Redact DOTM Files

Redact DOTX Files

Redact GIF Files

Redact JPEG Files

Redact PDF Files

Redact PNG Files

Redact POT Files

Redact POTM Files

Redact PPS Files

Redact PPSM Files

Redact PPSX Files

Redact PPT Files

Redact PPTM Files

Redact PPTX Files

Redact RTF Files

Redact TIFF Files

Redact XLSM Files

Redact XLSX Files

Redact XLT Files

Redact XLTM Files

Redact XLTX Files