Documents for Excel, Java Edition Documentation
com.grapecity.documents.excel Package / IWorksheet Interface

In This Topic
    IWorksheet Interface Methods
    In This Topic

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

    Public Methods
     NameDescription
     MethodMakes the current sheet the active sheet. This is equivalent to clicking the sheet's tab.  
     MethodOverloaded. Copies the sheet to the end of the current workbook.  
     MethodCopies the sheet to the location after the specified sheet.  
     MethodCopies the sheet to the location before the specified sheet.  
     MethodDeletes the object.  
     MethodConverts a Microsoft Excel name to an object or a value.  
     MethodFreezes panes at the specified position.  
     MethodFreezes trailing panes at the specified position.  
     MethodGenerates a worksheet from the json string.  
     MethodOccurs when the worksheet is activated.  
     MethodGets the active cell.  
     MethodReturns the IPane object that represents the active pane of the worksheet.  
     MethodReturns an IAutoFilter object if filtering is on. Returns nothing if filtering is off.  
     MethodGets whether the AutoFilter drop-down arrows are currently displayed on the sheet.  
     MethodGets whether to generate columns automatically while binding data.  
     MethodGets the background graphic for this worksheet.  
     MethodReturns a com.grapecity.documents.excel.drawing.IBackgroundPictures object that represents all the backgound pictures on the worksheet or chart sheet.  
     MethodOccurs before the worksheet is deleted.  
     MethodReturns the IRange object that represents all the cells on the worksheet (not just the cells that are currently in use).  
     MethodGets the cell type for sheet.  
     MethodOccurs when something changes in the cells.  
     MethodReturns the IRange object that represents all the columns on the specified worksheet.  
     MethodReturns the IComments collection that represents all the comments for the specified worksheet.  
     MethodGets the data source of data binding for current sheet.  
     MethodOccurs when the worksheet is deactivated.  
     MethodGets whether the worksheet is in filter mode.  
     MethodGets whether the horizontal and vertical page breaks are fixed when inserting/deleting rows/columns.  
     MethodGets the frozen column.  
     MethodGets the frozen row.  
     MethodGets the number of trailing frozen columns of the sheet.  
     MethodGets the number of trailing frozen rows of the sheet.  
     MethodGets the color of frozen line.  
     MethodGet the collection of horizontal page breaks within the print area.  
     MethodProvides access to the collection of Hyperlinks contained in the worksheet.  
     MethodGets the index number of the object within the collection of similar objects.  
     MethodGets the name of the object.  
     MethodReturns the INames collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix).  
     MethodReturns an IOutline object that represents the outline for the specified worksheet.  
     MethodGets the outline column for the worksheet.  
     MethodReturns a IPageSetup object that contains all the page setup settings for the specified object.  
     MethodWorksheet panes.  
     MethodReturns an object that represents either a single PivotTable report a IPivotTables object or a collection of all the PivotTables report IPivotTables object on a worksheet.  
     MethodGets the protection status of the worksheet.  
     MethodReturns the IProtectionSettings object that represents the protection options of the worksheet.  
     MethodOverloaded. Gets the IRange object with the specified reference.  
     MethodReturns the IRange object that represents all the rows on the specified worksheet.  
     MethodGets the selection range.  
     MethodOccurs when the selection changes on a worksheet.  
     MethodReturns a com.grapecity.documents.excel.drawing.IShapes object that represents all the shapes on the worksheet or chart sheet.  
     MethodReturns an object that represents the view settings of this worksheet.  
     MethodGets whether to display the column outline. The default value is true, and this property only applies when interacting with SJS.  
     MethodGets whether to display the row outline. The default value is true, and this property only applies when interacting with SJS.  
     MethodReturns the sorted values in the current worksheet.  
     MethodGets the split column.  
     MethodGets the split row.  
     MethodGets the standard (default) height(in point) of all the rows in the worksheet in points.  
     MethodGets the standard (default) height(in pixel) of all the rows in the worksheet in points.  
     MethodGets the standard (default) width(in point) of all the columns in the worksheet.  
     MethodGets the standard (default) width(in pixel) of all the columns in the worksheet.  
     MethodGets the primary color of the tab.  
     MethodReturns a collection of ITable objects in the worksheet.  
     MethodGets the tag of sheet.  
     MethodGets the sheet's type.  
     MethodOverloaded. Gets the used range.  
     MethodGets whether the object is visible.  
     MethodGet the collection of vertical page breaks within the print area.  
     MethodReturns the workbook.  
     MethodOverloaded. Moves the sheet to the end of the current workbook.  
     MethodMoves the sheet to the location after the specified sheet.  
     MethodMoves the sheet to the location before the specified sheet.  
     MethodOverloaded. Protects a worksheet so that it cannot be modified.  
     MethodOverloaded. Saves current worksheet to the specified file.  
     MethodSets whether the AutoFilter drop-down arrows are currently displayed on the sheet.  
     MethodSets whether to generate columns automatically while binding data.  
     MethodSets the background graphic for this worksheet.  
     MethodSets the cell type for sheet.  
     MethodSets the data source of data binding for current sheet.  
     MethodSets whether the horizontal and vertical page breaks are fixed when inserting/deleting rows/columns.  
     MethodSets the color of frozen line.  
     MethodSets the index number of the object within the collection of similar objects.  
     MethodSets the name of the object.  
     MethodSets the protection status of the worksheet.  
     MethodSets whether to display the column outline. The default value is true, and this property only applies when interacting with SJS..  
     MethodSets whether to display the row outline. The default value is true, and this property only applies when interacting with SJS..  
     MethodSets the standard (default) height(in point) of all the rows in the worksheet in points.  
     MethodSets the standard (default) height(in pixel) of all the rows in the worksheet in points.  
     MethodSets the standard (default) width(in point) of all the columns in the worksheet.  
     MethodSets the standard (default) width(in pixel) of all the columns in the worksheet.  
     MethodSets the primary color of the tab.  
     MethodSets the tag for sheet.  
     MethodSets whether the object is visible.  
     MethodMakes all rows of the currently filtered list visible. If AutoFilter is in use, this method changes the arrows to "All."  
     MethodSplits panes at the specified position.  
     MethodOverloaded. Saves the sheet to the specified image file.  
     MethodGenerates a json string from the worksheet.  
     MethodUnfreezes panes.  
     MethodUnfreezes trailing panes.  
     MethodOverloaded. Removes protection from the worksheet.  
     MethodUnsplits panes.  
    Top
    See Also