Export (0) Print
Expand All
Expand Minimize

Workbook Properties

(see also Protected Properties )
  Name Description
Public property _CodeName
Public property _ReadOnlyRecommended
Public property AcceptLabelsInFormulas Gets or sets a value that indicates whether labels can be used in worksheet formulas. 
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 a null reference (Nothing in Visual Basic). 
Public property ActiveSheet Gets the active sheet (the sheet on top). 
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 BindingContext  (Inherited from BindableComponent.)
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 CodeName
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 Container Gets the object that represents the container application for 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 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 DataBindings  (Inherited from BindableComponent.)
Public property Date1904 Gets or sets a value that indicates whether the workbook uses the 1904 date system. 
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 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 EnableAutoRecover Gets or sets a value that indicates whether Microsoft Office Excel saves changed files, of all formats, on a timed interval. 
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 FileFormat Gets the file format and type of the 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
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 HighlightChangesOnScreen Gets or sets a value that indicates whether changes to the shared workbook are highlighted on screen. 
Public property HTMLProject Gets the Microsoft.Office.Core.HTMLProject in the workbook, which represents a top-level project branch. 
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 Workbook
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 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
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 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 SharedWorkspace Gets a 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 ShowPivotTableFieldList Gets or sets a value that indicates whether the PivotTable field list can be shown. 
Public property Site  (Inherited from Component.)
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. 
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 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 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
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. 
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

  Name Description
Protected property CanRaiseEvents  (Inherited from Component.)
Protected property ContainerComponent  (Inherited from BindableComponent.)
Protected property DesignMode  (Inherited from Component.)
Protected property Events  (Inherited from Component.)
Top
Show:
© 2014 Microsoft