Skip to content

Supported Excel Metadata Attributes

Jump to bottom
Jörn Franke edited this page Dec 29, 2016 · 7 revisions

This page describes which metadata attributes are supported for writing an Excel document.

OOXML (.xlsx)

Core Properties

The following core properties are supported for writing: The following core properties are supported.

  • hadoopoffice.write.metadata.category
  • hadoopoffice.write.metadata.contentstatus
  • hadoopoffice.write.metadata.contenttype
  • hadoopoffice.write.metadata.created (date)
  • hadoopoffice.write.metadata.creator
  • hadoopoffice.write.metadata.description
  • hadoopoffice.write.metadata.identifier
  • hhadoopoffice.write.metadata.keywords
  • hadoopoffice.write.metadata.lastmodifiedbyuser
  • hadoopoffice.write.metadata.lastprinted (date)
  • hadoopoffice.write.metadata.modified (date)
  • hadoopoffice.write.metadata.revision (int)
  • hadoopoffice.write.metadata.subject
  • hadoopoffice.write.metadata.title

Please note that all dates need to correspond to the following pattern: "hh:mm:ss dd.MM.yyyy", for example, "12:00:00 01.01.2016".

Custom Properties

You can define any type of custom property. For example, hadoopoffice.write.metadata.custom.mycustomproperty will create a custom property "mycustomproperty" in the Excel document. Each value of this property is interpreted as String.

Old Excel format (.xls)

The following properties are supported for the old Excel format.

  • hadoopoffice.write.metadata.applicationname
  • hadoopoffice.write.metadata.author
  • hadoopoffice.write.metadata.charcount (int)
  • hadoopoffice.write.metadata.comments
  • hadoopoffice.write.metadata.createdatetime (date)
  • hadoopoffice.write.metadata.edittime (long)
  • hadoopoffice.write.metadata.keywords
  • hadoopoffice.write.metadata.lastauthor
  • hadoopoffice.write.metadata.lastprinted (date)
  • hadoopoffice.write.metadata.lastsavedatetime (date)
  • hadoopoffice.write.metadata.pagecount (int)
  • hadoopoffice.write.metadata.revnumber (int)
  • hadoopoffice.write.metadata.security (int)
  • hadoopoffice.write.metadata.subject
  • hadoopoffice.write.metadata.template
  • hadoopoffice.write.metadata.title
  • hadoopoffice.write.metadata.wordcount (int)

Please note that all dates need to correspond to the following pattern: "hh:mm:ss dd.MM.yyyy", for example, "12:00:00 01.01.2016". Integers and long can only accept Strings containing integer/long.

Clone this wiki locally