Workbook Methods

  • Article

Include Protected Members
Include Inherited Members

The Workbook type exposes the following members.

Methods

  Name Description
Public method _PrintOut Infrastructure.
Public method _Protect Infrastructure.
Public method _SaveAs Infrastructure.
Public method _VtblGap1_1
Public method _VtblGap2_1
Public method _VtblGap3_1
Public method _VtblGap4_1
Public method _VtblGap5_1
Public method _VtblGap6_1
Public method _VtblGap7_2
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 Signals the object that initialization is starting. (Inherited from ISupportInitialize.)
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.
Public method DeleteNumberFormat Deletes a custom number format from the workbook.
Public method Dispose Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. (Inherited from IDisposable.)
Public method Dummy16 Infrastructure.
Public method Dummy17 Infrastructure.
Public method Dummy26 Infrastructure.
Public method Dummy27 Infrastructure.
Public method EnableConnections Enables data connections within the workbook.
Public method EndInit Signals the object that initialization is complete. (Inherited from ISupportInitialize.)
Public method EndReview Terminates a review of a file that has been sent for review using the SendForReview method.
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.
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. Use the Colors property instead of this method.
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.
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.
Public method MergeWorkbook Merges changes from one workbook into an open shared workbook.
Public method NewWindow Creates a new window.
Public method OpenLinks Opens the supporting documents for a link or links.
Public method PivotCaches Gets a PivotCaches collection that represents all the PivotTable caches in the specified workbook.
Public method PivotTableWizard Creates a 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.
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.
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 Unprotect Removes protection from the workbook. This method has no effect if the workbook is not protected.
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

See Also

Reference

Workbook Interface

Microsoft.Office.Tools.Excel Namespace