Export (0) Print
Expand All
Expand Minimize

Workbook Methods

(see also Protected Methods )
  Name Description
Public method _PrintOut
Public method _Protect
Public method _SaveAs
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 BeginInit
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 Gets 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 Close Closes the workbook.  
Public method CreateObjRef  (Inherited from MarshalByRefObject.)
Public method DeleteNumberFormat Deletes a custom number format from the workbook.  
Public method Dispose Overloaded. Releases the unmanaged resources used by the Workbook and optionally releases the managed resources.  
Public method Dummy16
Public method Dummy17
Public method EndInit
Public method EndReview Terminates a review of a file that has been sent for review using the SendForReview method.  
Public method Equals  Overloaded. (Inherited from Object.)
Public method ExclusiveAccess Assigns the current user exclusive access to the workbook that is open as a shared list.  
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
Public method get_Colors
Public method GetHashCode  (Inherited from Object.)
Public method GetLifetimeService  (Inherited from MarshalByRefObject.)
Public method GetType  (Inherited from Object.)
Public method HighlightChangesOptions Controls how changes are shown in a shared workbook.  
Public method InitializeLifetimeService  (Inherited from MarshalByRefObject.)
Public method LinkInfo Gets the link date and update status.  
Public method LinkSources Returns an Array of links in the workbook.  
Public method MergeWorkbook Merges changes from one workbook into an open shared workbook.  
Public method NewWindow Creates a new window.  
Public method OnShutdown
Public method OnStartup
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 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 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.  
Public method Static ReferenceEquals  (Inherited from Object.)
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 Visual Studio Tools for Office customization from the workbook.  
Public method RemoveUser Disconnects the specified user from the shared workbook.  
Public method Reply
Public method ReplyAll
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
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
Public method set_Colors
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  (Inherited from Component.)
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

  Name Description
Protected method Dispose Overloaded. Overridden. Releases the unmanaged resources used by the Workbook and optionally releases the managed resources.  
Protected method Finalize  (Inherited from Component.)
Protected method GetObjects
Protected method GetPrimaryControl
Protected method GetService  (Inherited from Component.)
Protected method MemberwiseClone  Overloaded. (Inherited from MarshalByRefObject.)
Protected method OnBindingContextChanged  (Inherited from BindableComponent.)
Top
Show:
© 2014 Microsoft