Name | Description | |
---|---|---|
Activate | Activates a single cell, which must be inside the current selection. | |
AddComment | Adds comments to the current IRange. | |
AddCommentThreaded | Adds a threaded comment to the current IRange. | |
AutoFilter | 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, this method can only be called when the value of cell is a string, or else System.InvalidOperationException is thrown. | |
Clear | Clears formulas, values, and all formatting from the current IRange. | |
ClearComments | Clears the comments from the current IRange | |
ClearCommentsThreaded | Clears the threaded comment from the current IRange | |
ClearContents | Clears formulas and values from the current IRange. | |
ClearFormats | Clears all formatting from the current IRange. | |
ClearHyperlinks | Clears all hyperLinks from the current IRange. | |
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 | Deletes a cell or a range of cells from the worksheet and shifts other cells to replace deleted cells. Specifies which way to shift the cells. | |
Dirty | Designates all the formulas of the range to be recalculated when the next calculation occurs. | |
Find | Finds specific information in a range. | |
FromJson | Generates the range data from the JSON string. | |
GenerateGetPivotDataFunction | Generate the corresponding function "GETPIVOTDATA" for the cells in the pivot table. | |
GetAddress | Returns a System.String value that represents the range reference. If all parameters are omitted, the return value is equal to the Address property. | |
GetDependents | Overloaded. Gets the dependent ranges of the left top cell of the range. | |
GetPrecedents | Overloaded. Gets the precedent ranges of the left top cell of the range. | |
GetUsedRange | Gets an IRange representing the used range in the current range. | |
Group | Increments the OutlineLevel of the specified rows or columns. | |
Insert | Inserts a cell or a range of cells into the worksheet and shifts other cells away to make space. Specifies which way to shift the cells. | |
Intersect | Overloaded. Returns an IRange object that represents the intersection of two ranges. If range2 is from a different worksheet, an exception is thrown. | |
Merge | 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 | Search in formulas and replace. Using this method doesn't change either the selection or the active cell. | |
Select | Selects the object. | |
Sort | Overloaded. Sorts the cells represented by this range according to the specified options. | |
SpecialCells | Gets a IRange object that represents all the cells that match the specified type and value. | |
Subtotal | 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. |