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. |