SpreadsheetGear
IWorkbook Interface Members
See Also  Properties  Methods  Send Feedback
SpreadsheetGear Namespace : IWorkbook Interface


The following tables list the members exposed by IWorkbook.

Public Properties

 NameDescription
 PropertyActiveSheet Returns the active sheet.  
 PropertyActiveWorksheet Returns the active worksheet of the workbook, or null if the active sheet is not a worksheet.  
 PropertyColors Returns an instance of IColors which represents the color palette associated with a workbook.  
 PropertyDate1904 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.  
 PropertyDisplayDrawingObjects Gets or sets the option which specifies how drawing objects are to be displayed.  
 PropertyFileFormat 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.  
 PropertyFullName Gets or sets the full name (including the path) of the workbook.  
 PropertyIsModified Gets or sets the property which specifies whether the workbook has been modified since it was created, opened or saved.  
 PropertyName Returns the name (excluding the path) of the workbook.  
 PropertyNames Returns the collection of defined names in this workbook.  
 PropertyPrecisionAsDisplayed Gets or sets the property which determines whether numbers will be rounded to the precision of the number format.  
 PropertyProtectStructure Gets or sets the property which determines whether the structure (number and order of worksheets) of a workbook may be changed.  
 PropertyProtectWindows Gets or sets the property which determines whether the windows of a workbook are protected from changes.  
 PropertyReadOnlyRecommended Gets or sets the property which determines whether read-only mode will be recommended to the user when the workbook is opened.  
 PropertySaveLinkValues 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.  
 PropertySheets Returns an instance of ISheets which provides access to all sheets in this workbook.  
 PropertyStyles Returns an instance of IStyles which provides access to the named cell styles associated with this workbook.  
 PropertyTheme Returns an instance of ITheme which provides access to the theme associated with a workbook.  
 PropertyUpdateLinks 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.  
 PropertyWindowInfo Returns an instance of IWorkbookWindowInfo which represents workbook specific window options.  
 PropertyWorkbookSet Returns the parent IWorkbookSet of this workbook.  
 PropertyWorksheets Returns an instance of IWorksheets which provides access to the worksheets in this workbook.  
 PropertyWriteReserved Returns true if the workbook was saved with this option.  
 PropertyWriteReservedBy Returns the name of the user who saved the workbook with the write reserved option.  
Top

Public Methods

 NameDescription
 MethodClose Closes this workbook and releases associated resources.  
 MethodDateTimeToNumber Converts the specified System.DateTime to a date-time serial number appropriate for storage in a worksheet cell.  
 MethodGetDataSetOverloaded.   
 MethodNumberToDateTime Converts the specified date-time serial number to an instance of System.DateTime.  
 MethodSave Saves this workbook using the current FullName.  
 MethodSaveAs Saves this workbook using the specified filename and FileFormat, and updates the FullName property.  
 MethodSaveToMemory Saves this workbook to a newly created memory buffer in the specified FileFormat.  
 MethodSaveToStream Saves this workbook to a stream in the specified FileFormat.  
Top

See Also

Copyright © 2003-2009 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.