addPropertyChangedListener

Registers listener so that it will receive events from the worksheet.

addWorksheetListener

Registers listener so that it will receive events from the worksheet.

beginInit

Signals the worksheet to enter an initialization state. To exit the initialization state, call endInit.

clear

Clears the entire content of the worksheet.

copy

Overloaded. Copies this worksheet to another workbook.

copyData

Copies the data in the specified range and returns an object identifying the copied data.

copyStyles

Copies the styles in the specified range and returns an object identifying the copied styles.

endInit

Signals the worksheet that initialization is complete. To enter initialization state, call beginInit.

getAutoFilter

Gets an AutoFilter object if autofiltering is enabled; otherwise, null.

getAutoFilterMode

Gets a value indicating whether there is an active autofilter in the worksheet.

getCellRanges

Gets an object that can be used to access and manipulate rectangular ranges of worksheet cells.

getCells

Gets an object that can be used to access worksheet cells by (column, row) index or by name.

getColumns

Gets an object that can be used to insert, delete and modify worksheet columns.

getDefaultColumnWidth

Gets the default width of columns.

getDefaultRowHeight

Gets the default height of rows.

getDrawing

Gets the Drawing object associated with the worksheet.

getLocale

Gets the locale of the parent workbook.

getMaxColumns

Gets the maximum number of columns this worksheet will draw.

getMaxRows

Gets the maximum number of rows this worksheet will draw.

getMergedCell

Overloaded. Gets the merged cell containing a specified cell.

getMergedCells

Gets a list with the currently merged cells.

getName

Gets the name of the worksheet.

getRows

Gets an object that can be used to insert, delete and modify worksheet rows.

getTabBackground

Gets the color of tab associated with this worksheet.

getTag

Gets a custom object associated with the worksheet.

getVisible

Gets a value indicating whether this worksheet is visible.

getZoom

Gets the zoom factor of the worksheet when displayed in a view.

merge

Overloaded. Merges the cells in the specified range into a single cell.

move

Overloaded. Moves this worksheet to a specified workbook.

pasteData

Pastes the data identified by the specified object at the specified location. The data in the target range is discarded.

pasteStyles

Pastes the styles identified by the specified object at the specified location. The style information in the target range is discarded.

removePropertyChangedListener

Unregisters listener so that it will no longer receive worksheet events.

removeWorksheetListener

Unregisters listener so that it will no longer receive worksheet events.

setAutoFilterMode

Sets a value indicating whether there is an active autofilter in the worksheet.

setDefaultColumnWidth

Sets the default width of columns.

setDefaultRowHeight

Sets the default height of rows.

setMaxColumns

Sets the maximum number of columns this worksheet will draw.

setMaxRows

Sets the maximum number of rows this worksheet will draw.

setName

Sets the name of the worksheet.

setTabBackground

Sets the color of tab associated with this worksheet.

setTag

Sets a custom object associated with the worksheet.

setVisible

Sets a value indicating whether this worksheet is visible.

setZoom

Sets the zoom factor of the worksheet when displayed in a view.

sort

Sorts the data in the specified range according to the specified criteria.

toString

unmerge

Overloaded. Unmerges all merged cells intersecting with the specified range.

onCellChanged

Raises the WorksheetListener.cellChanged event.

onCellChangedPostCalc

Raises the WorksheetListener.cellChangedPostCalc event.

onCellChangedPreCalc

Raises the WorksheetListener.cellChangedPreCalc event.

onCellChanging

Raises the WorksheetListener.cellChanging event.

onCellParsing

onCellsCleared

Raises the WorksheetListener.cellsCleared event.

onCellStyleChanging

Raises the WorksheetListener.cellChanging event.

onColumnChanged

Raises the WorksheetListener.columnChanged event.

onPropertyChange

Raises the PropertyChangeListener.propertyChange event.

onRowChanged

Raises the WorksheetListener.rowChanged event.

onValidationFailed

Raises the WorksheetListener.validationFailed event.