Documents for Excel, Java Edition Documentation
com.grapecity.documents.excel Package / Worksheet Class

In This Topic
    Worksheet Class Methods
    In This Topic

    For a list of all members of this type, see Worksheet members.

    Public Methods
     NameDescription
    Public MethodMakes the current sheet the active sheet.  
    Public Method  
    Public MethodOverloaded. Adds the selection.  
    Public MethodOverloaded.   
    Public Method  
    Public Method  
    Public MethodOverloaded.   
    Public Method  
    Public MethodOverloaded.   
    Public MethodOverloaded.   
    Public Method  
    Public MethodOverloaded.   
    Public Method  
    Public Method  
    Public Method  
    Public MethodOverloaded. Deletes this worksheet.  
    Public MethodSets all the cell data to dirty.  
    Public Method  
    Public Method  
    Public Method  
    Public MethodGenerates a worksheet from the json string.  
    Public Method  
    Public MethodOccurs when the worksheet is activated.  
    Public MethodGets the active cell. The active cell.  
    Public MethodGets the index of the active cell area. The index of the active cell area.  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public MethodOccurs before the worksheet is deleted.  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public MethodOverloaded.   
    Public MethodOverloaded.   
    Public MethodOccurs when something changes in the cells.  
    Public Method  
    Public Method  
    Public Method  
    Public MethodOverloaded.   
    Public MethodProvides access to the collection of Comments contained in the worksheet.  
    Public MethodOverloaded.   
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public MethodOccurs when the worksheet is deactivated.  
    Public Method  
    Public MethodOverloaded.   
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public MethodProvides access to the collection of hyperlinks contained in the worksheet.  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public MethodGets or sets the name of the worksheet . The name.  
    Public Method  
    Public Method  
    Public MethodGets an Outline that represents the outline for the worksheet.  
    Public Method  
    Public Method  
    Public MethodRepresents the page setup description.  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public MethodOverloaded. Returns an instance of IRange which provides access to cell values, formulas, formatting, and other cell properties and methods. The range.  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public MethodGets the selection. The selection.  
    Public MethodOccurs when the selection changes on a worksheet.  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public MethodGets the default height of the rows.  
    Public MethodGets the default height of the rows.  
    Public MethodGets the default width of the columns.  
    Public MethodGets the default width of the columns.  
    Public Method  
    Public Method  
    Public MethodProvides access to the collection of Tables contained in the worksheet.  
    Public Method  
    Public Method  
    Public Method  
    Public MethodOverloaded.   
    Public MethodOverloaded.   
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public MethodGets a workbook that contains the current worksheet. The workbook.  
    Public Method  
    Public Method  
    Public Method  
    Public MethodOverloaded.   
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public MethodOverloaded.   
    Public Method  
    Public MethodOverloaded.   
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public MethodOverloaded.   
    Public MethodOverloaded.   
    Public Method  
    Public MethodOverloaded.   
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public MethodOverloaded.   
    Public Method  
    Public Method  
    Public MethodOverloaded.   
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public MethodOverloaded.   
    Public MethodOverloaded. Sets the selection.  
    Public Method  
    Public Method  
    Public MethodSets the default height of the rows.  
    Public MethodSets the default height of the rows.  
    Public MethodSets the default width of the columns.  
    Public MethodSets the default width of the columns.  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public MethodMakes all rows of the currently filtered list visible. If AutoFilter is in use, this method changes the arrows to "All."  
    Public Method  
    Public MethodOverloaded.   
    Public Method  
    Public Method  
    Public MethodOverloaded.   
    Public MethodGenerates a json string from the worksheet.  
    Public Method  
    Public Method  
    Public Method  
    Public MethodOverloaded.   
    Public Method  
    Public Method  
    Top
    See Also