Message-ID: <1616809241.10003.1711708952199.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10002_1629970739.1711708952199" ------=_Part_10002_1629970739.1711708952199 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html DocumentProperties

DocumentProperties

Description

=20

The DocumentProperties o= bject represents properties of a spreadsheet.

=20 =20

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.

=20
C#
=20
[DefaultMember("Item")]
 public sealed class DocumentProperties
=20
=20
vb.net
=20
<DefaultMember("Item")> _
=09Public NotInheritable Class DocumentProperties
=20
=20

Remarks

To return a=20 DocumentProperties object, use=20 Workb= ook.DocumentProperties.=20

Examples

=20
C#
=20

          ExcelApplication xla =3D new ExcelApplication();
          Workbook wb =3D xla.Create();
          DocumentProperties docProps =3D wb.DocumentProperties;
        
=20
=20
vb.net
=20

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

Properties

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

Name

Description

Application

Sets or returns the name of the application that= created the spreadsheet.

Author

Sets or returns the author of the spreadsheet. T= he author proporty can be used to search for an Excel file.

Category

Sets or returns the category of the spreadsheet.= The category property can be used to search for an Excel file.

Comments

Sets or returns the value of the Comments field = in a workbook's Properties sheet. Comments can used to search for an Excel = file.

Company

Sets or returns the value of the Company field i= n a workbook's Properties sheet. Windows can search for an Excel file using= this value.

CreationDate

Sets or returns the workbook's creation date. By= default, Creation= Date returns the spreadsheet's actual creation date. You can set = CreationDate to a different date, but this will not change the creat= ion date displayed in the spreadsheet's Properties sheet.

Keywords

Sets or returns keywords that can be used to sea= rch for the spreadsheet. In Excel, a file's keywords are displayed in the S= ummary page of the Properties sheet.

LastSavedDate

Sets or returns the date on which the current sp= readsheet was last saved. This value is not set by default, is not displaye= d in the spreadsheet's Properties sheet, and cannot be used to search for a= file.

Manager

Sets or returns the value of the Manager field i= n the spreadsheet's Properties sheet. The manager property can be used to s= earch for an Excel file.

Title

Sets or returns the value of the Title field in = a workbook's Properties sheet. The title property can be used to search for= an Excel file.
=20

Indexers

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

Name

Description

Item(DocumentProperties.BuiltIn)

Returns the value of a specified built-in proper= ty. The value can be one of the following types, depending on the property:= String, Double, Integer, Boolean or DateTime.

Item(String)

Returns the value of a specified property. The v= alue can be one of the following types, depending on the property: String, = Double, Integer, Boolean or DateTime.
=20

Methods

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

Name

Description

Clear()

Clears all properties contained in the DocumentProperties object, removin= g them from the workbook's Properties sheet.

GetCustomProperty(String)

Returns the value of the custom property for the= specified key. The return value can be of the following types, depending o= n the property: String, Double, Integer, Boolean or DateTime. (To create a = custom property, use Do= cumentProperties.SetCustomProperty.)

RestoreDefaults()

Restores document properties values to the defau= lt set of properties and clears all others. The default set of properties a= re Application, CreationDate, and LastSavedDate.

SetCustomProperty(String, Object)

Use SetCustomProperty to create a custom document property. Pass th= e method the name and value of the property. The value can be one of the fo= llowing types, depending on the property: String, Double, Integer, Boolean,= or DateTime.
=20

Nested Classes

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20

Name

Description

BuiltIn

DocumentProperties.BuiltIn contains a set of built-in document prop= erty fields.
------=_Part_10002_1629970739.1711708952199--