.
| Description |
|---|
| Excerpt |
|---|
The DocumentProperties object represents properties of a spreadsheet.
The |
| Signature | C# | C# | |
|---|---|---|---|
| Wiki Markup | |||
{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}{signature:vb.net | vb.net | }
<DefaultMember("Item")> _
Public NotInheritable Class DocumentProperties
| |
| Remarks | |||
To return a DocumentProperties object, use {signature} {remarks}To return a {{DocumentProperties}} object, use [Workbook.DocumentProperties. | |||
| Example | |||
| Code Block | | csharp | csharp |
| title | C# | ||
| Code Block | vb.net | title |
| Properties |
|---|
...
Name
...
Description
...
...
{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 |
...
| Indexers |
|---|
...
Name
...
Description
|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 |
...
| Methods |
|---|
...
Name
...
Description
...
...
=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 |
...
| Classes |
|---|
...
Name
...
Description
...
...
=true}| {classes} ||Name||Description|| |[BuiltIn|DocumentProperties.BuiltIn]|{excerpt-include:DocumentProperties.BuiltIn |
...
|nopanel=true}|
|