Upgrade your Internet Experience
Microsoft.com
Welcome Sign in
Office Development with Visual Studio Developer Center
Click to Rate and Give Feedback

  Switch on low bandwidth view
Members FilterMembers Filter
This page is specific to
Microsoft Visual Studio 2008/.NET Framework 3.5

Other versions are also available for the following:
Visual Studio Tools for Office API Reference
Workbook Properties (2007 System)

The Workbook type exposes the following members.

  NameDescription
Public property_CodeNameInfrastructure.
Public property_ReadOnlyRecommendedInfrastructure.
Public propertyAcceptLabelsInFormulasGets or sets a value that indicates whether labels can be used in worksheet formulas.
Public propertyActiveChartGets a Microsoft.Office.Interop.Excel..::.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 nullNothingnullptra null reference (Nothing in Visual Basic).
Public propertyActiveSheetGets the active sheet (the sheet on top).
Public propertyApplicationGets an Microsoft.Office.Interop.Excel..::.Application that represents the creator of the workbook.
Public propertyAuthorGets or sets the author of the workbook.
Public propertyAutoUpdateFrequencyGets or sets the number of minutes between automatic updates to the shared workbook.
Public propertyAutoUpdateSaveChangesGets or sets a value that indicates whether current changes to the shared workbook are posted to other users whenever the workbook is automatically updated.
Public propertyBindingContext (Inherited from EntryPointBindableComponentBase.)
Public propertyBuiltinDocumentPropertiesGets a Microsoft.Office.Core.DocumentProperties collection that represents all the built-in document properties for the workbook.
Public propertyCalculationVersionGets 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.
Public propertyChangeHistoryDurationGets or sets the number of days shown in the shared workbook's change history.
Public propertyChartsGets a Microsoft.Office.Interop.Excel..::.Sheets collection that represents all the chart sheets in the workbook.
Public propertyCheckCompatibilityGets or sets a value that indicates whether to run the compatibility checker automatically when the workbook is saved.
Public propertyCodeNameInfrastructure.
Public propertyColorsGets or sets colors in the palette for the workbook.
Public propertyCommandBarsGets a Microsoft.Office.Core.CommandBars object that represents the Microsoft Office Excel command bars.
Public propertyCommentsGets or sets the comments attached to the workbook.
Public propertyConflictResolutionGets or sets the way conflicts are to be resolved whenever a shared workbook is updated.
Public propertyConnectionsGets the collection of connections between the workbook and a data source.
Public propertyConnectionsDisabledGets a value that indicates whether to disable the external connections or links in the workbook.
Public propertyContainerGets the object that represents the container application for the workbook.
Public propertyContainerComponent (Inherited from EntryPointBindableComponentBase.)
Public propertyContentTypePropertiesGets a collection of properties that describe metadata that is stored in the workbook.
Public propertyCreateBackupGets a value that indicates whether a backup file is created when this file is saved.
Public propertyCreatorGets the application in which the workbook was created.
Public propertyCustomDocumentPropertiesGets a Microsoft.Office.Core.DocumentProperties collection that represents all the custom document properties for the workbook.
Public propertyCustomViewsGets a Microsoft.Office.Interop.Excel..::.CustomViews collection that represents all the custom views for the workbook.
Public propertyCustomXMLPartsGets the collection of custom XML parts in the workbook.
Public propertyDataBindings (Inherited from EntryPointBindableComponentBase.)
Protected propertyDataHost (Inherited from EntryPointComponentBase.)
Public propertyDate1904Gets or sets a value that indicates whether the workbook uses the 1904 date system.
Public propertyDefaultDataSourceUpdateMode (Inherited from EntryPointBindableComponentBase.)
Public propertyDefaultPivotTableStyleGets or sets the table style from the TableStyles property that is used as the default style for PivotTable reports in the workbook.
Public propertyDefaultTableStyleGets or sets the table style from the TableStyles property that is used as the default style for tables in the workbook.
Protected propertyDesignMode (Inherited from RemoteComponent.)
Public propertyDialogSheetsIncluded for backwards compatibility only.
Public propertyDisplayDrawingObjectsGets or sets how shapes are displayed.
Public propertyDisplayInkCommentsGets or sets a value that indicates whether ink comments are displayed in the workbook.
Public propertyDocumentInspectorsGets the collection of Document Inspector modules for the workbook.
Public propertyDocumentLibraryVersionsGets 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.
Public propertyDoNotPromptForConvertGets 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.
Public propertyEnableAutoRecoverGets or sets a value that indicates whether Microsoft Office Excel saves changed files, of all formats, on a timed interval.
Public propertyEncryptionProviderGets or sets the name of the algorithm encryption provider that Microsoft Office Excel 2007 uses when encrypting documents.
Public propertyEnvelopeVisibleGets or sets a value that indicates whether the e-mail composition header and the envelope toolbar are both visible.
Public propertyExcel4IntlMacroSheetsGets a Microsoft.Office.Interop.Excel..::.Sheets collection that represents all the Microsoft Office Excel 4.0 international macro sheets in the workbook.
Public propertyExcel4MacroSheetsGets a Microsoft.Office.Interop.Excel..::.Sheets collection that represents all the Microsoft Office Excel 4.0 macro sheets in the workbook.
Public propertyExcel8CompatibilityModeGets a value that indicates whether the workbook is in compatibility mode.
Public propertyFileFormatGets the file format and type of the workbook.
Public propertyFinalGets or sets a value that indicates whether the workbook is final.
Public propertyForceFullCalculationGets or sets a value that indicates whether to force a full calculation of a workbook.
Public propertyFullNameGets the name of the object, including its path on disk.
Public propertyFullNameURLEncodedGets the name of the object, including its path on disk.
Public propertyHasMailerInfrastructure.
Public propertyHasPasswordGets a value that indicates whether the workbook has a protection password.
Public propertyHasRoutingSlipGets or sets a value that indicates whether the workbook has a routing slip.
Public propertyHasVBProjectGets a value that indicates whether a workbook has an attached Microsoft Visual Basic for Applications (VBA) project.
Public propertyHighlightChangesOnScreenGets or sets a value that indicates whether changes to the shared workbook are highlighted on screen.
Protected propertyHostContext (Inherited from RemoteComponent.)
Public propertyHTMLProjectGets the Microsoft.Office.Core.HTMLProject in the workbook, which represents a top-level project branch.
Public propertyIconSetsGets the collection of built-in icon sets that can be used to apply a conditional formatting rule to a range in the workbook.
Protected propertyIdentifier (Inherited from RemoteComponent.)
Public propertyInactiveListBorderVisibleGets or sets a value that indicates whether list borders are visible when a list is not active.
Public propertyInnerObjectGets a Microsoft.Office.Interop.Excel..::.Workbook that represents the underlying native object for the Workbook.
Protected propertyInnerType (Inherited from RemoteComponent.)
Public propertyIsAddinGets or sets a value that indicates whether the workbook is running as an add-in.
Public propertyIsInplaceGets a value that indicates whether the specified workbook is being edited in place.
Protected propertyItemProvider (Inherited from RemoteComponent.)
Public propertyKeepChangeHistoryGets or sets a value that indicates whether change tracking is enabled for the shared workbook.
Public propertyKeywordsGets or sets the keywords attached to the workbook.
Public propertyListChangesOnNewSheetGets or sets a value that indicates whether changes to the shared workbook are shown on a separate worksheet.
Public propertyMailerInfrastructure.
Public propertyModulesIncluded for backwards compatibility only.
Public propertyMultiUserEditingGets a value that indicates whether the workbook is open as a shared list.
Public propertyNameGets the name of the workbook.
Public propertyNamesGets a Microsoft.Office.Interop.Excel..::.Names collection that represents all the names in the workbook (including all worksheet-specific names).
Public propertyOnSaveIncluded for backwards compatibility only.
Public propertyOnSheetActivateIncluded for backwards compatibility only.
Public propertyOnSheetDeactivateIncluded for backwards compatibility only.
Public propertyParentGets the parent object for the workbook.
Public propertyPasswordGets or sets the password that must be supplied to open the workbook.
Public propertyPasswordEncryptionAlgorithmGets the algorithm that Microsoft Office Excel uses to encrypt passwords for the workbook.
Public propertyPasswordEncryptionFilePropertiesGets a value that indicates whether Microsoft Office Excel encrypts file properties for the specified password-protected workbook.
Public propertyPasswordEncryptionKeyLengthGets the key length of the algorithm that Microsoft Office Excel uses when encrypting passwords for the workbook.
Public propertyPasswordEncryptionProviderGets the name of the algorithm encryption provider that Microsoft Office Excel uses when encrypting passwords for the workbook.
Public propertyPathGets the complete path to the application, excluding the final separator and name of the application.
Public propertyPermissionGets a Microsoft.Office.Core.Permission object that represents the permission settings in the workbook.
Public propertyPersonalViewListSettingsGets 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.
Public propertyPersonalViewPrintSettingsGets or sets a value that indicates whether print settings are included in the user's personal view of the shared workbook.
Public propertyPrecisionAsDisplayedGets 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.
Protected propertyPrimaryCookie (Inherited from RemoteComponent.)
Public propertyProtectStructureGets a value that indicates whether the order of the sheets in the workbook is protected.
Public propertyProtectWindowsGets a value that indicates whether the windows of the workbook are protected.
Public propertyPublishObjectsGets the Microsoft.Office.Interop.Excel..::.PublishObjects collection.
Public propertyReadOnlyGets a value that indicates whether the workbook has been opened as read-only.
Public propertyReadOnlyRecommendedGets or sets a value that indicates whether the workbook was saved as read-only recommended.
Public propertyRemovePersonalInformationGets or sets a value that indicates whether personal information can be removed from the workbook.
Public propertyResearchGets an object that represents the research service for the workbook.
Public propertyRevisionNumberGets 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).
Public propertyRoutedGets a value that indicates whether the workbook has been routed to the next recipient.
Public propertyRoutingSlipGets a Microsoft.Office.Interop.Excel..::.RoutingSlip object that represents the routing slip for the workbook.
Public propertySavedGets or sets a value that indicates whether no changes have been made to the workbook since it was last saved.
Public propertySaveLinkValuesGets or sets a value that indicates whether Microsoft Office Excel saves external link values with the workbook.
Public propertyServerPolicyGets an object that represents a policy specified for a workbook that is stored on a server running Microsoft Office SharePoint Server 2007.
Public propertyServerViewableItemsGets 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 2007 server.
Public propertySharedWorkspaceGets a Microsoft.Office.Core.SharedWorkspace that represents the Document Workspace in which the workbook is located.
Public propertySheetsGets a Microsoft.Office.Interop.Excel..::.Sheets collection that represents all the sheets in the workbook.
Public propertyShowConflictHistoryGets or sets a value that indicates whether the Conflict History worksheet is visible in the workbook that is open as a shared list.
Public propertyShowPivotChartActiveFieldsGets or sets a value that indicates whether the PivotChart Filter Pane is visible.
Public propertyShowPivotTableFieldListGets or sets a value that indicates whether the PivotTable field list can be shown.
Public propertySignaturesGets the collection of digital signatures for the workbook.
Public propertySite (Inherited from RemoteComponent.)
Public propertySmartDocumentGets a Microsoft.Office.Core.SmartDocument that represents the settings for a smart document solution.
Public propertySmartTagOptionsGets a Microsoft.Office.Interop.Excel..::.SmartTagOptions object representing the options that can be performed with a smart tag.
Public propertyStylesGets a Microsoft.Office.Interop.Excel..::.Styles collection that represents all the styles in the workbook.
Public propertySubjectGets or sets the subject for the mailer or routing slip.
Public propertySyncGets a Microsoft.Office.Core.Sync object that provides access to the methods and properties of documents that are part of a Document Workspace.
Public propertyTableStylesGets the collection of table styles that are used in the workbook.
Public propertyTag (Inherited from RemoteComponent.)
Public propertyTemplateRemoveExtDataGets or sets a value that indicates whether external data references are removed when the workbook is saved as a template.
Public propertyThemeGets the theme that is applied to the workbook.
Public propertyTitleGets or sets the title of the Web page when the workbook is saved as a Web page.
Public propertyUpdateLinksGets or sets a value that indicates a workbook's setting for updating embedded OLE links.
Public propertyUpdateRemoteReferencesGets or sets a value that indicates whether Microsoft Office Excel updates remote references in the workbook.
Public propertyUserControlInfrastructure.
Public propertyUserStatusGets a 1-based, two-dimensional array that provides information about each user who has the workbook open as a shared list.
Public propertyVBASignedGets a value that indicates whether the Visual Basic for Applications project for the workbook has been digitally signed.
Public propertyVBProjectGets the virtual Microsoft.Vbe.Interop.VBProject project that is in the workbook.
Public propertyVstoSmartTagsGets the Microsoft.Office.Tools..::.SmartTagCollection associated with the workbook.
Public propertyWebOptionsGets the Microsoft.Office.Interop.Excel..::.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.
Public propertyWindowsGets a Microsoft.Office.Interop.Excel..::.Windows collection that represents all the windows in the workbook.
Public propertyWorksheetsGets a Microsoft.Office.Interop.Excel..::.Sheets collection that represents all the worksheets in the workbook.
Public propertyWritePasswordGets or sets the write password of a workbook.
Public propertyWriteReservedGets a value that indicates whether the workbook is write-reserved.
Public propertyWriteReservedByGets the name of the user who currently has write permission for the workbook.
Public propertyXmlMapsGets an Microsoft.Office.Interop.Excel..::.XmlMaps collection that represents the schema maps that have been added to the workbook.
Public propertyXmlNamespacesGets an Microsoft.Office.Interop.Excel..::.XmlNamespaces collection that represents the XML namespaces contained in the workbook.
Top
Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker