| Name | Description | |
|---|---|---|
 | activate | Activates a single cell, which must be inside the current selection. |
| addComment | Adds comments to the current range. |
| addCommentThreaded | Overloaded. Adds a threaded comment to the range. |
| autoFilter | Overloaded. Filters a list using the AutoFilter. |
| autoFit | Overloaded. Changes the width of the columns in the range or the height of the rows in the range to achieve the best fit. |
| calculate | Calculates formulas of the range as needed. |
| characters | Returns a ITextRun object that represents a range of characters within the cell text. |
| clear | Clears formulas, values, and all formatting from the current range. |
| clearComments | Clears the comments from the current range |
| clearCommentsThreaded | Clears the threaded comments from the current range. |
| clearContents | Clears formulas and values from the current range. |
| clearFormats | Clears all formatting from the current range. |
| clearHyperlinks | Clears all hyperLinks from the current range. |
| clearOutline | Clears the outline for the specified range. |
| copy | Overloaded. Copies the range to the specified range |
| cut | Cuts the range to the specified range. |
| delete | Overloaded. Deletes a cell or a range of cells from the worksheet and shifts other cells to replace deleted cells. |
| dirty | Designates all the formulas of the range to be recalculated when the next calculation occurs. |
| find | Overloaded. Finds specific information in a range. |
| fromJson | Generates the range data from the json string. |
| generateGetPivotDataFunction | Overloaded. Generate the corresponding function "GETPIVOTDATA" for the cells in the pivot table. |
| get | Overloaded. Returns a new instance of IRange which is offset from this range. |
| getAddIndent | Gets the property which controls indentation of text when horizontal or vertical alignment is set to distributed. |
| getAddress | Overloaded. Returns a String value that represents the range reference. |
| getAreas | Returns an instance of IAreas which represents an array of rangeswhere each range returned by areas represents one cell or range. |
| getBackgroundImage | Gets the cell background image. |
| getBackgroundImageLayout | Gets the cell background image layout, default is Stretch. |
| getBindingPath | Gets the binding path of the current cell or column. If range is normal range, returns the binding path of the top-left cell of range. If range is EntireColumn, returns the binding path of the left column binding path of range. If range is EntireRow, returns null. |
| getBorders | Returns an instance of IBorders which represents the cell borders ofthe cell or range represented by this IRange. |
| getCellPadding | Gets the cell padding for range. |
| getCells | Returns the IRange object that represents the cells in the specifiedrange. |
| getCellType | Gets the cell type for specified range in the sheet. |
| getColumn | Returns the zero based column number of the first column of this IRange. |
| getColumnCount | Returns the column count of the first range. |
| getColumns | Returns the IRange object that represents the columns in thespecified range. |
| getColumnWidth | Gets the width of the individual columns represented in this range in characters. |
| getColumnWidthInPixel | Gets the width of the individual columns represented in this range in pixels. |
| getComment | Returns an instance of IComment which may be used to get and setComment properties of the cells. |
| getCommentThreaded | |
| getCount | Returns the number of objects in the collection. |
| getCurrentArray | Gets whether the specified cell is part of an array, returns an IRange object that represents the entire array. |
| getDefaultValue | Gets the default value of the cell, it can be the value data or the formula string. It works when the cell has no data. |
| getDependents | Overloaded. Gets the dependent ranges of the left top cell of the range. |
| getDisplayFormat | Gets a DisplayFormat object that represents the display settings for the specified range. |
| getEntireColumn | Returns a new instance of IRange which represents the same range ofcells, but expanded to include all rows. |
| getEntireMergeArea | Returns an IRange representing the area of the current range which isiteratively grown as needed until it includes no partial merged cells. |
| getEntireRow | Returns a new instance of IRange which represents the same range ofcells, but expanded to include all columns. |
| getFont | Returns an instance of IFont which may be used to get and set fontproperties of the cells represented by this IRange. |
| getFormatConditions | Returns a FormatConditions collection that represents all the conditional formats for the specified range. |
| getFormula | Gets the formula of the cells represented by this range in A1-style notation. |
| getFormula2 | Gets the formula of the cells represented by this range in A1-style array notation. |
| getFormula2Local | Gets the localized formula of the cells represented by this range in A1-style array notation. |
| getFormula2R1C1 | Gets the formula of the cells represented by this range in R1C1-style array notation. |
| getFormula2R1C1Local | Gets the localized formula of the cells represented by this range in R1C1-style array notation. |
| getFormulaArray | Gets the array formula of a range. |
| getFormulaArrayR1C1 | Gets the array formula of a range using ReferenceStyle.R1C1. |
| getFormulaHidden | Gets or Sets whether the formula will be hidden when the worksheet is protected |
| getFormulaLocal | Gets the localized formula of the cells represented by this range in A1-style notation. |
| getFormulaR1C1 | Gets the formula of the cells represented by this range in R1C1-style notation. |
| getFormulaR1C1Local | Gets the localized formula of the cells represented by this range in R1C1-style notation. |
| getHasArray | Determines if the specified cell is part of an array formula. |
| getHasFormula | Returns true if the cell or range contains any formulas; otherwise, false is returned. |
| getHasValidation | Returns true if any of the cells represented by this range have data validation associated with them. |
| getHeight | Gets the height, in points, of the range. |
| getHeightInPixel | Gets the height, in pixels, of the range. |
| getHidden | Gets the property which specifies whether rows or columns should be hidden. |
| getHorizontalAlignment | Gets the HorizontalAlignment of a cell or range. |
| getHyperlinks | Returns an instance of IValidation which may be used to get and setHyperLinks properties. |
| getIgnoredError | Gets the error type of the range to be ignored. |
| getIndentLevel | Gets the indent level of the specified cell(s). |
| getInterior | Returns the IInterior which represents the interior (background)color and pattern of the specified cell(s). |
| getLabelOptions | Gets the setting for watermark. |
| getLastColumn | Returns the zero based column number of the last column of the first range. |
| getLastRow | Returns the zero based row number of the last row of the first range. |
| getLocked | Gets the property which specifies whether cells should be locked. |
| getMergeArea | Returns an IRange representing the merged range containing thespecified cell. If the specified cell isn't in a merged range, this property returns the specified cell. |
| getMergeCells | Gets the property which specifies whether cells are merged. |
| getNumberFormat | Gets the number format of the cells in the range. |
| getOrientation | Gets the text orientation of a cell or range, which may be from -90 to 90 degrees, or 255(vertical text). |
| getOutlineLevel | Gets the current outline level of the specified row or column. |
| getPrecedents | Overloaded. Gets the precedent ranges of the left top cell of the range. |
| getReadingOrder | Gets or Sets the reading order for the specified object. |
| getRichText | Gets the rich text object associate with the top-left cell of this range. |
| getRow | Returns the zero based row number of the first row. |
| getRowCount | Returns the row count of the first range. |
| getRowHeight | Gets the height of the individual rows represented by this range in points. |
| getRowHeightInPixel | Gets the height of the individual rows represented by this range in pixels. |
| getRows | Returns the IRange object that represents the rows in the specifiedrange. |
| getShowDetail | Gets whether to show the detail (True if the outline is expanded for the specified range, so that the detail of the column or row is visible). The specified range must be a single summary column or row in an outline.
The following statements are true: 1.The range must be in a single summary row or column. 2.This property returns False if any of the children of the row or column are hidden. 3.Setting this property to True is equivalent to unhiding all the children of the summary row or column. 4.Setting this property to False is equivalent to hiding all the children of the summary row or column. |
| getShrinkToFit | Gets the property which specifies whether cells will be drawn in a smaller font if needed to display the contents of the cell. |
| getSparklineGroups | Returns an instance of ISparklineGroups which may be used to get andset SparklineGroups properties of the cells |
| getStyle | Gets the named style IStyle associated with the cells represented bythis IRange. |
| getSummary | Determines if the range is an outlining summary row or column. |
| getTag | Gets the tag value of the specified range in the sheet. |
| getText | Gets the value of the cell represented by this IRange as a formatted string. |
| getUsedRange | Overloaded. Returns an IRange representing the used range in the current range. |
| getUseStandardHeight | Gets whether the row height of the IRange object equals the standardheight of the sheet. |
| getUseStandardWidth | Gets whether the column width of the IRange object equals thestandard width of the sheet. |
| getValidation | Returns an instance of IValidation which may be used to get and setvalidation properties of the cells represented by this IRange. |
| getValidationIsSame | Returns true if the validation options of all cells represented by this IRange are the same; otherwise, false is returned. |
| getValue | Gets the value of the specified range as a string, double, boolean, java.util.Date, Object[][] or null; |
| getVerticalAlignment | Gets the VerticalAlignment of a cell or range. |
| getWatermark | Gets the watermark for range. |
| getWidth | Gets the width, in points, of the range. |
| getWidthInPixel | Gets the width, in pixels, of the range. |
| getWorksheet | Returns the parent IWorksheet of this range. |
| getWrapText | Get the flag which indicates whether word wrap is enabled in a cell. |
| goalSeek | Attempts to achieve the specified goal, from the calculated result of the formula in the cell represented by this IRange, by modifying the specified changingCell. If you know the result that you want from a formula, but are not sure what input value the formula needs to get that result, use the Goal Seek feature. |
| group | Increments the OutlineLevel of the specified rows or columns. |
| insert | Overloaded. Inserts a cell or a range of cells into the worksheet and shifts other cells away to make space. |
| intersect | Overloaded. Returns an IRange object that represents the intersection of two ranges. If range2 is from a different worksheet, an exception is thrown. |
| isRichText | Indicates whether the cell string value is a rich text. |
| merge | Overloaded. Merges the cells in the represented range into a single merged cell. |
| offset | Returns an IRange object that represents the offset of this range. |
| removeSubtotal | Removes subtotals from a list. |
| replace | Overloaded. Search in formulas and replace. Using this method doesn't change either the selection or the active cell. |
| select | Selects the object. |
| setAddIndent | Sets the property which controls indentation of text when horizontal or vertical alignment is set to distributed. |
| setBackgroundImage | Sets the cell background image. Supported image types include: PNG, JPG, ICO, SVG, GIF. This would be visible only in SpreadJS and Exporting to PDF/HTML/IMG. |
| setBackgroundImageLayout | Sets the cell background image layout. |
| setBindingPath | Sets the binding path of the current cell or column. If range is normal range, sets the binding path of the top-left cell of range. If range is EntireColumn, sets the binding path of the left column binding path of range. If range is EntireRow, do nothing. |
| setCellPadding | Sets the cell padding for range. |
| setCellType | Sets the cell type for specified range in the sheet. |
| setColumnWidth | Sets the width of the individual columns represented in this range in characters. |
| setColumnWidthInPixel | Sets the width of the individual columns represented in this range in pixels. |
| setDefaultValue | Sets the default value of the cell, it can be the value data or the formula string. It works when the cell has no data. |
| setFormula | Sets the formula of the cells represented by this range in A1-style notation. |
| setFormula2 | Sets the formula of the cells represented by this range in A1-style array notation. |
| setFormula2Local | Sets the localized formula of the cells represented by this range in A1-style array notation. |
| setFormula2R1C1 | Sets the formula of the cells represented by this range in R1C1-style array notation. |
| setFormula2R1C1Local | Sets the localized formula of the cells represented by this range in R1C1-style array notation. |
| setFormulaArray | Sets the array formula of a range. |
| setFormulaArrayR1C1 | Sets the array formula of a range using ReferenceStyle.R1C1. |
| setFormulaHidden | Sets whether the formula will be hidden when the worksheet is protected |
| setFormulaLocal | Sets the localized formula of the cells represented by this range in A1-style notation. |
| setFormulaR1C1 | Sets the formula of the cells represented by this range in R1C1-style notation. |
| setFormulaR1C1Local | Sets the localized formula of the cells represented by this range in R1C1-style notation. |
| setHidden | Sets the property which specifies whether rows or columns should be hidden. |
| setHorizontalAlignment | Sets the HorizontalAlignment of a cell or range. |
| setIgnoredError | Sets the error type of the range to be ignored. |
| setIndentLevel | Sets the indent level of the specified cell(s). |
| setLocked | Sets the property which specifies whether cells should be locked. |
| setMergeCells | Sets the property which specifies whether cells are merged. |
| setNumberFormat | Sets the number format of the cells in the range. |
| setOrientation | Sets the text orientation of a cell or range, which may be from -90 to 90 degrees, or 255(vertical text). |
| setOutlineLevel | Sets the current outline level of the specified row or column. |
| setReadingOrder | Sets the reading order for the specified object. |
| setRowHeight | Sets the height of the individual rows represented by this range in points. |
| setRowHeightInPixel | Sets the height of the individual rows represented by this range in pixels. |
| setShowDetail | Sets whether to show the detail (True if the outline is expanded for the specified range, so that the detail of the column or row is visible). The specified range must be a single summary column or row in an outline.
The following statements are true: 1.The range must be in a single summary row or column. 2.This property returns False if any of the children of the row or column are hidden. 3.Setting this property to True is equivalent to unhiding all the children of the summary row or column. 4.Setting this property to False is equivalent to hiding all the children of the summary row or column. |
| setShrinkToFit | Sets the property which specifies whether cells will be drawn in a smaller font if needed to display the contents of the cell. |
| setStyle | Sets the named style IStyle associated with the cells represented bythis IRange. |
| setTag | Sets the tag value of the specified range in the sheet. |
| setUseStandardHeight | Sets whether the row height of the IRange object equals the standardheight of the sheet. |
| setUseStandardWidth | Sets whether the column width of the IRange object equals thestandard width of the sheet. |
| setValue | Sets the value of the specified cell as a string, double, int, boolean, java.util.Date, java.util.Calendar, Object[][] or null. |
| setVerticalAlignment | Sets the VerticalAlignment of a cell or range. |
| setWatermark | Sets the watermark for range. |
| setWrapText | Sets the flag which indicates whether word wrap is enabled in a cell. |
| sort | Overloaded. Sorts the cells represented by this range according to the specified options. |
| specialCells | Overloaded. Gets a IRange object that represents all the cells that match the specified type and value. |
| subtotal | Overloaded. Creates subtotals for the range. |
| toImage | Overloaded. Saves the range to the specified image file. |
| toJson | Generates a json string from the range. |
| ungroup | Decrements the OutlineLevel of the specified rows or columns. |
| union | Overloaded. Returns an IRange object that represents the union of two ranges. If range2 is from a different worksheet, an exception is thrown. |
| unmerge | Converts merged cells in the represented range to normal cells. |