| Name | Description |
![public Method](template/packages/core-ajax/images/publicMethod.png) | addColumns | Adds the column or columns to the data model at the specified index. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | addCustomFunction | Adds a custom function. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | addCustomName | Adds a custom name. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | addNamedStyle | Adds a style to the Worksheet named styles collection. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | addRows | Adds rows in this worksheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | addSelection | Adds a cell or cells to the selection. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | addSpan | Adds a span of cells to this sheet in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | autoFitColumn | Automatically fits the viewport column. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | autoFitRow | Automatically fits the viewport row. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | bind | Binds an event to the sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | bindColumn | Binds the column using the specified data field. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | bindColumns | Binds the columns using the specified data fields. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | clear | Clears the specified area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | clearCustomFunctions | Clears all custom functions. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | clearCustomNames | Clears custom names. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | clearPendingChanges | Clears the dirty, insert, and delete status from the current worksheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | clearSelection | Clears the selection. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | copyTo | Copies data from one range to another. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | currentTheme | Gets or sets the current theme for the sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | deleteColumns | Deletes the columns in this sheet at the specified index. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | deleteRows | Deletes the rows in this worksheet at the specified index. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | editorStatus | Returns the editor's status. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | endEdit | Stops editing the active cell. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | fillAuto | Fills the specified range automatically. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | fromJSON | Loads the object state from the specified JSON string. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | frozenColumnCount | Gets or sets the number of frozen columns of the sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | frozenRowCount | Gets or sets the number of frozen rows of the sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | frozenTrailingColumnCount | Gets or sets the number of trailing frozen columns of the sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | frozenTrailingRowCount | Gets or sets the number of trailing frozen rows of the sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getActiveColumnIndex | Gets the active column index for this sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getActiveRowIndex | Gets the active row index for this sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getActualStyle | Gets the actual style information for a specified cell in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getArray | Gets an object array from a specified range of cells. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getBindingPath | Gets the binding path of cell-level binding from the specified cell in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getCell | Gets the specified cell in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getCellRect | Gets the rectangle of the cell. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getCellType | Gets the cell type. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getColumnCount | Gets the column count in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getColumnPageBreak | Gets whether a forced page break is inserted before the specified column on this sheet when printing. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getColumnResizable | Gets a value that indicates whether the user can resize a specified column in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getColumnVisible | Gets whether a column in the specified sheet area is displayed. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getColumnWidth | Gets the width in pixels for the specified column in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getCsv | Gets delimited text from a range. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getCustomFunction | Gets a custom function. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getCustomName | Gets the specified custom name information. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getCustomNames | Gets all custom name information. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getDataColumnName | Gets the column name at the specified position. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getDataItem | Gets the data item. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getDataSource | Gets the data source that populates the sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getDataValidator | Gets the cell data validator. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getDefaultStyle | Gets the default style information for the sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getDeletedRows | Gets the deleted row collection. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getDirtyCells | Gets the dirty cell collection. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getDirtyRows | Gets the dirty row collection. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getFormatter | Gets the cell formatter. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getFormula | Gets the formula in the specified cell in this sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getFormulaInformation | Gets the formula detail information in the specified cell in this sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getInsertRows | Gets the inserted row collection. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getNamedStyle | Gets a style from the Worksheet named styles collection which has the specified name. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getNamedStyles | Gets named styles from the Worksheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getParent | Gets the parent Spread object of the current sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getRange | Gets a range of cells in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getRowCount | Gets the row count in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getRowHeight | Gets the height in pixels for the specified row in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getRowPageBreak | Gets whether a forced page break is inserted before the specified row on this sheet when printing. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getRowResizable | Gets a value that indicates whether users can resize the specified row in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getRowVisible | Gets whether the control displays the specified row. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getSelections | Gets the selections in the current sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getSpans | Gets the spans in the specified range in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getSparkline | Gets the sparkline for the specified cell. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getStyle | Gets the style information for a specified cell in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getStyleName | Gets the name of the style for a specified cell in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getTag | Gets the tag value from the specified cell in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getText | Gets the formatted text in the cell in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getValue | Gets the unformatted data from the specified cell in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getViewportBottomRow | Gets the index of the bottom row in the viewport. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getViewportHeight | Gets the height of the specified viewport row for the active sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getViewportLeftColumn | Gets the index of the left column in the viewport. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getViewportRightColumn | Gets the index of the right column in the viewport. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getViewportTopRow | Gets the index of the top row in the viewport. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | getViewportWidth | Gets the width of the specified viewport column for the active sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | groupSparkline | Groups the sparklines. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | hasPendingChanges | Gets whether there is a dirty, insert, or delete status for the specified range. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | hitTest | Performs a hit test. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | invalidateLayout | Invalidates the sheet layout. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | isDirtySuspended | Gets whether recording the dirty data is suspended. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | isEditing | Gets whether the sheet is in edit mode. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | isPaintSuspended | Get if sheet paint is suspended. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | isPrintLineVisible | Gets or sets whether display a print line for the sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | isValid | Determines whether the cell value is valid. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | moveTo | Moves data from one range to another. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | name | Gets or sets the name of the worksheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | printInfo | Gets or sets the print information for the sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | recalcAll | Recalculates all the formulas in the sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | removeCustomFunction | Removes a custom function. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | removeCustomName | Removes the specified custom name. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | removeNamedStyle | Removes a style from the Worksheet named styles collection which has the specified name. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | removeSpan | Removes the span that contains a specified anchor cell in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | removeSparkline | Removes the sparkline for the specified cell. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | repaint | Repaints the specified rectangle. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | reset | Resets the sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | resumeCalcService | Resumes the calculation service. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | resumeDirty | Resumes recording the dirty data. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | resumeEvent | Resumes the event. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | resumePaint | Resumes the paint. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | rowFilter | Gets or sets the row filter for the sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | search | Searches the specified content. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | selectionPolicy | Gets or sets whether users can select ranges of items on a sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | selectionUnit | Gets or sets whether users can select cells, rows, or columns on a sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setActiveCell | Sets the active cell for this sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setArray | Sets the values in the specified two-dimensional array of objects into the specified range of cells on this sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setArrayFormula | Sets a formula in a specified cell in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setBindingPath | Sets the binding path for cell-level binding in a specified cell in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setCellType | Sets the cell type. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setColumnCount | Sets the column count in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setColumnPageBreak | Sets whether a forced page break is inserted before the specified column on this sheet when printing. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setColumnResizable | Sets whether users can resize the specified column in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setColumnVisible | Sets whether a column in the specified sheet area is displayed. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setColumnWidth | Sets the width in pixels for the specified column in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setCsv | Sets delimited text (CSV) in the sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setDataSource | Sets the data source that populates the sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setDataValidator | Sets the cell data validator. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setDefaultStyle | Sets the default style information for the sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setFormatter | Sets the cell formatter. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setFormula | Sets a formula in a specified cell in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setRowCount | Sets the row count in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setRowHeight | Sets the height in pixels for the specified row in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setRowPageBreak | Sets whether a forced page break is inserted before the specified row on this sheet when printing. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setRowResizable | Sets whether users can resize the specified row in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setRowVisible | Sets whether the control displays the specified row in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setSelection | Sets the selection to a cell or a range and sets the active cell to the first cell. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setSparkline | Sets the sparkline for a cell. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setStyle | Sets the style information for a specified cell in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setStyleName | Sets the specified style name for a specified cell in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setTag | Sets the tag value for the specified cell in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setText | Sets the formatted text in the cell in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | setValue | Sets the value for the specified cell in the specified sheet area. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | showCell | Moves the view of a cell to the specified position in the viewport. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | showColumn | Moves the view of a column to the specified position in the viewport. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | showColumnOutline | Gets or sets whether the column outline (range group) is visible. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | showRow | Moves the view of a row to the specified position in the viewport. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | showRowOutline | Gets or sets whether the row outline (range group) is visible. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | sortRange | Sorts a range of cells in this sheet in the data model. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | startEdit | Starts to edit the cell. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | suspendCalcService | Suspends the calculation service. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | suspendDirty | Suspends recording the dirty data. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | suspendEvent | Suspends the event. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | suspendPaint | Suspends the paint. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | tag | Gets or sets the tag value for the current sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | toJSON | Saves the object state to a JSON string. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | unbind | Removes the binding of an event to the sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | unbindAll | Removes the binding of all events to the sheet. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | ungroupSparkline | Ungroups the sparklines in the specified group. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | visible | Sets whether the worksheet is displayed. |
![public Method](template/packages/core-ajax/images/publicMethod.png) | zoom | |