The following tables list the members exposed by IWorkbook.
Public Properties
| Name | Description | |
|---|---|---|
 | ActiveSheet | Returns the active sheet. |
| ActiveWorksheet | Returns the active worksheet of the workbook, or null if the active sheet is not a worksheet. |
| Colors | Returns an instance of IColors which represents the color palette associated with a workbook. |
| Date1904 | Returns 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. |
| DisplayDrawingObjects | Gets or sets the option which specifies how drawing objects are to be displayed. |
| FileFormat | Returns 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. |
| FullName | Gets or sets the full name (including the path) of the workbook. |
| IsModified | Gets or sets the property which specifies whether the workbook has been modified since it was created, opened or saved. |
| Name | Returns the name (excluding the path) of the workbook. |
| Names | Returns the collection of defined names in this workbook. |
| PrecisionAsDisplayed | Gets or sets the property which determines whether numbers will be rounded to the precision of the number format. |
| ProtectStructure | Gets or sets the property which determines whether the structure (number and order of worksheets) of a workbook may be changed. |
| ProtectWindows | Gets or sets the property which determines whether the windows of a workbook are protected from changes. |
| ReadOnlyRecommended | Gets or sets the property which determines whether read-only mode will be recommended to the user when the workbook is opened. |
| SaveLinkValues | Gets 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. |
| Sheets | Returns an instance of ISheets which provides access to all sheets in this workbook. |
| Styles | Returns an instance of IStyles which provides access to the named cell styles associated with this workbook. |
| Theme | Returns an instance of ITheme which provides access to the theme associated with a workbook. |
| UpdateLinks | Gets 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. |
| WindowInfo | Returns an instance of IWorkbookWindowInfo which represents workbook specific window options. |
| WorkbookSet | Returns the parent IWorkbookSet of this workbook. |
| Worksheets | Returns an instance of IWorksheets which provides access to the worksheets in this workbook. |
| WriteReserved | Returns true if the workbook was saved with this option. |
| WriteReservedBy | Returns the name of the user who saved the workbook with the write reserved option. |
Public Methods
| Name | Description | |
|---|---|---|
 | Close | Closes this workbook and releases associated resources. |
| DateTimeToNumber | Converts the specified System.DateTime to a date-time serial number appropriate for storage in a worksheet cell. |
| GetDataSet | Overloaded. Returns a newly created data set consisting of a data table for the used range of each worksheet in the workbook. |
| NumberToDateTime | Converts the specified date-time serial number to an instance of System.DateTime. |
| Protect | Enables protection for this workbook with the specified password and protection options. |
| Save | Saves this workbook using the current FullName. |
| SaveAs | Overloaded. Saves this workbook using the specified filename and FileFormat, and updates the FullName property. |
| SaveToMemory | Overloaded. Saves this workbook to a newly created memory buffer in the specified FileFormat. |
| SaveToStream | Overloaded. Saves this workbook to a stream in the specified FileFormat. |
| Unprotect | Disables protection for the workbook with the specified password. |
See Also