void
Makes the current sheet the active sheet.
void
Applies auto merge for a range.
void
Applies auto merge for a range.
void
Applies auto merge for a range.
void
Applies auto merge for a range.
Copies the sheet to the end of the current workbook.
Copies the sheet to the end of the specified workbook.
Copies the sheet to the location after the specified sheet.
Copies the sheet to the location before the specified sheet.
void
Converts a Microsoft Excel name to an object or a value.
void
Freezes panes at the specified position.
void
Freezes trailing panes at the specified position.
void
Generates a worksheet from the json stream.
void
void
Generates a worksheet from the json string.
void
Occurs when the worksheet is activated.
Returns the
IPane
object that represents the active pane of the worksheet.
boolean
Gets whether the AutoFilter drop-down arrows are currently displayed on the sheet.
boolean
Gets whether to generate columns automatically while binding data.
Gets a list of
IAutoMergeRangeInfo
objects that represent all auto merge range information of the current worksheet.
byte[]
Gets the background graphic for this worksheet.
Returns a
IBackgroundPictures
object that represents all the backgound pictures on theworksheet or chart sheet.
Occurs before the worksheet is deleted.
Returns the
IRange
object that represents all the cells on theworksheet (not just the cells that are currently in use).
Gets the cell type for sheet.
Occurs when something changes in the cells.
int
Gets the column count of the worksheet.
Returns the
IRange
object that represents all the columns on thespecified worksheet.
Returns the
IComments
collection that represents all the comments forthe specified worksheet.
Returns the
ICommentsThreaded
collection that represents all the threaded comments forthe specified worksheet.
Gets the control collection of this worksheet.
Gets the data source of data binding for current sheet.
Occurs when the worksheet is deactivated.
boolean
Gets whether the worksheet is in filter mode.
boolean
Gets whether the horizontal and vertical page breaks are fixed when inserting/deleting rows/columns.
int
int
int
Gets the number of trailing frozen columns of the sheet.
int
Gets the number of trailing frozen rows of the sheet.
Gets the color of frozen line.
Get the collection of horizontal page breaks within the print area.
Provides access to the collection of Hyperlinks contained in the worksheet.
int
Gets the index number of the object within the collection of similar objects.
Gets the name of the object.
Returns the
INames
collection that represents all theworksheet-specific names (names defined with the "WorksheetName!" prefix).
Returns an
IOutline
object that represents the outline for thespecified worksheet.
Gets the outline column for the worksheet.
Returns a
IPageSetup
object that contains all the page setup settingsfor the specified object.
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.
boolean
Gets the protection status of the worksheet.
Gets the
IRange
object with the specified row and column.
getRange(int row,
int column,
int rowCount,
int columnCount)
Gets the
IRange
object with the specified row and column.
Gets the
IRange
object with the specified reference.
int
Gets the row count of the worksheet.
Returns the
IRange
object that represents all the rows on thespecified worksheet.
Get the
IScenarios
object that represents the collection of What-If analysis scenarios in the worksheet.
Gets the selection range.
Occurs when the selection changes on a worksheet.
Returns a
IShapes
object that represents all the shapes on theworksheet or chart sheet.
Returns an object that represents the view settings of this worksheet.
boolean
Gets whether to display the column outline.
boolean
Gets whether to display the row outline.
Returns the sorted values in the current worksheet.
int
int
double
Gets the standard (default) height(in points) of all the rows in the worksheet in points.
double
Gets the standard (default) height(in pixels) of all the rows in the worksheet in points.
double
Gets the standard (default) width(in points) of all the columns in the worksheet.
double
Gets the standard (default) width(in pixels) of all the columns in the worksheet.
Gets the primary color of the tab.
Returns a collection of
ITable
objects in the worksheet.
Gets the used range, its behavior is equivalent to getUsedRange(EnumSet.of(UsedRangeType.Axis, UsedRangeType.Data, UsedRangeType.Comment, UsedRangeType.Style, UsedRangeType.Merge))
Gets whether the object is visible.
Get the collection of vertical page breaks within the print area.
Moves the sheet to the end of the current workbook.
Moves the sheet to the end of the specified workbook.
Moves the sheet to the location after the specified sheet.
Moves the sheet to the location before the specified sheet.
void
Protects a worksheet so that it cannot be modified.
void
Protects a worksheet so that it cannot be modified.
void
Saves current worksheet to the specified format file stream.
void
Saves current worksheet to the specified file stream.
void
Saves current worksheet to the specified file.
void
Saves current worksheet to the specified format file.
void
Saves current worksheet to the specified file.
void
void
void
Sets whether the AutoFilter drop-down arrows are currently displayed on the sheet.
void
Sets whether to generate columns automatically while binding data.
void
Sets the background graphic for this worksheet.
void
Sets the cell type for sheet.
void
Sets the column count of the worksheet.
void
Sets the data source of data binding for current sheet.
void
Sets whether the horizontal and vertical page breaks are fixed when inserting/deleting rows/columns.
void
Sets the color of frozen line.
void
Sets the index number of the object within the collection of similar objects.
void
Sets the name of the object.
void
Sets the protection status of the worksheet.
void
Sets the row count of the worksheet.
void
Sets whether to display the column outline.
void
Sets whether to display the row outline.
void
Sets the standard (default) height(in points) of all the rows in the worksheet in points.
void
Sets the standard (default) height(in pixels) of all the rows in the worksheet in points.
void
Sets the standard (default) width(in points) of all the columns in the worksheet.
void
Sets the standard (default) width(in pixels) of all the columns in the worksheet.
void
Sets the primary color of the tab.
void
void
Sets whether the object is visible.
void
Makes all rows of the currently filtered list visible.
void
Splits panes at the specified position.
void
Saves the sheet to the specified image file.
void
Saves the sheet to the specified image file using options.
void
Saves the sheet to the specified image file.
void
Saves the sheet to the specified image file using options.
Generates a json string from the worksheet.
Generates a json string from the worksheet.
void
Generates a json stream from the worksheet.
void
Generates a json stream from the worksheet.
void
void
Unfreezes trailing panes.
void
Removes protection from the worksheet.
void
Removes protection from the worksheet.
void