View Source

The DocumentProperties object represents properties of a spreadsheet. These properties are displayed in the file's Properties sheet which can be opened in Excel (File -> Properties), or by right-clicking the file icon and selecting "Properties." The DocumentProperties class can be used to remove personal information from an existing spreadsheet, or to populate searchable fields that can be used to locate the file.

[DefaultMember("Item")]
 public sealed class DocumentProperties

<DefaultMember("Item")> _
	Public NotInheritable Class DocumentProperties

To return a DocumentProperties object, use Workbook.DocumentProperties.


          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          DocumentProperties docProps = wb.DocumentProperties;


          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Create()
          Dim docProps = wb.DocumentProperties

Name	Description
Application
Author
Category
Comments
Company
CreationDate
Keywords
LastSavedDate
Manager
Title

Name	Description
Item(DocumentProperties.BuiltIn)
Item(String)

Name	Description
Clear()
GetCustomProperty(String)
RestoreDefaults()
SetCustomProperty(String, Object)

Name	Description
BuiltIn