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 Visual Basic:

Dim workbook As New Infragistics.Documents.Excel.Workbook()
workbook.DocumentProperties.Title = "Expense Report"
workbook.DocumentProperties.Status = "Complete"

In C#:

Infragistics.Documents.Excel.Workbook workbook = new Infragistics.Documents.Excel.Workbook();
workbook.DocumentProperties.Title = "Expense Report";
workbook.DocumentProperties.Status = "Complete";