Spread Windows Forms 15.0
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / Workbook Class
Properties Methods


In This Topic
    Workbook Class Members
    In This Topic

    The following tables list the members exposed by Workbook.

    Public Properties
     NameDescription
    Public PropertyGets the active sheet (the sheet on top).  
    Public PropertyGets the active sheet index (the sheet on top).  
    Public PropertyGets the list of authors.  
    Public PropertyGets the BuiltinDocumentProperties object that represents all properties of the spreadsheet document.  
    Public PropertyInternal use only.  
    Public PropertyGets a boolean value indicating whether there are more than one worksheet selected.  
    Public PropertyGets the cell range which is processing copy action.  
    Public PropertyGets or sets whether the date system used to convert a date from/to a serial value starts since 1/1/1904.  
    Public PropertyGets or sets the table style from the ITableStyle collection that is used as the default slicer style.  
    Public PropertyGets or sets the table style from the TableStyles collection that is used as the default table style.  
    Public PropertyGets an ICommentThreaded object that represents the threaded comment which is editing.  
    Public PropertyGets a Features object to manipulate settings of features.  
    Public PropertySpecifies the index to the first sheet in this book view.  
    Public PropertyGets the general FormatOptions value.  
    Public PropertyGets the formula engine of this workbook. (Inherited from GrapeCity.Spreadsheet.WorkbookBase)
    Public PropertyGets the name of this workbook, including its path, as a string.  
    Public PropertyGets or sets the comment which is under mouse cursor.  
    Public PropertyGets or sets a boolean value indicating whether the current clipboard action is Cut.  
    Public PropertyGets an array of links in the workbook. The names in the array are the names of the linked documents. Returns empty array if there are no links.  
    Public PropertyGets the protected data of this workbook.  
    Public PropertyGets or sets the name of this Workbook.  
    Public PropertyGets a WorkbookBase.Names collection that represents all the names in the specified workbook (including all worksheet-specific names). (Inherited from GrapeCity.Spreadsheet.WorkbookBase)
    Public PropertyGets a string that represents the complete path to the workbook/file that this workbook object respresents.  
    Public PropertyGets a ProtectionMode value indicating whether this workbook is protected.  
    Public PropertyGets or sets a boolean value indicating whether externally referenced values will be saved with the workbook, enabling cells which refer to those values to be calculated without returning a #REF! error.  
    Public PropertyGets a IWorksheets collection that represents all the selected sheets in the specified window.  
    Public PropertySpecifies ratio between the workbook tabs bar and the horizontal scroll bar.  
    Public PropertySpecifies a boolean value that indicates whether to display the horizontal scroll bar in the user interface.  
    Public PropertySpecifies a boolean value that indicates whether to display the sheet tabs in the user interface.  
    Public PropertySpecifies a boolean value that indicates whether to display the vertical scroll bar.  
    Public PropertyGets a Styles collection that represents all the styles in the workbook.  
    Public PropertyGets the collection of table styles that are used in the workbook.  
    Public PropertyGets or sets the theme applied to the current workbook.  
    Public PropertyGets or sets an UpdateLinks constant indicating a workbook's setting for updating links.  
    Public PropertyOverridden. Gets the container of this item.  
    Public PropertyGets the worksheet collection.  
    Top
    Public Methods
     NameDescription
    Public MethodConverts formulas linked to other workbook to values.  
    Public MethodOverloaded. Calculates this workbook.  
    Public MethodCloses this workbook.  
    Public MethodConverts all legacy comments and notes to modern comments.  
    Public MethodGets the hash code for this workbook. (Inherited from GrapeCity.Spreadsheet.WorkbookBase)
    Public MethodGets the table using the specified name.  
    Public Methodstatic (Shared in Visual Basic)Gets a boolean value indicating whether the specified name is valid.  
    Public MethodDetermines whether the is valid to use in the workbook/>.  
    Public MethodProtects a workbook so that it cannot be modified.  
    Public MethodResets this workbook by removing all data.  
    Public MethodSaves changes to the specified workbook.  
    Public MethodOverloaded. Saves this Workbook to the specified System.IO.Stream.  
    Public Method  
    Public MethodUnprotects the workbook which is protected by password.  
    Public MethodOverloaded. Updates the specified link of this workbook.  
    Top
    Protected Methods
     NameDescription
    Protected MethodCreates the formula engine.  
    Protected MethodDisposes the specified disposing.  
    Protected MethodEnables an object to extend another object through aggregation.  
    Protected MethodFinalizes an instance of the Workbook class.  
    Protected MethodImports the extension data.  
    Top
    See Also