Add Metadata to XLSX in Java

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

Download Free Trial

About GroupDocs.Metadata for Java API

GroupDocs.Metadata for Java is an advanced metadata fields management and manipulation solution to easily view, update, remove, find, compare, exchange and export metadata information from images and document formats without using any external software. Add metadata details to 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.

Steps for adding Metadata to XLSX in Java

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

  • Load the XLSX file to be updated.
  • Specify a predicate that will be used to add metadata properties.
  • Specify a value which you want to be assigned to the selected properties.
  • Pass the predicate to the AddProperties method.
  • Check the actual number of added properties.
  • Save the changes.

System Requirements

GroupDocs.Metadata for Java APIs are supported on all major platforms and operating systems. 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.Metadata for Java from Maven

// load the file in an instance of Metadata class
try (Metadata metadata = new Metadata("input.xlsx")) {

	// add a property containing the content author
	int affected = metadata.addProperties(new ContainsTagSpecification(Tags.getTime().getPrinted()), new PropertyValue(new Date()));

	System.out.println(String.format("Affected properties: %s", affected));

	metadata.save("output.xlsx");
}

Live Demos to Add Metadata

Add metadata information to XLSX file right now by visiting GroupDocs.Metadata Live Demos website.
The live demo has the following benefits

No need to download GroupDocs API.

No need to write any code

Just upload the source file to have an instant display.

Get the download link to save the file on your machine.

About XLSX File Format

XLSX is well-known format for Microsoft Excel documents that was introduced by Microsoft with the release of Microsoft Office 2007. Based on structure organized according to the Open Packaging Conventions as outlined in Part 2 of the OOXML standard ECMA-376, the new format is a zip package that contains a number of XML files. The underlying structure and files can be examined by simply unzipping the .xlsx file.

Read More

Adding Metadata Properties To Other File Formats

Java API for adding metadata to multi format documents and images. Set metadata details of some of the popular file formats as stated below.

Add PDF Metadata

(Adobe Portable Document Format)

Add DOC Metadata

(Microsoft Word Document)

Add DOCM Metadata

(Microsoft Word Macro-Enabled Document)

Add DOCX Metadata

(Microsoft Word Open XML Document)

Add DOT Metadata

(Microsoft Word Document Template)

Add DOTX Metadata

(Word Open XML Document Template)

Add XLS Metadata

(Microsoft Excel Binary File Format)

Add XLSX Metadata

(Microsoft Excel Open XML Spreadsheet)

Add XLSM Metadata

(Microsoft Excel Macro-Enabled Spreadsheet)

Add XLTM Metadata

(OOXML Macro Enabled Workbook Template)

Add PPT Metadata

(PowerPoint Presentation)

Add PPS Metadata

(Microsoft PowerPoint Slide Show)

Add PPTX Metadata

(PowerPoint Open XML Presentation)

Add PPSX Metadata

(PowerPoint Open XML Slide Show)

Add POTX Metadata

(Microsoft PowerPoint Open XML Template)

Add POTM Metadata

(Microsoft PowerPoint Template)

Add PPTM Metadata

(Microsoft PowerPoint Presentation)

Add PPSM Metadata

(Microsoft PowerPoint Slide Show)

Add ODS Metadata

(Open Document Spreadsheet)

Add ODT Metadata

(Open Document Text)

Add TIFF Metadata

(Tagged Image File Format)

Add JPEG Metadata

(JPEG Image)

Add PNG Metadata

(Portable Network Graphic)

Add GIF Metadata

(Graphical Interchange Format File)

Add BMP Metadata

(Bitmap File Format)

Add JP2 Metadata

(JPEG 2000 Core Image File)

Add WEBP Metadata

(Raster Web Image File Format)

Add PSD Metadata

(Adobe Photoshop Document)

Add WMF Metadata

(Windows Metafile)

Add EMF Metadata

(Enhanced Metafile Format)

Add MPP Metadata

(Microsoft Project Document)

Add MSG Metadata

(Microsoft Outlook E-mail Message)

Add EML Metadata

(E-mail Message)

Add DWG Metadata

(Autodesk Design Data Formats)

Add DXF Metadata

(AutoCAD Drawing Interchange)

Add ONE Metadata

(Microsoft OneNote)

Add MP3 Metadata

(MPEG Audio Layer III)

Add WAV Metadata

(Waveform Audio File Format)

Add DICOM Metadata

(Digital Imaging & Comm in Medicine)

Add AVI Metadata

(Audio Video Interleave File)

Add VSD Metadata

(Microsoft Visio 2003-2010 Drawing)

Add VSDX Metadata

(Microsoft Visio Drawing)

Add VSS Metadata

(Microsoft Visio 2003-2010 Stencil)

Add VDX Metadata

(Microsoft Visio 2003-2010 XML Drawing)

Add VSX Metadata

(Microsoft Visio 2003-2010 XML Stencil)

Add ZIP Metadata

(Archive File Format)

Add EPUB Metadata

(Digital E-Book File Format)

Add VCF Metadata

(Electronic Business Card)