| Name | Description |
![Method](template/packages/core-java/images/Method.png) | activate | Makes the current sheet the active sheet. This is equivalent to clicking the sheet's tab. |
![Method](template/packages/core-java/images/Method.png) | copy | Overloaded. Copies the sheet to the end of the current workbook. |
![Method](template/packages/core-java/images/Method.png) | copyAfter | Copies the sheet to the location after the specified sheet. |
![Method](template/packages/core-java/images/Method.png) | copyBefore | Copies the sheet to the location before the specified sheet. |
![Method](template/packages/core-java/images/Method.png) | delete | Deletes the object. |
![Method](template/packages/core-java/images/Method.png) | evaluate | Overloaded. Converts a Microsoft Excel name to an object or a value. |
![Method](template/packages/core-java/images/Method.png) | freezePanes | Freezes panes at the specified position. |
![Method](template/packages/core-java/images/Method.png) | freezeTrailingPanes | Freezes trailing panes at the specified position. |
![Method](template/packages/core-java/images/Method.png) | fromJson | Overloaded. Generates a worksheet from the json string. |
![Method](template/packages/core-java/images/Method.png) | getActivatedEvent | Occurs when the worksheet is activated. |
![Method](template/packages/core-java/images/Method.png) | getActiveCell | Gets the active cell. |
![Method](template/packages/core-java/images/Method.png) | getActivePane | Returns the IPane object that represents the active pane of the worksheet. |
![Method](template/packages/core-java/images/Method.png) | getAutoFilter | Returns an IAutoFilter object if filtering is on. Returns nothing iffiltering is off. |
![Method](template/packages/core-java/images/Method.png) | getAutoFilterMode | Gets whether the AutoFilter drop-down arrows are currently displayed on the sheet. |
![Method](template/packages/core-java/images/Method.png) | getAutoGenerateColumns | Gets whether to generate columns automatically while binding data. |
![Method](template/packages/core-java/images/Method.png) | getBackgroundPicture | Gets the background graphic for this worksheet. |
![Method](template/packages/core-java/images/Method.png) | getBackgroundPictures | Returns a com.grapecity.documents.excel.drawing.IBackgroundPictures object that represents all the backgound pictures on theworksheet or chart sheet. |
![Method](template/packages/core-java/images/Method.png) | getBeforeDeleteEvent | Occurs before the worksheet is deleted. |
![Method](template/packages/core-java/images/Method.png) | getCells | Returns the IRange object that represents all the cells on theworksheet (not just the cells that are currently in use). |
![Method](template/packages/core-java/images/Method.png) | getCellType | Gets the cell type for sheet. |
![Method](template/packages/core-java/images/Method.png) | getChangedEvent | Occurs when something changes in the cells. |
![Method](template/packages/core-java/images/Method.png) | getColumnCount | Gets the column count of the worksheet when exported to json. |
![Method](template/packages/core-java/images/Method.png) | getColumns | Returns the IRange object that represents all the columns on thespecified worksheet. |
![Method](template/packages/core-java/images/Method.png) | getComments | Returns the IComments collection that represents all the comments forthe specified worksheet. |
![Method](template/packages/core-java/images/Method.png) | getCommentsThreaded | Returns the ICommentsThreaded collection that represents all the threaded comments forthe specified worksheet. |
![Method](template/packages/core-java/images/Method.png) | getControls | Gets the control collection of this worksheet. |
![Method](template/packages/core-java/images/Method.png) | getDataSource | Gets the data source of data binding for current sheet. |
![Method](template/packages/core-java/images/Method.png) | getDeactivatedEvent | Occurs when the worksheet is deactivated. |
![Method](template/packages/core-java/images/Method.png) | getFilterMode | Gets whether the worksheet is in filter mode. |
![Method](template/packages/core-java/images/Method.png) | getFixedPageBreaks | Gets whether the horizontal and vertical page breaks are fixed when inserting/deleting rows/columns. |
![Method](template/packages/core-java/images/Method.png) | getFreezeColumn | Gets the frozen column. |
![Method](template/packages/core-java/images/Method.png) | getFreezeRow | Gets the frozen row. |
![Method](template/packages/core-java/images/Method.png) | getFreezeTrailingColumn | Gets the number of trailing frozen columns of the sheet. |
![Method](template/packages/core-java/images/Method.png) | getFreezeTrailingRow | Gets the number of trailing frozen rows of the sheet. |
![Method](template/packages/core-java/images/Method.png) | getFrozenLineColor | Gets the color of frozen line. |
![Method](template/packages/core-java/images/Method.png) | getHPageBreaks | Get the collection of horizontal page breaks within the print area. |
![Method](template/packages/core-java/images/Method.png) | getHyperlinks | Provides access to the collection of Hyperlinks contained in the worksheet. |
![Method](template/packages/core-java/images/Method.png) | getIndex | Gets the index number of the object within the collection of similar objects. |
![Method](template/packages/core-java/images/Method.png) | getName | Gets the name of the object. |
![Method](template/packages/core-java/images/Method.png) | getNames | Returns the INames collection that represents all theworksheet-specific names (names defined with the "WorksheetName!" prefix). |
![Method](template/packages/core-java/images/Method.png) | getOutline | Returns an IOutline object that represents the outline for thespecified worksheet. |
![Method](template/packages/core-java/images/Method.png) | getOutlineColumn | Gets the outline column for the worksheet. |
![Method](template/packages/core-java/images/Method.png) | getPageSetup | Returns a IPageSetup object that contains all the page setup settingsfor the specified object. |
![Method](template/packages/core-java/images/Method.png) | getPanes | Worksheet panes. |
![Method](template/packages/core-java/images/Method.png) | getPivotTables | Returns 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. |
![Method](template/packages/core-java/images/Method.png) | getProtection | Gets the protection status of the worksheet. |
![Method](template/packages/core-java/images/Method.png) | getProtectionSettings | Returns the IProtectionSettings object that represents the protectionoptions of the worksheet. |
![Method](template/packages/core-java/images/Method.png) | getRange | Overloaded. Gets the IRange object with the specified reference. |
![Method](template/packages/core-java/images/Method.png) | getRowCount | Gets the row count of the worksheet when exported to json. |
![Method](template/packages/core-java/images/Method.png) | getRows | Returns the IRange object that represents all the rows on thespecified worksheet. |
![Method](template/packages/core-java/images/Method.png) | getSelection | Gets the selection range. |
![Method](template/packages/core-java/images/Method.png) | getSelectionChangeEvent | Occurs when the selection changes on a worksheet. |
![Method](template/packages/core-java/images/Method.png) | getShapes | Returns a com.grapecity.documents.excel.drawing.IShapes object that represents all the shapes on theworksheet or chart sheet. |
![Method](template/packages/core-java/images/Method.png) | getSheetView | Returns an object that represents the view settings of this worksheet. |
![Method](template/packages/core-java/images/Method.png) | getShowColumnOutline | Gets whether to display the column outline. The default value is true, and this property only applies when interacting with SJS. |
![Method](template/packages/core-java/images/Method.png) | getShowRowOutline | Gets whether to display the row outline. The default value is true, and this property only applies when interacting with SJS. |
![Method](template/packages/core-java/images/Method.png) | getSort | Returns the sorted values in the current worksheet. |
![Method](template/packages/core-java/images/Method.png) | getSplitColumn | Gets the split column. |
![Method](template/packages/core-java/images/Method.png) | getSplitRow | Gets the split row. |
![Method](template/packages/core-java/images/Method.png) | getStandardHeight | Gets the standard (default) height(in points) of all the rows in the worksheet in points. |
![Method](template/packages/core-java/images/Method.png) | getStandardHeightInPixel | Gets the standard (default) height(in pixels) of all the rows in the worksheet in points. |
![Method](template/packages/core-java/images/Method.png) | getStandardWidth | Gets the standard (default) width(in points) of all the columns in the worksheet. |
![Method](template/packages/core-java/images/Method.png) | getStandardWidthInPixel | Gets the standard (default) width(in pixels) of all the columns in the worksheet. |
![Method](template/packages/core-java/images/Method.png) | getTabColor | Gets the primary color of the tab. |
![Method](template/packages/core-java/images/Method.png) | getTables | Returns a collection of ITable objects in the worksheet. |
![Method](template/packages/core-java/images/Method.png) | getTag | Gets the tag of sheet. |
![Method](template/packages/core-java/images/Method.png) | getType | Gets the sheet's type. |
![Method](template/packages/core-java/images/Method.png) | getUsedRange | Overloaded. Gets the used range, its behavior is equivalent to getUsedRange(EnumSet.of(UsedRangeType.Axis, UsedRangeType.Data, UsedRangeType.Comment, UsedRangeType.Style, UsedRangeType.Merge)) |
![Method](template/packages/core-java/images/Method.png) | getVisible | Gets whether the object is visible. |
![Method](template/packages/core-java/images/Method.png) | getVPageBreaks | Get the collection of vertical page breaks within the print area. |
![Method](template/packages/core-java/images/Method.png) | getWorkbook | Returns the workbook. |
![Method](template/packages/core-java/images/Method.png) | move | Overloaded. Moves the sheet to the end of the current workbook. |
![Method](template/packages/core-java/images/Method.png) | moveAfter | Moves the sheet to the location after the specified sheet. |
![Method](template/packages/core-java/images/Method.png) | moveBefore | Moves the sheet to the location before the specified sheet. |
![Method](template/packages/core-java/images/Method.png) | protect | Overloaded. Protects a worksheet so that it cannot be modified. |
![Method](template/packages/core-java/images/Method.png) | save | Overloaded. Saves current worksheet to the specified file. |
![Method](template/packages/core-java/images/Method.png) | select | Overloaded. Selects the object. |
![Method](template/packages/core-java/images/Method.png) | setAutoFilterMode | Sets whether the AutoFilter drop-down arrows are currently displayed on the sheet. |
![Method](template/packages/core-java/images/Method.png) | setAutoGenerateColumns | Sets whether to generate columns automatically while binding data. |
![Method](template/packages/core-java/images/Method.png) | setBackgroundPicture | Sets the background graphic for this worksheet. |
![Method](template/packages/core-java/images/Method.png) | setCellType | Sets the cell type for sheet. |
![Method](template/packages/core-java/images/Method.png) | setColumnCount | Sets the column count of the worksheet when exported to json. |
![Method](template/packages/core-java/images/Method.png) | setDataSource | Sets the data source of data binding for current sheet. |
![Method](template/packages/core-java/images/Method.png) | setFixedPageBreaks | Sets whether the horizontal and vertical page breaks are fixed when inserting/deleting rows/columns. |
![Method](template/packages/core-java/images/Method.png) | setFrozenLineColor | Sets the color of frozen line. |
![Method](template/packages/core-java/images/Method.png) | setIndex | Sets the index number of the object within the collection of similar objects. |
![Method](template/packages/core-java/images/Method.png) | setName | Sets the name of the object. |
![Method](template/packages/core-java/images/Method.png) | setProtection | Sets the protection status of the worksheet. |
![Method](template/packages/core-java/images/Method.png) | setRowCount | Sets the row count of the worksheet when exported to json. |
![Method](template/packages/core-java/images/Method.png) | setShowColumnOutline | Sets whether to display the column outline. The default value is true, and this property only applies when interacting with SJS.. |
![Method](template/packages/core-java/images/Method.png) | setShowRowOutline | Sets whether to display the row outline. The default value is true, and this property only applies when interacting with SJS.. |
![Method](template/packages/core-java/images/Method.png) | setStandardHeight | Sets the standard (default) height(in points) of all the rows in the worksheet in points. |
![Method](template/packages/core-java/images/Method.png) | setStandardHeightInPixel | Sets the standard (default) height(in pixels) of all the rows in the worksheet in points. |
![Method](template/packages/core-java/images/Method.png) | setStandardWidth | Sets the standard (default) width(in points) of all the columns in the worksheet. |
![Method](template/packages/core-java/images/Method.png) | setStandardWidthInPixel | Sets the standard (default) width(in pixels) of all the columns in the worksheet. |
![Method](template/packages/core-java/images/Method.png) | setTabColor | Sets the primary color of the tab. |
![Method](template/packages/core-java/images/Method.png) | setTag | Sets the tag for sheet. |
![Method](template/packages/core-java/images/Method.png) | setVisible | Sets whether the object is visible. |
![Method](template/packages/core-java/images/Method.png) | showAllData | Makes all rows of the currently filtered list visible. If AutoFilter is in use, this method changes the arrows to "All." |
![Method](template/packages/core-java/images/Method.png) | splitPanes | Splits panes at the specified position. |
![Method](template/packages/core-java/images/Method.png) | toImage | Overloaded. Saves the sheet to the specified image file. |
![Method](template/packages/core-java/images/Method.png) | toJson | Overloaded. Generates a json string from the worksheet. |
![Method](template/packages/core-java/images/Method.png) | unfreezePanes | Unfreezes panes. |
![Method](template/packages/core-java/images/Method.png) | unfreezeTrailingPanes | Unfreezes trailing panes. |
![Method](template/packages/core-java/images/Method.png) | unprotect | Overloaded. Removes protection from the worksheet. |
![Method](template/packages/core-java/images/Method.png) | unsplitPanes | Unsplits panes. |