Workbook Properties

The Workbook type exposes the following members.

Properties
  NameDescription
Public propertyAbsolutePath
Gets and sets the absolute path of the file.
Public propertyCode exampleBuiltInDocumentProperties
Returns a DocumentProperties collection that represents all the built-in document properties of the spreadsheet.
Public propertyColors
Returns colors in the palette for the spreadsheet.
Public propertyContentTypeProperties
Gets the contenttypeproperties objects in the workbook.
Public propertyCountOfStylesInPool
Gets number of the styles in the style pool.
Public propertyCode exampleCustomDocumentProperties
Returns a DocumentProperties collection that represents all the custom document properties of the spreadsheet.
Public propertyCustomXmlParts
Represents a InnerCustom XML Data Storage Part (custom XML data within a package).
Public propertyDataConnections
Gets the ExternalConnection collection.
Public propertyDataSorter
Gets a DataSorter object to sort data.
Public propertyCode exampleDefaultStyle
Gets or sets the default Style object of the workbook.
Public propertyFileFormat
Gets and sets the file format.
Public propertyFileName
Gets and sets the current file name.
Public propertyHasMacro
Indicates if this spreadsheet contains macro/VBA.
Public propertyHasRevisions
Gets if the workbook has any tracked changes
Public propertyInterruptMonitor
Gets and sets the interrupt monitor.
Public propertyIsDigitallySigned
Indicates if this spreadsheet is digitally signed.
Public propertyIsLicensed
Indicates whether license is set.
Public propertyRibbonXml
Gets and sets the XML file that defines the Ribbon UI.
Public propertySettings
Represents the workbook settings.
Public propertyTheme
Gets the theme name.
Public propertyVbaProject
Gets the VbaProject in a spreadsheet.
Public propertyWorksheets
Gets the WorksheetCollection collection in the spreadsheet.
See Also