SpreadsheetGear 2012
IWorkbook Interface Members
Properties  Methods 

The following tables list the members exposed by IWorkbook.

Public Properties
 NameDescription
 PropertyActiveSheetReturns the active sheet.  
 PropertyActiveWorksheetReturns the active worksheet of the workbook, or null if the active sheet is not a worksheet.  
 PropertyColorsReturns an instance of IColors which represents the color palette associated with a workbook.  
 PropertyDate1904Returns 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.  
 PropertyDisplayDrawingObjectsGets or sets the option which specifies how drawing objects are to be displayed.  
 PropertyFileFormatReturns 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.  
 PropertyFullNameGets or sets the full name (including the path) of the workbook.  
 PropertyIsModifiedGets or sets the property which specifies whether the workbook has been modified since it was created, opened or saved.  
 PropertyNameReturns the name (excluding the path) of the workbook.  
 PropertyNamesReturns the collection of defined names in this workbook.  
 PropertyPrecisionAsDisplayedGets or sets the property which determines whether numbers will be rounded to the precision of the number format.  
 PropertyProtectStructureGets or sets the property which determines whether the structure (number and order of worksheets) of a workbook may be changed.  
 PropertyProtectWindowsGets or sets the property which determines whether the windows of a workbook are protected from changes.  
 PropertyReadOnlyRecommendedGets or sets the property which determines whether read-only mode will be recommended to the user when the workbook is opened.  
 PropertySaveLinkValuesGets 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.  
 PropertySheetsReturns an instance of ISheets which provides access to all sheets in this workbook.  
 PropertyStylesReturns an instance of IStyles which provides access to the named cell styles associated with this workbook.  
 PropertyThemeReturns an instance of ITheme which provides access to the theme associated with a workbook.  
 PropertyUpdateLinksGets 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.  
 PropertyWindowInfoReturns an instance of IWorkbookWindowInfo which represents workbook specific window options.  
 PropertyWorkbookSetReturns the parent IWorkbookSet of this workbook.  
 PropertyWorksheetsReturns an instance of IWorksheets which provides access to the worksheets in this workbook.  
 PropertyWriteReservedReturns true if the workbook was saved with this option.  
 PropertyWriteReservedByReturns the name of the user who saved the workbook with the write reserved option.  
Top
Public Methods
 NameDescription
 MethodCloseCloses this workbook and releases associated resources.  
 MethodDateTimeToNumberConverts the specified System.DateTime to a date-time serial number appropriate for storage in a worksheet cell.  
 MethodGetDataSetOverloaded. Returns a newly created data set consisting of a data table for the used range of each worksheet in the workbook.  
 MethodNumberToDateTimeConverts the specified date-time serial number to an instance of System.DateTime.  
 MethodProtectEnables protection for this workbook with the specified password and protection options.  
 MethodSaveSaves this workbook using the current FullName.  
 MethodSaveAsOverloaded. Saves this workbook using the specified filename and FileFormat, and updates the FullName property.  
 MethodSaveToMemoryOverloaded. Saves this workbook to a newly created memory buffer in the specified FileFormat.  
 MethodSaveToStreamOverloaded. Saves this workbook to a stream in the specified FileFormat.  
 MethodUnprotectDisables protection for the workbook with the specified password.  
Top
See Also

Reference

IWorkbook Interface
SpreadsheetGear Namespace

Send Feedback