Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Excerpt

The DocumentProperties object represents properties of a spreadsheet. These properties are displayed in the file's Properties sheet which can be opened in Excel 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 ), or on the right). They can also be accessed by right-clicking the file icon in Explorer 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.

...