The following tables list the members exposed by IWorkbook.
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. |
![]() | 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. |
![]() | 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. |
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. |
![]() | NumberToDateTime | Converts the specified date-time serial number to an instance of System.DateTime. |
![]() | Save | Saves this workbook using the current FullName. |
![]() | SaveAs | Saves this workbook using the specified filename and FileFormat, and updates the FullName property. |
![]() | SaveToMemory | Saves this workbook to a newly created memory buffer in the specified FileFormat. |
![]() | SaveToStream | Saves this workbook to a stream in the specified FileFormat. |