Document properties

The following example shows you how to set and read document properties such as title, author, subject and keywords.

import com.independentsoft.office.spreadsheet.Cell;
import com.independentsoft.office.spreadsheet.Workbook;
import com.independentsoft.office.spreadsheet.Worksheet;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Workbook book = new Workbook();

            book.setTitle("Quarterly Report");
            book.setCreator("John Smith");
            book.setSubject("Sales Data Q1 2026");
            book.setKeywords("sales, quarterly, report");
            book.setDescription("This workbook contains Q1 2026 sales data.");
            book.setCategory("Finance");
            book.setLastModifiedBy("John Smith");

            Worksheet sheet = new Worksheet();
            sheet.set("A1", new Cell("See document properties for metadata."));
            book.getSheets().add(sheet);

            book.save("c:\\test\\output.xlsx", true);

            Workbook loaded = new Workbook("c:\\test\\output.xlsx");
            System.out.println("Title:   " + loaded.getTitle());
            System.out.println("Creator: " + loaded.getCreator());
            System.out.println("Subject: " + loaded.getSubject());
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

IndependentsoftProfessional software libraries for developers

JSpreadsheet > Tutorial > Document properties

Need help? Ask our developers: