SpreadsheetGear 2017
IWorkbook Interface Properties

SpreadsheetGear Namespace : IWorkbook Interface

For a list of all members of this type, see IWorkbook members.

Public Properties
 NameDescription
 PropertyReturns the active sheet.  
 PropertyReturns the active worksheet of the workbook, or null if the active sheet is not a worksheet.  
 PropertyReturns an instance of IColors which represents the color palette associated with a workbook.  
 PropertyReturns true if dates are represented as the number of days since 1/1/1904, false if dates are represented as the number of days since 12/31/1899.  
 PropertyGets or sets the option which specifies how drawing objects are to be displayed.  
 PropertyReturns the file format which the workbook was last opened from or saved to. If the workbook has never been saved, the default file format is returned.  
 PropertyGets or sets the full name (including the path) of the workbook.  
 PropertyReturns the collection of built-in icon sets in this workbook.  
 PropertyGets or sets the property which specifies whether the workbook has been modified since it was created, opened or saved.  
 PropertyReturns the name (excluding the path) of the workbook.  
 PropertyReturns the collection of defined names in this workbook.  
 PropertyGets or sets the property which determines whether numbers will be rounded to the precision of the number format.  
 PropertyGets or sets the property which determines whether the structure (number and order of worksheets) of a workbook may be changed.  
 PropertyGets or sets the property which determines whether the windows of a workbook are protected from changes.  
 PropertyGets or sets the property which determines whether read-only mode will be recommended to the user when the workbook is opened.  
 PropertyGets or sets the property which determines 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.  
 PropertyReturns an instance of ISheets which provides access to all sheets in this workbook.  
 PropertyReturns an instance of IStyles which provides access to the named cell styles associated with this workbook.  
 PropertyReturns an instance of ITheme which provides access to the theme associated with a workbook.  
 PropertyGets or sets the property which determines whether externally referenced values will be updated when a workbook is loaded by Excel. SpreadsheetGear supports reading, writing and modifying this value, but does not support automatically updating links unless the workbook is loaded into the same workbook set.  
 PropertyReturns an instance of IWorkbookWindowInfo which represents workbook specific window options for the currently active view.  
 PropertyReturns a reference to the IWorkbookWindowInfo collection for the workbook.  
 PropertyReturns the parent IWorkbookSet of this workbook.  
 PropertyReturns an instance of IWorksheets which provides access to the worksheets in this workbook.  
 PropertyReturns true if the workbook was saved with this option.  
 PropertyReturns the name of the user who saved the workbook with the write reserved option.  
Top
See Also

Reference

IWorkbook Interface
SpreadsheetGear Namespace