Document Solutions for Excel, .NET Edition | Document Solutions
GrapeCity.Documents.Excel Namespace / IWorksheet Interface
Properties Methods Events

In This Topic
    IWorksheet Interface Members
    In This Topic

    The following tables list the members exposed by IWorksheet.

    Public Properties
     NameDescription
     Property Gets the active cell.  
     PropertyReturns the IPane object that represents the active pane of the worksheet.  
     PropertyReturns an IAutoFilter object if filtering is on. Returns nothing if filtering is off (read-only).  
     PropertyGets or sets whether the AutoFilter drop-down arrows are currently displayed on the sheet. This property is independent of the AutoFilterMode property (read or write).  
     Property Gets or sets whether to generate columns automatically while binding data.  
     Property Gets or sets the background graphic for a worksheet.  
     PropertyReturns a GrapeCity.Documents.Excel.Drawing.IBackgroundPictures object that represents all the backgound pictures on the worksheet or chart sheet (read-only).  
     PropertyReturns the IRange object that represents all the cells on the worksheet (not just the cells that are currently in use). This object is read-only.  
     Property Gets or sets the cell type for current sheet.  
     Property Gets or sets the column count of the worksheet when exported to JSON.  
     PropertyReturns the IRange object that represents all the columns on the specified worksheet (read-only).  
     PropertyReturns the IComments collection that represents all the comments for the specified worksheet (read-only).  
     PropertyReturns the ICommentsThreaded collection that represents all the threaded comments for the specified worksheet (read-only).  
     Property Gets the control collection of this worksheet.  
     Property Gets or sets the data source of data binding for current sheet.  
     Property Gets whether the worksheet is in filter mode (read-only).  
     Property Gets or sets whether the horizontal and vertical page breaks are fixed when inserting/deleting rows/columns.  
     Property Gets the frozen column.  
     Property Gets the frozen row.  
     Property Gets the number of trailing frozen columns of the sheet.  
     Property Gets the number of trailing frozen rows of the sheet.  
     Property Gets or sets the color of frozen line.  
     Property Get the collection of horizontal page breaks within the print area.  
     Property Provides access to the collection of Hyperlinks contained in the worksheet.  
     Property Gets or sets the index number of the object within the collection of similar objects.  
     Property Gets or sets the name of the object (read or write).  
     PropertyReturns the INames collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix). This is a read-only Names object.  
     PropertyReturns an IOutline object that represents the outline for the specified worksheet (read-only).  
     Property Gets the outline column for the worksheet.  
     Property Returns a PageSetup object that contains all the page setup settings for the specified object.  
     Property Worksheet panes.  
     PropertyReturns an object that represents either a single PivotTable report (a IPivotTables object) or a collection of all the PivotTable reports (IPivotTables object) on a worksheet (read-only).  
     Property Gets or sets the protection status of the worksheet.  
     PropertyReturns the IProtectionSettings object that represents the protection options of the worksheet.  
     PropertyReturns an instance of IRange which provides access to cell values, formulas, formatting and other cell properties and methods.  
     Property Gets or sets the row count of the worksheet when exported to JSON.  
     PropertyReturns the IRange object that represents all the rows on the specified worksheet. This is read-only Range object.  
     Property Gets the selection range.  
     PropertyReturns a GrapeCity.Documents.Excel.Drawing.IShapes object that represents all the shapes on the worksheet or chart sheet (read-only).  
     Property Returns an object that represents the view settings of this worksheet(read-only).  
     Property Gets or sets whether to display the column outline. The default value is true, and this property only applies when interacting with SJS.  
     Property Gets or sets whether to display the row outline. The default value is true, and this property only applies when interacting with SJS.  
     Property Returns the sorted values in the current worksheet (read-only).  
     Property Gets the split column.  
     Property Gets the split row.  
     Property Gets or sets the standard (default) height(in points) of all the rows in the worksheet (read-only).  
     Property Gets or sets the standard (default) height(in pixels) of all the rows in the worksheet (read-only).  
     Property Gets or sets the standard (default) width(in points) of all the columns in the worksheet (read or write).  
     Property Gets or sets the standard (default) width(in pixels) of all the columns in the worksheet (read or write).  
     Property Gets or sets the primary color of the tab.  
     PropertyReturns a collection of ITable objects in the worksheet. This is a read-only ListObjects collection.  
     Property Gets or sets the tag for current sheet.  
     Property Gets the sheet's type.  
     PropertyReturns the IRange object that represents the used range on the specified worksheet, its behavior is equivalent to GetUsedRange(UsedRangeType.Axis | UsedRangeType.Data | UsedRangeType.Comment | UsedRangeType.Style | UsedRangeType.Merge)  
     PropertyDetermines whether the object is visible (read or write Visibility).  
     Property Get the collection of vertical page breaks within the print area.  
     Property Returns the workbook.  
    Top
    Public Methods
     NameDescription
     Method Makes the current sheet the active sheet. This is equivalent to clicking the sheet's tab.  
     Method Copies the sheet to the end of the specified workbook.  
     Method Copies the sheet to the location after the specified sheet.  
     Method Copies the sheet to the location before the specified sheet.  
     Method Deletes the object.  
     MethodOverloaded.  Converts a Microsoft Excel name to an object or a value.  
     Method Freezes panes at the specified position.  
     Method Freezes trailing panes at the specified position.  
     MethodOverloaded.  Generates a worksheet from the JSON string.  
     Method Gets the used range.  
     Method Moves the sheet to the end of the specified workbook.  
     Method Moves the sheet to the location after the specified sheet.  
     Method Moves the sheet to the location before the specified sheet.  
     Method Prints the worksheet.  
     Method Protects a worksheet so that it cannot be modified.  
     MethodOverloaded.  Saves current worksheet to file.  
     Method Selects the object.  
     Method Makes all rows of the currently filtered list visible. If AutoFilter is in use, this method changes the arrows to "All."  
     Method Splits panes at the specified position.  
     MethodOverloaded.  Saves the worksheet to the specified image file.  
     MethodOverloaded.  Generates a JSON string from the worksheet.  
     Method Unfreezes panes.  
     Method Unfreezes trailing panes.  
     Method Removes protection from the worksheet.  
     Method Unsplits panes.  
    Top
    Public Events
     NameDescription
     Event Occurs when the worksheet is activated.  
     Event Occurs before the worksheet is deleted.  
     Event Occurs when something changes in the cells.  
     Event Occurs when the worksheet is deactivated.  
     Event Occurs when the selection changes on a worksheet.  
    Top
    See Also