Page History

{description}
{excerpt}The [DocumentProperties|DocumentProperties] object represents properties of a spreadsheet. 

* In Excel 2003 these properties can be accessed via \(File \-> Properties\). 
* In Excel 2007 they can be accessed via (Ribbon button -> Prepare -> Properties). 
* In Excel 2010 they can be accessed via (File -> Info -> Show All Properties on the right). 
* In Windows Explorer, right\-click on the file and select '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.{excerpt}
{signature:C#}
[DefaultMember("Item")]
 public sealed class DocumentProperties
{signature}{signature:vb.net}
<DefaultMember("Item")> _
	Public NotInheritable Class DocumentProperties
{signature}
{remarks}To return a {{DocumentProperties}} object, use [Workbook.DocumentProperties|Workbook.DocumentProperties].

{remarks}
{example}{code:csharp|title=C#}

          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          DocumentProperties docProps = wb.DocumentProperties;
        {code}
{code:vb.net|title=vb.net}

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

{example}
{properties}
||Name||Description||
|[Application|DocumentProperties.Application]|{excerpt-include:DocumentProperties.Application|nopanel=true}|
|[Author|DocumentProperties.Author]|{excerpt-include:DocumentProperties.Author|nopanel=true}|
|[Category|DocumentProperties.Category]|{excerpt-include:DocumentProperties.Category|nopanel=true}|
|[Comments|DocumentProperties.Comments]|{excerpt-include:DocumentProperties.Comments|nopanel=true}|
|[Company|DocumentProperties.Company]|{excerpt-include:DocumentProperties.Company|nopanel=true}|
|[CreationDate|DocumentProperties.CreationDate]|{excerpt-include:DocumentProperties.CreationDate|nopanel=true}|
|[Keywords|DocumentProperties.Keywords]|{excerpt-include:DocumentProperties.Keywords|nopanel=true}|
|[LastSavedDate|DocumentProperties.LastSavedDate]|{excerpt-include:DocumentProperties.LastSavedDate|nopanel=true}|
|[Manager|DocumentProperties.Manager]|{excerpt-include:DocumentProperties.Manager|nopanel=true}|
|[Title|DocumentProperties.Title]|{excerpt-include:DocumentProperties.Title|nopanel=true}|
{indexers}
||Name||Description||
|[Item(DocumentProperties.BuiltIn)|DocumentProperties.Item(DocumentProperties.BuiltIn)]|{excerpt-include:DocumentProperties.Item(DocumentProperties.BuiltIn)|nopanel=true}|
|[Item(String)|DocumentProperties.Item(String)]|{excerpt-include:DocumentProperties.Item(String)|nopanel=true}|
{methods}
||Name||Description||
|[Clear()|DocumentProperties.Clear()]|{excerpt-include:DocumentProperties.Clear()|nopanel=true}|
|[GetCustomProperty(String)|DocumentProperties.GetCustomProperty(String)]|{excerpt-include:DocumentProperties.GetCustomProperty(String)|nopanel=true}|
|[RestoreDefaults()|DocumentProperties.RestoreDefaults()]|{excerpt-include:DocumentProperties.RestoreDefaults()|nopanel=true}|
|[SetCustomProperty(String, Object)|DocumentProperties.SetCustomProperty(String, Object)]|{excerpt-include:DocumentProperties.SetCustomProperty(String, Object)|nopanel=true}|
{classes}
||Name||Description||
|[BuiltIn|DocumentProperties.BuiltIn]|{excerpt-include:DocumentProperties.BuiltIn|nopanel=true}|