Partilhar via


WorkbookBase Class

Provides the base class for the ThisWorkbook class in document-level projects for Microsoft Office Excel.

Inheritance Hierarchy

System.Object
  Microsoft.Office.Tools.Excel.WorkbookBase

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

Syntax

'Declaration
Public MustInherit Class WorkbookBase _
    Implements IWorkbookExtension, IExtension, EntryPoint, ISupportInitialize,  _
    IBindableComponent, IComponent, IDisposable, ICachedDataPersistanceCallback
public abstract class WorkbookBase : IWorkbookExtension, 
    IExtension, EntryPoint, ISupportInitialize, IBindableComponent, IComponent, 
    IDisposable, ICachedDataPersistanceCallback

The WorkbookBase type exposes the following members.

Constructors

  Name Description
Protected method WorkbookBase Infrastructure.

Top

Properties

  Name Description
Public property _CodeName Infrastructure.
Public property _ReadOnlyRecommended Infrastructure.
Public property AcceptLabelsInFormulas Gets or sets a value that indicates whether labels can be used in worksheet formulas.
Public property AccuracyVersion Specifies whether certain worksheet functions use the latest accuracy algorithms to calculate their results.
Public property ActiveChart Gets 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 nulla null reference (Nothing in Visual Basic).
Public property ActiveSheet Gets the active sheet (the sheet on top).
Public property ActiveSlicer Gets an object that represents the active slicer in the active workbook or in the specified workbook.
Public property Application Gets an Microsoft.Office.Interop.Excel.Application that represents the creator of the workbook.
Public property Author Gets or sets the author of the workbook.
Public property AutoUpdateFrequency Gets or sets the number of minutes between automatic updates to the shared workbook.
Public property 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.
Public property Base Gets the Workbook object that this WorkbookBase object extends.
Public property BindingContext Infrastructure.
Public property BuiltinDocumentProperties Gets a Microsoft.Office.Core.DocumentProperties collection that represents all the built-in document properties for the workbook.
Public property 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.
Public property ChangeHistoryDuration Gets or sets the number of days shown in the shared workbook's change history.
Public property Charts Gets a Microsoft.Office.Interop.Excel.Sheets collection that represents all the chart sheets in the workbook.
Public property CheckCompatibility Gets or sets a value that indicates whether to run the compatibility checker automatically when the workbook is saved.
Public property CodeName Infrastructure.
Public property Colors Gets or sets colors in the palette for the workbook.
Public property CommandBars Gets a Microsoft.Office.Core.CommandBars object that represents the Microsoft Office Excel command bars.
Public property Comments Gets or sets the comments attached to the workbook.
Public property ConflictResolution Gets or sets the way conflicts are to be resolved whenever a shared workbook is updated.
Public property Connections Gets the collection of connections between the workbook and a data source.
Public property ConnectionsDisabled Gets a value that indicates whether to disable the external connections or links in the workbook.
Public property Container Gets the object that represents the container application for the workbook.
Public property ContentTypeProperties Gets a collection of properties that describe metadata that is stored in the workbook.
Public property CreateBackup Gets a value that indicates whether a backup file is created when this file is saved.
Public property Creator Gets the application in which the workbook was created.
Public property CustomDocumentProperties Gets a Microsoft.Office.Core.DocumentProperties collection that represents all the custom document properties for the workbook.
Public property CustomViews Gets a Microsoft.Office.Interop.Excel.CustomViews collection that represents all the custom views for the workbook.
Public property CustomXMLParts Gets the collection of custom XML parts in the workbook.
Public property DataBindings Infrastructure.
Public property DataHost Infrastructure.
Public property Date1904 Gets or sets a value that indicates whether the workbook uses the 1904 date system.
Public property DefaultPivotTableStyle Gets or sets the table style from the TableStyles property that is used as the default style for PivotTable reports in the workbook.
Public property DefaultSlicerStyle
Public property DefaultTableStyle Gets or sets the table style from the TableStyles property that is used as the default style for tables in the workbook.
Public property DialogSheets Included for backwards compatibility only.
Public property DisplayDrawingObjects Gets or sets how shapes are displayed.
Public property DisplayInkComments Gets or sets a value that indicates whether ink comments are displayed in the workbook.
Public property DocumentInspectors Gets the collection of Document Inspector modules for the workbook.
Public property 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.
Public property 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.
Public property EnableAutoRecover Gets or sets a value that indicates whether Microsoft Office Excel saves changed files, of all formats, on a timed interval.
Public property EncryptionProvider Gets the name of the algorithm encryption provider that Microsoft Office Excel uses when encrypting passwords for the workbook.
Public property EnvelopeVisible Gets or sets a value that indicates whether the e-mail composition header and the envelope toolbar are both visible.
Public property Excel4IntlMacroSheets Gets a Microsoft.Office.Interop.Excel.Sheets collection that represents all the Microsoft Office Excel 4.0 international macro sheets in the workbook.
Public property Excel4MacroSheets Gets a Microsoft.Office.Interop.Excel.Sheets collection that represents all the Microsoft Office Excel 4.0 macro sheets in the workbook.
Public property Excel8CompatibilityMode Gets a value that indicates whether the workbook is in compatibility mode.
Public property FileFormat Gets the file format and type of the workbook.
Public property Final Gets or sets a value that indicates whether the workbook is final.
Public property ForceFullCalculation Gets or sets a value that indicates whether to force a full calculation of a workbook.
Public property FullName Gets the name of the object, including its path on disk.
Public property FullNameURLEncoded Gets the name of the object, including its path on disk.
Public property HasMailer Infrastructure.
Public property HasPassword Gets a value that indicates whether the workbook has a protection password.
Public property HasRoutingSlip Gets or sets a value that indicates whether the workbook has a routing slip.
Public property HasVBProject Gets a value that indicates whether a workbook has an attached Microsoft Visual Basic for Applications (VBA) project.
Public property HighlightChangesOnScreen Gets or sets a value that indicates whether changes to the shared workbook are highlighted on screen.
Public property HostContext Infrastructure.
Public property HTMLProject Gets the Microsoft.Office.Core.HTMLProject in the workbook, which represents a top-level project branch.
Public property 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.
Public property InactiveListBorderVisible Gets or sets a value that indicates whether list borders are visible when a list is not active.
Public property InnerObject Gets a Microsoft.Office.Interop.Excel.Workbook that represents the underlying native object for the WorkbookBase.
Public property IsAddin Gets or sets a value that indicates whether the workbook is running as an add-in.
Public property IsInplace Gets a value that indicates whether the specified workbook is being edited in place
Public property ItemProvider Infrastructure.
Public property KeepChangeHistory Gets or sets a value that indicates whether change tracking is enabled for the shared workbook.
Public property Keywords Gets or sets the keywords attached to the workbook.
Public property ListChangesOnNewSheet Gets or sets a value that indicates whether changes to the shared workbook are shown on a separate worksheet.
Public property Mailer Infrastructure.
Public property Modules Included for backwards compatibility only.
Public property MultiUserEditing Gets a value that indicates whether the workbook is open as a shared list.
Public property Name Gets the name of the workbook.
Public property Names Gets a Microsoft.Office.Interop.Excel.Names collection that represents all the names in the workbook (including all worksheet-specific names).
Public property OnSave Included for backwards compatibility only.
Public property OnSheetActivate Included for backwards compatibility only.
Public property OnSheetDeactivate Included for backwards compatibility only.
Public property Parent Gets the parent object for the workbook.
Public property Password Gets or sets the password that must be supplied to open the workbook.
Public property PasswordEncryptionAlgorithm Gets the algorithm that Microsoft Office Excel uses to encrypt passwords for the workbook.
Public property PasswordEncryptionFileProperties Gets a value that indicates whether Microsoft Office Excel encrypts file properties for the specified password-protected workbook.
Public property PasswordEncryptionKeyLength Gets the key length of the algorithm that Microsoft Office Excel uses when encrypting passwords for the workbook.
Public property PasswordEncryptionProvider Gets the name of the algorithm encryption provider that Microsoft Office Excel uses when encrypting passwords for the workbook.
Public property Path Gets the complete path to the application, excluding the final separator and name of the application.
Public property Permission Gets a Microsoft.Office.Core.Permission object that represents the permission settings in the workbook.
Public property 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.
Public property PersonalViewPrintSettings Gets or sets a value that indicates whether print settings are included in the user's personal view of the shared workbook.
Public property 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.
Public property ProtectStructure Gets a value that indicates whether the order of the sheets in the workbook is protected.
Public property ProtectWindows Gets a value that indicates whether the windows of the workbook are protected.
Public property PublishObjects Gets the Microsoft.Office.Interop.Excel.PublishObjects collection.
Public property ReadOnly Gets a value that indicates whether the workbook has been opened as read-only.
Public property ReadOnlyRecommended Gets or sets a value that indicates whether the workbook was saved as read-only recommended.
Public property RemovePersonalInformation Gets or sets a value that indicates whether personal information can be removed from the workbook.
Public property Research Gets an object that represents the research service for the workbook.
Public property 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).
Public property Routed Gets a value that indicates whether the workbook has been routed to the next recipient.
Public property RoutingSlip Gets a Microsoft.Office.Interop.Excel.RoutingSlip object that represents the routing slip for the workbook.
Public property Saved Gets or sets a value that indicates whether no changes have been made to the workbook since it was last saved.
Public property SaveLinkValues Gets or sets a value that indicates whether Microsoft Office Excel saves external link values with the workbook.
Public property ServerPolicy Gets an object that represents a policy specified for a workbook that is stored on a server running Microsoft Office SharePoint Server.
Public property 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.
Public property SharedWorkspace Gets a Microsoft.Office.Core.SharedWorkspace that represents the Document Workspace in which the workbook is located.
Public property Sheets Gets a Microsoft.Office.Interop.Excel.Sheets collection that represents all the sheets in the workbook.
Public property 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.
Public property ShowPivotChartActiveFields Gets or sets a value that indicates whether the PivotChart Filter Pane is visible.
Public property ShowPivotTableFieldList Gets or sets a value that indicates whether the PivotTable field list can be shown.
Public property Signatures Gets the collection of digital signatures for the workbook.
Public property Site Infrastructure.
Public property SlicerCaches Gets the SlicerCaches object associated with the workbook.
Public property SmartDocument Gets a Microsoft.Office.Core.SmartDocument that represents the settings for a smart document solution.
Public property SmartTagOptions Gets a Microsoft.Office.Interop.Excel.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.
.
Public property Styles Gets a Microsoft.Office.Interop.Excel.Styles collection that represents all the styles in the workbook.
Public property Subject Gets or sets the subject for the mailer or routing slip.
Public property 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.
Public property TableStyles Gets the collection of table styles that are used in the workbook.
Public property Tag Gets or sets the object that contains data about the workbook.
Public property TemplateRemoveExtData Gets or sets a value that indicates whether external data references are removed when the workbook is saved as a template.
Public property Theme Gets the theme that is applied to the workbook.
Public property Title Gets or sets the title of the Web page when the workbook is saved as a Web page.
Public property UpdateLinks Gets or sets a value that indicates a workbook's setting for updating embedded OLE links.
Public property UpdateRemoteReferences Gets or sets a value that indicates whether Microsoft Office Excel updates remote references in the workbook.
Public property UserControl Gets or sets a value that indicates whether the workbook or application was created or opened by the user.
Public property UserStatus Gets a 1-based, two-dimensional array that provides information about each user who has the workbook open as a shared list.
Public property VBASigned Gets a value that indicates whether the Visual Basic for Applications project for the workbook has been digitally signed.
Public property VBProject Gets the virtual Microsoft.Vbe.Interop.VBProject project that is in the workbook.
Public property 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.
.
Public property WebOptions Gets 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 property Windows Gets a Microsoft.Office.Interop.Excel.Windows collection that represents all the windows in the workbook.
Public property Worksheets Gets a Microsoft.Office.Interop.Excel.Sheets collection that represents all the worksheets in the workbook.
Public property WritePassword Gets or sets the write password of a workbook.
Public property WriteReserved Gets a value that indicates whether the workbook is write-reserved.
Public property WriteReservedBy Gets the name of the user who currently has write permission for the workbook.
Public property XmlMaps Gets an Microsoft.Office.Interop.Excel.XmlMaps collection that represents the schema maps that have been added to the workbook.
Public property XmlNamespaces Gets an Microsoft.Office.Interop.Excel.XmlNamespaces collection that represents the XML namespaces contained in the workbook.

Top

Methods

  Name Description
Public method AcceptAllChanges Accepts all changes in the shared workbook.
Public method Activate Activates the first window associated with the workbook.
Public method AddToFavorites Adds a shortcut to the workbook to the Favorites folder.
Public method ApplyTheme Applies the specified theme to the workbook.
Public method BeginInit Infrastructure.
Public method BreakLink Converts formulas linked to other Microsoft Office Excel sources or OLE sources to values.
Public method CanCheckIn Gets a value that indicates whether Microsoft Office Excel can check in the workbook to a server.
Public method ChangeFileAccess Changes the access permissions for the workbook. This might require an updated version to be loaded from the disk.
Public method ChangeLink Changes a link from one document to another.
Public method CheckIn Returns a workbook from a local computer to a server, and sets the local workbook to read-only so that it cannot be edited locally. Calling this method closes the workbook.
Public method CheckInWithVersion Sends the workbook from the local computer to a server, and sets the local workbook to read-only so that it cannot be edited locally. Calling this method closes the workbook.
Public method Close Closes the workbook.
Protected method CreateRibbonExtensibilityObject Returns an object that implements the Microsoft.Office.Core.IRibbonExtensibility interface.
Protected method CreateRibbonObjects Returns an array of OfficeRibbon objects to the CreateRibbonExtensibilityObject method.
Public method DeleteNumberFormat Deletes a custom number format from the workbook.
Public method Dispose Releases all resources used by the current instance of the WorkbookBase class.
Public method EnableConnections Enables data connections within the workbook.
Public method EndInit Infrastructure.
Public method EndReview Terminates a review of a file that has been sent for review using the SendForReview method.
Public method Equals Determines whether the specified object is equal to the current object. (Inherited from Object.)
Public method ExclusiveAccess Assigns the current user exclusive access to the workbook that is open as a shared list.
Public method ExportAsFixedFormat Saves a workbook in PDF or XPS format.
Protected method Finalize Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
Protected method FinishInitialization
Public method FollowHyperlink Displays a cached document, if it has already been downloaded. Otherwise, this method resolves the hyperlink, downloads the target document, and displays the document in the appropriate application.
Public method ForwardMailer Infrastructure.
Public method get_Colors Infrastructure.
Protected method GetAutomationObject Called by the Visual Studio Tools for Office runtime to get an object that can be used by VBA code in the workbook.
Public method GetHashCode Serves as the default hash function. (Inherited from Object.)
Protected method GetHostItem<T>
Public method GetType Gets the Type of the current instance. (Inherited from Object.)
Public method GetWorkflowTasks Returns the collection of workflow tasks for the workbook.
Public method GetWorkflowTemplates Returns the collection of workflow templates for the workbook.
Public method HighlightChangesOptions Controls how changes are shown in a shared workbook.
Protected method Initialize Infrastructure.
Protected method InitializeDataBindings Infrastructure.
Public method LinkInfo Gets the link date and update status.
Public method LinkSources Returns an Array of links in the workbook.
Public method LockServerFile Locks the workbook on the server to prevent modification.
Protected method MemberwiseClone Creates a shallow copy of the current Object. (Inherited from Object.)
Public method MergeWorkbook Merges changes from one workbook into an open shared workbook.
Public method NewWindow Creates a new window.
Protected method OnShutdown Infrastructure.
Protected method OnStartup Infrastructure.
Public method OpenLinks Opens the supporting documents for a link or links.
Public method PivotCaches Gets a Microsoft.Office.Interop.Excel.PivotCaches collection that represents all the PivotTable caches in the specified workbook.
Public method PivotTableWizard Creates a Microsoft.Office.Interop.Excel.PivotTable object.
Public method Post Posts the workbook to a public folder. This method works only with a Microsoft Exchange client connected to a Microsoft Exchange server.
Public method PrintOut Prints the workbook.
Public method PrintOutEx Prints the workbook.
Public method PrintPreview Shows a preview of the object as it would look when printed.
Public method Protect Protects a workbook so that it cannot be modified.
Protected method ProtectDocument Called by the Visual Studio Tools for Office runtime so that you can reapply password protection to the workbook after the cached data has been saved.
Public method ProtectSharing Saves the workbook and protects it for sharing.
Public method ProtectSharingEx Saves the workbook and protects it for sharing.
Public method PurgeChangeHistoryNow Removes entries from the change log for the workbook.
Public method RecheckSmartTags Causes a foreground smart tag check to occur automatically annotating data that was not annotated before. 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.
.
Public method RefreshAll Refreshes all external data ranges and PivotTable reports in the workbook.
Public method RejectAllChanges Rejects all changes in the shared workbook.
Public method ReloadAs Reloads a workbook based on an HTML document, using the specified document encoding.
Public method RemoveCustomization Removes the customization that was created by using Office development tools in Visual Studio from the workbook.
Public method RemoveDocumentInformation Removes all information of the specified type from the workbook.
Public method RemoveUser Disconnects the specified user from the shared workbook.
Public method Reply Infrastructure.
Public method ReplyAll Infrastructure.
Public method ReplyWithChanges Sends an e-mail message to the author of a workbook that has been sent out for review, notifying him or her that a reviewer has completed review of the workbook.
Protected method RequestService Returns an object that implements the Microsoft.Office.Core.IRibbonExtensibility interface in a document-level customization.
Public method ResetColors Resets the color palette to the default colors.
Public method Route Routes the workbook, using the workbook's current routing slip.
Public method RunAutoMacros Runs the Auto_Open, Auto_Close, Auto_Activate, or Auto_Deactivate macro attached to the workbook. This method is included for backward compatibility. You should use the Open, Close, Activate and Deactivate events instead of these macros.
Public method Save Saves changes to the workbook.
Public method SaveAs Saves changes to the workbook in a different file.
Public method SaveAsXMLData Exports the data that has been mapped to the specified XML schema map to an XML data file.
Public method SaveCopyAs Saves a copy of the workbook to a file but does not modify the open workbook in memory.
Public method sblt Infrastructure.
Public method SendFaxOverInternet Sends the active sheet in the workbook as a fax to the specified recipients.
Public method SendForReview Sends a workbook in an e-mail message for review to the specified recipients.
Public method SendMail Sends the workbook by using the installed mail system.
Public method SendMailer Infrastructure.
Public method set_Colors Infrastructure. Use the Colors property instead of this method.
Public method SetLinkOnData Sets the name of a procedure that runs whenever a DDE link is updated.
Public method SetPasswordEncryptionOptions Sets the options for encrypting the workbook using a password.
Public method ToggleFormsDesign Toggles Microsoft Office Excel into and out of design mode.
Public method ToString Returns a string that represents the current object. (Inherited from Object.)
Public method Unprotect Removes protection from the workbook. This method has no effect if the workbook is not protected.
Protected method UnprotectDocument Called by the Visual Studio Tools for Office runtime so that you can remove password protection from the workbook and enable cached data to be saved.
Public method UnprotectSharing Turns off protection for sharing and saves the workbook.
Public method UpdateFromFile Updates a read-only workbook from the saved disk version of the workbook if the disk version is more recent than the copy of the workbook that is loaded in memory. If the disk copy has not changed since the workbook was loaded, the in-memory copy of the workbook is not reloaded.
Public method UpdateLink Updates a Microsoft Office Excel, DDE, or OLE link (or links).
Public method WebPagePreview Displays a preview of the workbook as it would look if saved as a Web page.
Public method XmlImport Imports an XML data file into the current workbook.
Public method XmlImportXml Imports an XML data stream that has been previously loaded into memory.

Top

Events

  Name Description
Public event ActivateEvent Occurs when the workbook is activated.
Public event AddinInstall Occurs when the workbook is installed as an add-in.
Public event AddinUninstall Occurs when the workbook is uninstalled as an add-in.
Public event AfterSave Occurs after the workbook is saved.
Public event AfterXmlExport Occurs after Microsoft Office Excel saves or exports data from the workbook to an XML data file.
Public event AfterXmlImport Occurs after an existing XML data connection is refreshed or after new XML data is imported into the workbook.
Public event BeforeClose Occurs before the workbook closes. If the workbook has been changed, this event occurs before the user is asked to save changes.
Public event BeforePrint Occurs before the workbook (or anything in it) is printed.
Public event BeforeSave Occurs before the workbook is saved.
Public event BeforeXmlExport Occurs before Microsoft Office Excel saves or exports data from the workbook to an XML data file.
Public event BeforeXmlImport Occurs before an existing XML data connection is refreshed or before new XML data is imported into the workbook.
Public event BindingContextChanged Infrastructure.
Public event Deactivate Occurs when the workbook is deactivated.
Public event Disposed Infrastructure.
Public event New Occurs when a new workbook is created.
Public event NewChart Occurs when a new chart is created in the workbook.
Public event NewSheet Occurs when a new sheet is created in the workbook.
Public event Open Occurs when the workbook is opened.
Public event PivotTableCloseConnection Occurs after a PivotTable report closes the connection to its data source.
Public event PivotTableOpenConnection Occurs after a PivotTable report opens the connection to its data source.
Public event RowsetComplete Occurs when the user navigates through the recordset or invokes the rowset action on an OLAP PivotTable.
Public event SheetActivate Included for backwards compatibility only.
Public event SheetBeforeDoubleClick Occurs when any worksheet is double-clicked, before the default double-click action.
Public event SheetBeforeRightClick Occurs when any worksheet is right-clicked, before the default right-click action.
Public event SheetCalculate Occurs after any worksheet is recalculated or after any changed data is plotted on a chart.
Public event SheetChange Occurs when cells in any worksheet are changed by the user or by an external link.
Public event SheetDeactivate Included for backwards compatibility only.
Public event SheetFollowHyperlink Occurs when you click any hyperlink in a workbook.
Public event SheetPivotTableAfterValueChange Occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas).
Public event SheetPivotTableBeforeAllocateChanges Occurs before changes are applied to a PivotTable.
Public event SheetPivotTableBeforeCommitChanges Occurs before changes are committed against the OLAP data source for a PivotTable.
Public event SheetPivotTableBeforeDiscardChanges Occurs before changes to a PivotTable are discarded.
Public event SheetPivotTableChangeSync Occurs after changes to a PivotTable.
Public event SheetPivotTableUpdate Occurs after the sheet of a PivotTable report has been updated.
Public event SheetSelectionChange Occurs when the selection changes on any worksheet. Does not occur if the selection is on a chart sheet.
Public event Shutdown Occurs when the workbook host item shuts down.
Public event Startup Infrastructure.
Public event SyncEvent Occurs when the local copy of a worksheet that is part of a Document Workspace is synchronized with the copy on the server.
Public event WindowActivate Occurs when any workbook window is activated.
Public event WindowDeactivate Occurs when any workbook window is deactivated.
Public event WindowResize Occurs when any workbook window is resized.

Top

Explicit Interface Implementations

  Name Description
Explicit interface implemetationPrivate method EntryPoint.BeginInit Infrastructure.
Explicit interface implemetationPrivate method EntryPoint.EndInit Infrastructure.
Explicit interface implemetationPrivate method EntryPoint.FinishInitialization Infrastructure.
Explicit interface implemetationPrivate method EntryPoint.Initialize Infrastructure.
Explicit interface implemetationPrivate method EntryPoint.InitializeDataBindings Infrastructure.
Explicit interface implemetationPrivate method EntryPoint.OnShutdown Infrastructure.
Explicit interface implemetationPrivate method EntryPoint.OnStartup Infrastructure.
Explicit interface implemetationPrivate method ICachedDataPersistanceCallback.OnAfterSave
Explicit interface implemetationPrivate method ICachedDataPersistanceCallback.OnBeforeSave
Explicit interface implemetationPrivate property IExtension.ExtensionBase Infrastructure.
Explicit interface implemetationPrivate method IWorkbookExtension.CreateRibbonExtensibilityObject Infrastructure.
Explicit interface implemetationPrivate method IWorkbookExtension.CreateRibbonObjects Infrastructure.
Explicit interface implemetationPrivate method IWorkbookExtension.GetAutomationObject Infrastructure.
Explicit interface implemetationPrivate method IWorkbookExtension.ProtectDocument Infrastructure.
Explicit interface implemetationPrivate method IWorkbookExtension.RequestService Infrastructure.
Explicit interface implemetationPrivate method IWorkbookExtension.UnprotectDocument Infrastructure.

Top

Remarks

The WorkbookBase class is the base class for the ThisWorkbook class in document-level Excel projects created by using Visual Studio. Use the ThisWorkbook class to programmatically access the workbook in your project. For more information, see Programming Document-Level Customizations.

The WorkbookBase class provides the same members as the Microsoft.Office.Interop.Excel.Workbook object in the Excel primary interop assembly, but it adds the following features:

  • VstoSmartTags property. Use this property to add smart tags to a workbook.

  • InnerObject property. Use this property to get the underlying Microsoft.Office.Interop.Excel.Workbook object for a workbook host item.

  • RemoveCustomization method. Use this method to remove the Office customization assembly from the workbook in a document-level customization.

  • CreateRibbonObjects method. Override this method if you added multiple custom Ribbons to your project by using the Ribbon (Visual Designer) item template, and you want to specify which Ribbons to display at run time.

  • GetAutomationObject method. Override this method to expose a class in your project to VBA code in the workbook.

Creating Workbook Host Items

You cannot create WorkbookBase objects programmatically in Office projects.

In document-level projects, the ThisWorkbook class (which derives from WorkbookBase) is instantiated automatically by the Visual Studio Tools for Office runtime when the end user opens the workbook. For more information, see Programming Document-Level Customizations.

In application-level projects, you can create workbook host items programmatically by using the GetVstoObject method. For more information, see Extending Word Documents and Excel Workbooks in Application-Level Add-ins at Run Time.

Usage

This type is used only in Office projects that target the .NET Framework 4 and the .NET Framework 4.5. The assembly that defines this type is not part of the Visual Studio Tools for Office runtime. You must deploy this assembly with your solution. For more information, see Assemblies in the Visual Studio Tools for Office Runtime.

Examples

Host Items and Host Controls Overview

Workbook Host Item

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

Microsoft.Office.Tools.Excel Namespace