Spread Windows Forms 13.0 Product Documentation
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / IWorksheet Interface
Properties Methods

In This Topic
    IWorksheet Interface Members
    In This Topic

    The following tables list the members exposed by IWorksheet.

    Public Properties
     NameDescription
     PropertyGets an IAutoFilter object if filtering is on.  
     PropertyGets a value that indicates whether the AutoFilter drop-down arrows are currently displayed on the sheet.  
     PropertyGets an IRange object which represents the entire worksheet cells (not just the cells that are currently in use).  
     PropertyGets an IRange object that represents the range containing the first circular reference on the worksheet, or returns null if there's no circular reference on the worksheet.  
     PropertyGets or sets the number of columns in this IWorksheet.  
     PropertyGets the column footer of a worksheet.  
     PropertyGets the column header of a worksheet.  
     PropertyGet an IRange object that represents all the columns on the worksheet.  
     PropertyGets the index number of the worksheet within the collection of worksheets.  
     PropertyGets or sets the name of worksheet.  
     PropertyGets a Names collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix).  
     PropertyGets an IOutline object that represents the outline for the specified worksheet.  
     PropertyGets a value indicates whether user-interface-only protection is turned on. To turn on user interface protection, use the Protect method.  
     PropertyGets or sets the number of rows in this IWorksheet.  
     PropertyGets the row header of a worksheet.  
     PropertyGet an IRange object that represents all the rows on the worksheet.  
     Property  
     Property  
     PropertyGets the sort object.  
     Property  
     PropertyGets the ITables object which manages all tables in this IWorksheet.  
     PropertyGets the worksheet type.  
     PropertyGets or sets a SheetVisibility value that determines whether the worksheet is visible.  
     PropertyGets the Workbook object contains current Worksheet object.  
    Top
    Public Methods
     NameDescription
     MethodMakes the current sheet the active sheet.  
     MethodCalculates this worksheet.  
     MethodOverloaded. Circles invalid entries on the worksheet.  
     MethodClears circles from invalid entries on the worksheet.  
     MethodCopies this IWorksheet to the specified position in the IWorksheet collection of the Workbook.  
     MethodDeletes this IWorksheet from its owner Workbook.  
     MethodGets raw data from the specified cell on this sheet.  
     MethodInserts column(s) to the Worksheet at the specified position.  
     MethodInserts row(s) to the Worksheet at the specified position.  
     MethodMoves this IWorksheet to the specified position in the IWorksheet collection of the Workbook.  
     MethodOverloaded.   
     MethodProtects a worksheet so that it cannot be modified.  
     MethodOverloaded. Get an IRange object that represents a cell or a range of cells.  
     MethodRemoves one or more columns starting with the column at the specified position.  
     MethodRemoves one or more rows starting with the row at the specified position.  
     MethodOverloaded.   
     MethodOverloaded. Sets the System.Boolean value for the cell of the specified row and column.  
     MethodUnprotects the worksheet which is protected by password.  
    Top
    See Also