See Also

ISheet Interface  | SpreadsheetGear Namespace

See Also SpreadsheetGear The Performance Spreadsheet Component Company 

ISheet Interface Members

SpreadsheetGear Namespace : ISheet Interface

ISheet overview

Public Properties

 Property Index Returns the zero based index of this sheet.
 Property Name Gets or sets the name of the sheet.
 Property Tab Returns a reference to the sheet tab of this sheet.
 Property Type Returns the SheetType of this sheet.
 Property Visible Gets or sets the property which indicates whether or not a worksheet is visible.
 Property Workbook Returns the workbook which contains the current sheet.
 Property WorkbookSet Returns the parent IWorkbookSet of this sheet.

Public Methods

 Method CopyAfter Creates a new sheet after the specified sheet and copies the contents of this sheet to the newly created sheet.
 Method CopyBefore Creates a new sheet before the specified sheet and copies the contents of this sheet to the newly created sheet.
 Method Delete Deletes this sheet.
 Method EvaluateRange Evaluates the specified formula and returns the resulting IRange.
 Method EvaluateRanges Evaluates the specified formula and returns the resulting array of ranges.
 Method EvaluateValue Evaluates the specified formula and returns the result as a System.Double, System.String, System.Boolean or ValueError.
 Method EvaluateValues Evaluates the specified formula and returns the result as an array of objects, where each object is a System.Double, System.String, System.Boolean or ValueError.
 Method MoveAfter Moves this sheet to come after the specified sheet.
 Method MoveBefore Moves this sheet to come before the specified sheet.
 Method Select Selects the sheet.

See Also

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