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 PropertyActiveSheetGets the active sheet (the sheet on top).  
    Public PropertyActiveSheetIndexGets the active sheet index (the sheet on top).  
    Public PropertyAuthorsGets the list of authors.  
    Public PropertyBuiltinDocumentPropertiesGets the BuiltinDocumentProperties object that represents all properties of the spreadsheet document.  
    Public PropertyCompatibleFeaturesInternal use only.  
    Public PropertyContainsMultipleSelectedWorksheetsGets a boolean value indicating whether there are more than one worksheet selected.  
    Public PropertyCopyingRangeGets the cell range which is processing copy action.  
    Public PropertyDate1904Gets or sets whether the date system used to convert a date from/to a serial value starts since 1/1/1904.  
    Public PropertyDefaultSlicerStyleGets or sets the table style from the ITableStyle collection that is used as the default slicer style.  
    Public PropertyDefaultTableStyleGets or sets the table style from the TableStyles collection that is used as the default table style.  
    Public PropertyEditingCommentThreadedGets an ICommentThreaded object that represents the threaded comment which is editing.  
    Public PropertyFeaturesGets a Features object to manipulate settings of features.  
    Public PropertyFirstSheetSpecifies the index to the first sheet in this book view.  
    Public PropertyFormatOptionsGets the general FormatOptions value.  
    Public PropertyFormulaEngineGets the formula engine of this workbook. (Inherited from GrapeCity.Spreadsheet.WorkbookBase)
    Public PropertyFullNameGets the name of this workbook, including its path, as a string.  
    Public PropertyHoverCommentGets or sets the comment which is under mouse cursor.  
    Public PropertyIsClipboardCuttingGets or sets a boolean value indicating whether the current clipboard action is Cut.  
    Public PropertyLinkSourcesGets 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 PropertyLocksGets the protected data of this workbook.  
    Public PropertyNameGets or sets the name of this Workbook.  
    Public PropertyNamesGets a WorkbookBase.Names collection that represents all the names in the specified workbook (including all worksheet-specific names). (Inherited from GrapeCity.Spreadsheet.WorkbookBase)
    Public PropertyPathGets a string that represents the complete path to the workbook/file that this workbook object respresents.  
    Public PropertyProtectionGets a ProtectionMode value indicating whether this workbook is protected.  
    Public PropertySaveLinkValuesGets 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 PropertySelectedSheetsGets a IWorksheets collection that represents all the selected sheets in the specified window.  
    Public PropertySheetTabRatioSpecifies ratio between the workbook tabs bar and the horizontal scroll bar.  
    Public PropertyShowHorizontalScrollSpecifies a boolean value that indicates whether to display the horizontal scroll bar in the user interface.  
    Public PropertyShowSheetTabsSpecifies a boolean value that indicates whether to display the sheet tabs in the user interface.  
    Public PropertyShowVerticalScrollSpecifies a boolean value that indicates whether to display the vertical scroll bar.  
    Public PropertyStylesGets a Styles collection that represents all the styles in the workbook.  
    Public PropertyTableStylesGets the collection of table styles that are used in the workbook.  
    Public PropertyThemeGets or sets the theme applied to the current workbook.  
    Public PropertyUpdateLinksGets or sets an UpdateLinks constant indicating a workbook's setting for updating links.  
    Public PropertyWorkbookSetOverridden. Gets the container of this item.  
    Public PropertyWorksheetsGets the worksheet collection.  
    Top
    Public Methods
     NameDescription
    Public MethodBreakLinkConverts formulas linked to other workbook to values.  
    Public MethodCalculateOverloaded. Calculates this workbook.  
    Public MethodCloseCloses this workbook.  
    Public MethodConvertCommentsConverts all legacy comments and notes to modern comments.  
    Public MethodGetHashCodeGets the hash code for this workbook. (Inherited from GrapeCity.Spreadsheet.WorkbookBase)
    Public MethodGetTableGets the table using the specified name.  
    Public Methodstatic (Shared in Visual Basic)IsValidNameGets a boolean value indicating whether the specified name is valid.  
    Public MethodIsValidSheetNameDetermines whether the is valid to use in the workbook/>.  
    Public MethodProtectProtects a workbook so that it cannot be modified.  
    Public MethodResetResets this workbook by removing all data.  
    Public MethodSaveSaves changes to the specified workbook.  
    Public MethodSaveAsOverloaded. Saves this Workbook to the specified System.IO.Stream.  
    Public MethodUnprotectUnprotects the workbook which is protected by password.  
    Public MethodUpdateLinkOverloaded. Updates the specified link of this workbook.  
    Top
    Protected Methods
     NameDescription
    Protected MethodCreateFormulaEngineCreates the formula engine.  
    Protected MethodDisposeDisposes the specified disposing.  
    Protected MethodExportExtensionDataEnables an object to extend another object through aggregation.  
    Protected MethodFinalizeFinalizes an instance of the Workbook class.  
    Protected MethodImportExtensionDataImports the extension data.  
    Top
    See Also

    Reference

    Workbook Class
    GrapeCity.Spreadsheet Namespace

     

     

    Copyright © 2021 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page