Version

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";

View on GitHub