Version

Setting Workbook Properties (Infragistics Excel Engine)

Microsoft® Excel® document properties provide information to help organize and keep track of your documents. You can use the Infragistics Excel Engine to set these properties using the Workbook object’s DocumentProperties property. The available properties are:

  • Author

  • Title

  • Subject

  • Keywords

  • Category

  • Status

  • Comments

  • Company

  • Manager

The following code demonstrates how to create a workbook and set its Title and Status document properties.

In Visual Basic:

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

In C#:

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