| SpreadsheetGear Namespace : IWorkbook Interface |
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. |
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. |
IWorkbook Interface | SpreadsheetGear Namespace
See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.
Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.
SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.