Workbook Properties
Include Protected Members
Include Inherited Members
The Workbook type exposes the following members.
Properties
Name | Description | |
---|---|---|
_CodeName | Infrastructure. | |
_ReadOnlyRecommended | Infrastructure. | |
AcceptLabelsInFormulas | Gets or sets a value that indicates whether labels can be used in worksheet formulas. | |
AccuracyVersion | Specifies whether certain worksheet functions use the latest accuracy algorithms to calculate their results. | |
ActiveChart | Gets a Chart object that represents the active chart (either an embedded chart or a chart sheet). An embedded chart is considered active when it is either selected or activated. When no chart is active, this property returns nulla null reference (Nothing in Visual Basic). | |
ActiveSheet | Gets the active sheet (the sheet on top). | |
ActiveSlicer | Gets an object that represents the active slicer in the active workbook or in the specified workbook. | |
Application | Gets an Application that represents the creator of the workbook. | |
Author | Gets or sets the author of the workbook. | |
AutoUpdateFrequency | Gets or sets the number of minutes between automatic updates to the shared workbook. | |
AutoUpdateSaveChanges | Gets or sets a value that indicates whether current changes to the shared workbook are posted to other users whenever the workbook is automatically updated. | |
BindingContext | Gets or sets the collection of currency managers for the IBindableComponent. (Inherited from IBindableComponent.) | |
BuiltinDocumentProperties | Gets a Microsoft.Office.Core.DocumentProperties collection that represents all the built-in document properties for the workbook. | |
CalculationVersion | Gets a number that indicates the version of Excel that the workbook was last fully recalculated by. The rightmost four digits are the minor calculation engine version number, and the other digits (on the left) are the major version of Microsoft Office Excel. | |
ChangeHistoryDuration | Gets or sets the number of days shown in the shared workbook's change history. | |
Charts | Gets a Sheets collection that represents all the chart sheets in the workbook. | |
CheckCompatibility | Gets or sets a value that indicates whether to run the compatibility checker automatically when the workbook is saved. | |
CodeName | Infrastructure. | |
Colors | Gets or sets colors in the palette for the workbook. | |
CommandBars | Gets a Microsoft.Office.Core.CommandBars object that represents the Microsoft Office Excel command bars. | |
Comments | Gets or sets the comments attached to the workbook. | |
ConflictResolution | Gets or sets the way conflicts are to be resolved whenever a shared workbook is updated. | |
Connections | Gets the collection of connections between the workbook and a data source. | |
ConnectionsDisabled | Gets a value that indicates whether to disable the external connections or links in the workbook. | |
Container | Gets the object that represents the container application for the workbook. | |
ContentTypeProperties | Gets a collection of properties that describe metadata that is stored in the workbook. | |
CreateBackup | Gets a value that indicates whether a backup file is created when this file is saved. | |
Creator | Gets the application in which the workbook was created. | |
CustomDocumentProperties | Gets a Microsoft.Office.Core.DocumentProperties collection that represents all the custom document properties for the workbook. | |
CustomViews | Gets a CustomViews collection that represents all the custom views for the workbook. | |
CustomXMLParts | Gets the collection of custom XML parts in the workbook. | |
DataBindings | Gets the collection of data-binding objects for this IBindableComponent. (Inherited from IBindableComponent.) | |
DataHost | Infrastructure. | |
Date1904 | Gets or sets a value that indicates whether the workbook uses the 1904 date system. | |
DefaultExtension | Gets the default extension for this Workbook object. | |
DefaultPivotTableStyle | Gets or sets the table style from the TableStyles property that is used as the default style for PivotTable reports in the workbook. | |
DefaultSlicerStyle | Gets or sets the style from the TableStyles object that is used as the default style for slicers. | |
DefaultTableStyle | Gets or sets the table style from the TableStyles property that is used as the default style for tables in the workbook. | |
DialogSheets | Included for backwards compatibility only. | |
DisplayDrawingObjects | Gets or sets how shapes are displayed. | |
DisplayInkComments | Gets or sets a value that indicates whether ink comments are displayed in the workbook. | |
DocumentInspectors | Gets the collection of Document Inspector modules for the workbook. | |
DocumentLibraryVersions | Gets a Microsoft.Office.Core.DocumentLibraryVersions collection that represents the collection of versions of a shared workbook that has versioning enabled and that is stored in a document library on a server. | |
DoNotPromptForConvert | Gets or sets a value that indicates whether to prompt the user to convert the workbook if it contains features that are not supported by versions of Excel earlier than Excel 2007. | |
EnableAutoRecover | Gets or sets a value that indicates whether Microsoft Office Excel saves changed files, of all formats, on a timed interval. | |
EncryptionProvider | Gets or sets the name of the algorithm encryption provider that Microsoft Office Excel uses when encrypting documents. | |
EnvelopeVisible | Gets or sets a value that indicates whether the e-mail composition header and the envelope toolbar are both visible. | |
Excel4IntlMacroSheets | Gets a Sheets collection that represents all the Microsoft Office Excel 4.0 international macro sheets in the workbook. | |
Excel4MacroSheets | Gets a Sheets collection that represents all the Microsoft Office Excel 4.0 macro sheets in the workbook. | |
Excel8CompatibilityMode | Gets a value that indicates whether the workbook is in compatibility mode. | |
Extension | Gets a custom extension for this Workbook object. | |
FileFormat | Gets the file format and type of the workbook. | |
Final | Gets or sets a value that indicates whether the workbook is final. | |
ForceFullCalculation | Gets or sets a value that indicates whether to force a full calculation of a workbook. | |
FullName | Gets the name of the object, including its path on disk. | |
FullNameURLEncoded | Gets the name of the object, including its path on disk. | |
HasMailer | Infrastructure. | |
HasPassword | Gets a value that indicates whether the workbook has a protection password. | |
HasRoutingSlip | Gets or sets a value that indicates whether the workbook has a routing slip. | |
HasVBProject | Gets a value that indicates whether a workbook has an attached Microsoft Visual Basic for Applications (VBA) project. | |
HighlightChangesOnScreen | Gets or sets a value that indicates whether changes to the shared workbook are highlighted on screen. | |
HostContext | Infrastructure. | |
HTMLProject | Gets the Microsoft.Office.Core.HTMLProject in the workbook, which represents a top-level project branch. | |
IconSets | Gets the collection of built-in icon sets that can be used to apply a conditional formatting rule to a range in the workbook. | |
InactiveListBorderVisible | Gets or sets a value that indicates whether list borders are visible when a list is not active. | |
InnerObject | Gets a Workbook that represents the underlying native object for the Workbook. | |
IsAddin | Gets or sets a value that indicates whether the workbook is running as an add-in. | |
IsInplace | Gets a value that indicates whether the specified workbook is being edited in place. | |
ItemProvider | Infrastructure. | |
KeepChangeHistory | Gets or sets a value that indicates whether change tracking is enabled for the shared workbook. | |
Keywords | Gets or sets the keywords attached to the workbook. | |
ListChangesOnNewSheet | Gets or sets a value that indicates whether changes to the shared workbook are shown on a separate worksheet. | |
Mailer | Infrastructure. | |
Modules | Included for backwards compatibility only. | |
MultiUserEditing | Gets a value that indicates whether the workbook is open as a shared list. | |
Name | Gets the name of the workbook. | |
Names | Gets a Names collection that represents all the names in the workbook (including all worksheet-specific names). | |
OnSave | Included for backwards compatibility only. | |
OnSheetActivate | Included for backwards compatibility only. | |
OnSheetDeactivate | Included for backwards compatibility only. | |
Parent | Gets the parent object for the workbook. | |
Password | Gets or sets the password that must be supplied to open the workbook. | |
PasswordEncryptionAlgorithm | Gets the algorithm that Microsoft Office Excel uses to encrypt passwords for the workbook. | |
PasswordEncryptionFileProperties | Gets a value that indicates whether Microsoft Office Excel encrypts file properties for the specified password-protected workbook. | |
PasswordEncryptionKeyLength | Gets the key length of the algorithm that Microsoft Office Excel uses when encrypting passwords for the workbook. | |
PasswordEncryptionProvider | Gets the name of the algorithm encryption provider that Microsoft Office Excel uses when encrypting passwords for the workbook. | |
Path | Gets the complete path to the application, excluding the final separator and name of the application. | |
Permission | Gets a Microsoft.Office.Core.Permission object that represents the permission settings in the workbook. | |
PersonalViewListSettings | Gets or sets a value that indicates whether filter and sort settings for lists are included in the user's personal view of the shared workbook. | |
PersonalViewPrintSettings | Gets or sets a value that indicates whether print settings are included in the user's personal view of the shared workbook. | |
PrecisionAsDisplayed | Gets or sets a value that indicates whether calculations in this workbook will be done using only the precision of the numbers as they are displayed. | |
ProtectStructure | Gets a value that indicates whether the order of the sheets in the workbook is protected. | |
ProtectWindows | Gets a value that indicates whether the windows of the workbook are protected. | |
PublishObjects | Gets the PublishObjects collection. | |
ReadOnly | Gets a value that indicates whether the workbook has been opened as read-only. | |
ReadOnlyRecommended | Gets or sets a value that indicates whether the workbook was saved as read-only recommended. | |
RemovePersonalInformation | Gets or sets a value that indicates whether personal information can be removed from the workbook. | |
Research | Gets an object that represents the research service for the workbook. | |
RevisionNumber | Gets the number of times the workbook has been saved while open as a shared list. If the workbook is open in exclusive mode, this property returns 0 (zero). | |
Routed | Gets a value that indicates whether the workbook has been routed to the next recipient. | |
RoutingSlip | Gets a RoutingSlip object that represents the routing slip for the workbook. | |
Saved | Gets or sets a value that indicates whether no changes have been made to the workbook since it was last saved. | |
SaveLinkValues | Gets or sets a value that indicates whether Microsoft Office Excel saves external link values with the workbook. | |
ServerPolicy | Gets an object that represents a policy specified for a workbook that is stored on a server running Microsoft Office SharePoint Server. | |
ServerViewableItems | Gets an object that you can use to interact with the list of published objects in the workbook that are shown on a Microsoft Office SharePoint Server server. | |
SharedWorkspace | Gets a Microsoft.Office.Core.SharedWorkspace that represents the Document Workspace in which the workbook is located. | |
Sheets | Gets a Sheets collection that represents all the sheets in the workbook. | |
ShowConflictHistory | Gets or sets a value that indicates whether the Conflict History worksheet is visible in the workbook that is open as a shared list. | |
ShowPivotChartActiveFields | Gets or sets a value that indicates whether the PivotChart Filter Pane is visible. | |
ShowPivotTableFieldList | Gets or sets a value that indicates whether the PivotTable field list can be shown. | |
Signatures | Gets the collection of digital signatures for the workbook. | |
Site | Gets or sets the ISite associated with the IComponent. (Inherited from IComponent.) | |
SlicerCaches | Gets the SlicerCaches object associated with the workbook. | |
SmartDocument | Gets a Microsoft.Office.Core.SmartDocument that represents the settings for a smart document solution. | |
SmartTagOptions | Gets a SmartTagOptions object representing the options that can be performed with a smart tag. This type or member is intended to be used only in projects for the 2007 Microsoft Office system. Smart tags are deprecated in Office 2010. . |
|
Styles | Gets a Styles collection that represents all the styles in the workbook. | |
Subject | Gets or sets the subject for the mailer or routing slip. | |
Sync | Gets a Microsoft.Office.Core.Sync object that provides access to the methods and properties of documents that are part of a Document Workspace. | |
TableStyles | Gets the collection of table styles that are used in the workbook. | |
Tag | Gets or sets the object that contains data about the workbook. | |
TemplateRemoveExtData | Gets or sets a value that indicates whether external data references are removed when the workbook is saved as a template. | |
Theme | Gets the theme that is applied to the workbook. | |
Title | Gets or sets the title of the Web page when the workbook is saved as a Web page. | |
UpdateLinks | Gets or sets a value that indicates a workbook's setting for updating embedded OLE links. | |
UpdateRemoteReferences | Gets or sets a value that indicates whether Microsoft Office Excel updates remote references in the workbook. | |
UserControl | Gets or sets a value that indicates whether the workbook or application was created or opened by the user. | |
UserStatus | Gets a 1-based, two-dimensional array that provides information about each user who has the workbook open as a shared list. | |
VBASigned | Gets a value that indicates whether the Visual Basic for Applications project for the workbook has been digitally signed. | |
VBProject | Gets the virtual Microsoft.Vbe.Interop.VBProject project that is in the workbook. | |
VstoSmartTags | Gets the Microsoft.Office.Tools.SmartTagCollection associated with the workbook. This type or member is intended to be used only in projects for the 2007 Microsoft Office system. Smart tags are deprecated in Office 2010. . |
|
WebOptions | Gets the WebOptions collection, which contains workbook-level attributes used by Microsoft Office Excel when you save a document as a Web page or open a Web page. | |
Windows | Gets a Windows collection that represents all the windows in the workbook. | |
Worksheets | Gets a Sheets collection that represents all the worksheets in the workbook. | |
WritePassword | Gets or sets the write password of a workbook. | |
WriteReserved | Gets a value that indicates whether the workbook is write-reserved. | |
WriteReservedBy | Gets the name of the user who currently has write permission for the workbook. | |
XmlMaps | Gets an XmlMaps collection that represents the schema maps that have been added to the workbook. | |
XmlNamespaces | Gets an XmlNamespaces collection that represents the XML namespaces contained in the workbook. |
Top