Add Document Properties to a Workbook

Associated with each workbook file are various properties that provide information about its content. These properties include the following pieces of information:

• Author
• Title
• Subject
• Keywords
• Category
• Status
• Comments

This information can be accessed through the Microsoft® Excel® interface as well as the Properties dialog box for the workbook file. You can edit this information in a workbook before serializing it by using its DocumentProperties property.

The following code demonstrates how to create a workbook and set its title and status document properties.

In JavaScript:

var workbook = new $.ig.excel.Workbook();
workbook.documentProperties.title("Expense Report");
workbook.documentProperties.status("Complete");