Document Properties & Metadata

import java.io.FileOutputStream;
import java.io.IOException;
import java.nio.file.Path;
import java.util.Date;
import java.util.Optional;

import org.apache.poi.ooxml.POIXMLProperties;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.openxmlformats.schemas.officeDocument.x2006.extendedProperties.CTProperties;

public class XlsxProps {

    public static void main(String[] args) throws IOException, InvalidFormatException {
        Path file = Path.of("books-inventory.xlsx");
        try (XSSFWorkbook workbook = new XSSFWorkbook()) {
            workbook.createSheet("Books").createRow(0).createCell(0).setCellValue("Title");

            POIXMLProperties props = workbook.getProperties();

            // core properties (docProps/core.xml)
            POIXMLProperties.CoreProperties core = props.getCoreProperties();
            core.setTitle("Bookshelf inventory");
            core.setSubjectProperty("Book catalogue");
            core.setCreator("Bookshelf export service");
            core.setKeywords("books, inventory");
            core.setDescription("Catalogue exported from the Bookshelf application");
            core.setCategory("Reports");
            core.setLastModifiedByUser("bookshelf-batch");
            core.setCreated(Optional.of(new Date()));
            core.setModified(Optional.of(new Date()));

            // extended properties (docProps/app.xml)
            CTProperties app = props.getExtendedProperties().getUnderlyingProperties();
            app.setApplication("Bookshelf Export 2.3");
            app.setCompany("Bookshelf Library");
            app.setManager("Catalogue team");

            // custom properties (docProps/custom.xml)
            POIXMLProperties.CustomProperties custom = props.getCustomProperties();
            custom.addProperty("ExportedBy", "bookshelf-batch");
            custom.addProperty("SchemaVersion", 3);
            custom.addProperty("RowCount", 1250L);
            custom.addProperty("ContainsPersonalData", false);

            try (FileOutputStream out = new FileOutputStream(file.toFile())) {
                workbook.write(out);
            }
        }

        try (XSSFWorkbook workbook = new XSSFWorkbook(file.toFile())) {
            POIXMLProperties props = workbook.getProperties();
            POIXMLProperties.CoreProperties core = props.getCoreProperties();
            System.out.println("title=" + core.getTitle());
            System.out.println("creator=" + core.getCreator());
            System.out.println("app=" + props.getExtendedProperties().getApplication());
            POIXMLProperties.CustomProperties custom = props.getCustomProperties();
            System.out.println("contains ExportedBy=" + custom.contains("ExportedBy"));
            System.out.println("SchemaVersion=" + custom.getProperty("SchemaVersion").getI4());
        }
    }
}

title=Bookshelf inventory
creator=Bookshelf export service
app=Bookshelf Export 2.3
contains ExportedBy=true
SchemaVersion=3

import java.io.FileOutputStream;
import java.io.IOException;
import java.nio.file.Path;
import java.util.Date;

import org.apache.poi.hpsf.CustomProperties;
import org.apache.poi.hpsf.DocumentSummaryInformation;
import org.apache.poi.hpsf.SummaryInformation;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;

public class XlsProps {

    public static void main(String[] args) throws IOException {
        Path file = Path.of("books-inventory.xls");
        try (HSSFWorkbook workbook = new HSSFWorkbook()) {
            workbook.createSheet("Books").createRow(0).createCell(0).setCellValue("Title");

            // creates the \005SummaryInformation and \005DocumentSummaryInformation streams
            workbook.createInformationProperties();

            SummaryInformation summary = workbook.getSummaryInformation();
            summary.setTitle("Bookshelf inventory");
            summary.setSubject("Book catalogue");
            summary.setAuthor("Bookshelf export service");
            summary.setKeywords("books, inventory");
            summary.setComments("Catalogue exported from the Bookshelf application");
            summary.setApplicationName("Bookshelf Export 2.3");
            summary.setCreateDateTime(new Date());
            summary.setLastSaveDateTime(new Date());

            DocumentSummaryInformation docSummary = workbook.getDocumentSummaryInformation();
            docSummary.setCompany("Bookshelf Library");
            docSummary.setManager("Catalogue team");
            docSummary.setCategory("Reports");

            CustomProperties custom = docSummary.getCustomProperties();
            if (custom == null) {
                custom = new CustomProperties();
            }
            custom.put("ExportedBy", "bookshelf-batch");
            custom.put("SchemaVersion", 3);
            custom.put("RowCount", 1250L);
            custom.put("ContainsPersonalData", Boolean.FALSE);
            docSummary.setCustomProperties(custom);

            try (FileOutputStream out = new FileOutputStream(file.toFile())) {
                workbook.write(out);
            }
        }

        try (POIFSFileSystem fs = new POIFSFileSystem(file.toFile());
             HSSFWorkbook workbook = new HSSFWorkbook(fs)) {
            SummaryInformation summary = workbook.getSummaryInformation();
            DocumentSummaryInformation docSummary = workbook.getDocumentSummaryInformation();
            if (summary == null || docSummary == null) {
                System.out.println("no property sets in this file");
                return;
            }
            System.out.println("title=" + summary.getTitle());
            System.out.println("author=" + summary.getAuthor());
            System.out.println("company=" + docSummary.getCompany());
            CustomProperties custom = docSummary.getCustomProperties();
            System.out.println("SchemaVersion=" + custom.get("SchemaVersion"));
            System.out.println("RowCount=" + custom.get("RowCount") + " " + custom.get("RowCount").getClass().getSimpleName());
        }
    }
}

title=Bookshelf inventory
author=Bookshelf export service
company=Bookshelf Library
SchemaVersion=3
RowCount=1250 Long

import java.io.File;
import java.io.IOException;

import org.apache.poi.hpsf.PropertySet;
import org.apache.poi.hpsf.PropertySetFactory;
import org.apache.poi.hpsf.SummaryInformation;
import org.apache.poi.poifs.filesystem.DirectoryNode;
import org.apache.poi.poifs.filesystem.DocumentInputStream;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;

public class OleSummary {

    public static void main(String[] args) throws Exception {
        try (POIFSFileSystem fs = new POIFSFileSystem(new File("books-inventory.xls"))) {
            DirectoryNode root = fs.getRoot();
            if (root.hasEntry(SummaryInformation.DEFAULT_STREAM_NAME)) {
                try (DocumentInputStream in = root.createDocumentInputStream(SummaryInformation.DEFAULT_STREAM_NAME)) {
                    PropertySet ps = PropertySetFactory.create(in);
                    if (ps instanceof SummaryInformation si) {
                        System.out.println("author=" + si.getAuthor() + " app=" + si.getApplicationName());
                    }
                }
            }
        }
    }
}