See Also

IWorkbook Interface  | SpreadsheetGear Namespace

See Also SpreadsheetGear The Performance Spreadsheet Component Company 

IWorkbook Interface Members

SpreadsheetGear Namespace : IWorkbook Interface

IWorkbook overview

Public Properties

 Property ActiveSheet Returns the active sheet.
 Property ActiveWorksheet Returns the active worksheet of the workbook, or null if the active sheet is not a worksheet.
 Property Colors Returns an instance of IColors which represents the color palette associated with a workbook.
 Property 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.
 Property DisplayDrawingObjects Gets or sets the option which specifies how drawing objects are to be displayed.
 Property FullName Gets or sets the full name (including the path) of the workbook.
 Property IsModified Gets or sets the property which specifies whether the workbook has been modified since it was created, opened or saved.
 Property Name Returns the name (excluding the path) of the workbook.
 Property Names Returns the collection of defined names in this workbook.
 Property PrecisionAsDisplayed Gets or sets the property which determines whether numbers will be rounded to the precision of the number format.
 Property ProtectStructure Gets or sets the property which determines whether the structure (number and order of worksheets) of a workbook may be changed.
 Property ProtectWindows Gets or sets the property which determines whether the windows of a workbook are protected from changes.
 Property ReadOnlyRecommended Gets or sets the property which determines whether read-only mode will be recommended to the user when the workbook is opened.
 Property 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.
 Property Sheets Returns an instance of ISheets which provides access to all sheets in this workbook.
 Property WindowInfo Returns an instance of IWorkbookWindowInfo which represents workbook specific window options.
 Property WorkbookSet Returns the parent IWorkbookSet of this workbook.
 Property Worksheets Returns an instance of IWorksheets which provides access to the worksheets in this workbook.
 Property WriteReserved Returns true if the workbook was saved with this option.
 Property WriteReservedBy Returns the name of the user who saved the workbook with the write reserved option.

Public Methods

 Method Close Closes this workbook and releases associated resources.
 Method DateTimeToNumber Converts the specified System.DateTime to a date-time serial number appropriate for storage in a worksheet cell.
 Method GetDataSet Overloaded.  
 Method NumberToDateTime Converts the specified date-time serial number to an instance of System.DateTime.
 Method Save Saves this workbook using the current FullName.
 Method SaveAs Saves this workbook using the specified filename and FileFormat, and updates the FullName property.
 Method SaveToMemory Saves this workbook to a newly created memory buffer in the specified FileFormat.
 Method SaveToStream Saves this workbook to a stream in the specified FileFormat.

See Also

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.