Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / IWorkbook Interface
Properties Methods

In This Topic
    IWorkbook Interface Members
    In This Topic

    The following tables list the members exposed by IWorkbook.

    Public Properties
     NameDescription
     PropertyGets an GrapeCity.Spreadsheet.Charts.IChart object that represents the active chart (either an embedded chart or a chart sheet). An embedded chart is considered active when it's either selected or activated. When no chart is active, this property returns null.  
     PropertyGets the active sheet (the sheet on top).  
     PropertyGets or sets the DocumentProperties object that represents all built-in properties of the workbook.  
     PropertyGets the GrapeCity.Spreadsheet.Charts.ICharts collection that represents all the charts in the specified workbook.  
     PropertyGets or sets colors in the palette for the workbook. The palette has 56 entries, each represented by an ARGB value.  
     PropertyGets or sets the DocumentProperties object that represents all custom properties of the workbook.  
     PropertyGets or sets whether the date system used to convert a date to a serial value starts since 1/1/1904.  
     PropertyGets or sets the table style from the ITableStyle collection that is used as the default slicer style.  
     PropertyGets or sets the table style from the ITableStyle collection that is used as the default table style.  
     PropertyGets a Features object to manipulate settings of features.  
     PropertyGets the name of this workbook, including its path, as a string.  
     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.  
     PropertyGets or sets the name of this Workbook.  
     PropertyGets a Names collection that represents all the names in the specified workbook (including all worksheet-specific names).  
     PropertyGets a string that represents the complete path to the workbook/file that this workbook object respresents.  
     PropertyGets a value indicating whether the order of the sheets in the workbook is protected.  
     PropertyGets a value indicating whether the windows of the workbook are protected.  
     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.  
     PropertyGets a ISheets collection that represents all the selected sheets in the specified window.  
     PropertyGets the ISheets collection that represents all the sheets in the specified workbook.  
     PropertySpecifies a boolean value that indicates whether to display the horizontal scroll bar in the user interface.  
     PropertySpecifies a boolean value that indicates whether to display the sheet tabs in the user interface.  
     PropertySpecifies a boolean value that indicates whether to display the vertical scroll bar in the user interface.  
     PropertyGets the GrapeCity.Spreadsheet.Slicers.ISlicerCaches object associated with the workbook.  
     PropertyGets a Styles collection that represents all the styles in the workbook.  
     PropertyGets the collection of table styles that are used in the workbook.  
     PropertyGets or sets the theme applied to the current workbook.  
     PropertyGets or sets an UpdateLinks constant indicating a workbook's setting for updating links.  
     PropertyGets the WorkbookSet object contains current IWorkbook object.  
     PropertyGets the IWorksheets collection that represents all the worksheet in the specified workbook.  
    Top
    Public Methods
     NameDescription
     MethodOverloaded. Applies the specified theme to the current workbook.  
     MethodConverts formulas linked to other workbook to values.  
     MethodCalculates this workbook.  
     MethodCloses this workbook.  
     MethodConverts all legacy comments and notes to modern comments.  
     MethodProtects a workbook so that it cannot be modified.  
     MethodSaves changes to the specified workbook.  
     MethodOverloaded. Saves this IWorkbook to the specified System.IO.Stream.  
     MethodUnprotects the workbook which is protected by password.  
     MethodOverloaded. Updates the specified link of this workbook.  
    Top
    See Also