Range Class
Free Trial Web API version Licensing Request A Quote
HAVE QUESTIONS OR NEED HELP?SUBMIT THE SUPPORT REQUEST FORM or write email toSUPPORT@BYTESCOUT.COM
Range class
Inheritance Hierarchy
Bytescout.SpreadsheetRange
Namespace:Bytescout.Spreadsheet
Assembly: Bytescout.Spreadsheet (in Bytescout.Spreadsheet.dll) Version: 4.7.0.2045-master
Syntax
The Range type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
 | AlignmentHorizontal | Sets a horizontal text alignment style of the cell. |
| AlignmentVertical | Sets the vertical text alignment style of the cell. |
| Areas | Gets an Areas collection that represents all the ranges in a multiple-area selection. |
| BottomBorderColor | Sets the color of the bottom border. |
| BottomBorderStyle | Sets the bottom border style. |
| BottomRowIndex | Index of the bottom row of the range. |
| CellFormat | Sets the cell format. |
| Column | Gets the zero based column number of the first column in the first area (Areas[0]) of the Range . |
| Columns | Gets a Range object that represents the columns in the specified range. |
 | Count | Gets the number of cells in the Range. |
| DiagonalBorderColor | Sets the color of the diagonal border. |
| DiagonalBorderStyle | Sets the diagonal border style. |
| FillPattern | Sets the fill pattern. |
| FillPatternBackColor | Sets the background color for a fill pattern. |
| FillPatternForeColor | Sets the foreground color for a fill pattern. |
| Font | Sets the font of the cell. |
| FontColor | Sets the color of the font. |
| FontColorIndex | Sets the index of the font color. |
| FontEscapement | Sets the font escapement. |
| FontUnderline | Sets the font underline style. |
| Formula | Sets the formula for the range. |
| HiddenFormula | Gets or sets a value indicating whether formula is hidden. |
| Indent | Gets or sets the Indent value for the cell. |
| InnerBorderColor | Sets the color of the inner border. |
| InnerBorderStyle | Sets the inner border style. |
| IsDiagonalDownLine | Sets a value indicating whether this instance is diagonal down line. |
| IsDiagonalUpLine | Sets a value indicating whether this instance is diagonal up line. |
| IsNotEmptyCells | Gets a bool value indicating that the range contains only empty cells or not |
| LeftBorderColor | Sets the color of the left border. |
| LeftBorderStyle | Sets the left border style. |
| LeftColumnIndex | Index of the left column of the range. |
| Locked | Sets a value indicating whether this IRange is locked. |
| NumberFormatString | Sets the number format string. |
| OuterBorderColor | Sets the color of the outer border. |
| OuterBorderStyle | Sets the outer border style. |
| RightBorderColor | Sets the color of the right border. |
| RightBorderStyle | Sets the right border style. |
| RightColumnIndex | Index of the right column of the range. |
| Rotation | Sets the text rotation angle for the cell. |
| Row | Gets the zero based row number of the first row in the first area (Areas[0]) of the Range . |
| Rows | Gets a Range object that represents the rows in the specified range. |
| ShrinkToFit | Gets or sets a value indicating shrink content to fit into cell. |
| TextDirection | Gets or sets the reading order. |
| TopBorderColor | Sets the color of the top border. |
| TopBorderStyle | Sets the top border style. |
| TopRowIndex | Index of the top row of the range. |
| Value | Sets the value of range. |
| ValueAsHTML | Sets the formatted text (Rich-Text) in HTML coded format |
| ValueDataTypeByNumberFormatString | Sets the type (ValueDataTypeByNumberFormatString) of the number format. |
| Wrap | Sets a value indicating a text is wrapped. |
Methods
| Name | Description | |
|---|---|---|
 | Address | Returns the range reference. |
| Address(Boolean, Boolean, Boolean) | Returns the range reference. |
| Calculate | Calculates the formulas in the Range. |
| CopyInto(String) | Makes a copy and paste of this range into a new range specified by top left cell (referenced by A1-style name, for example: A1, F3 or C4) |
| CopyInto(Int32, Int32) | Makes a copy and paste of this range into a new range specified by top left cell (row, col indexes) |
| Equals | Determines whether the specified Object is equal to the current Object. (Inherited from Object.) |
 | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetType | Gets the type of the current instance. (Inherited from Object.) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| Merge | Merges cells in the range. |
| Sort(String, SortOrder, Boolean, SortOrientation, SortDataOption) | Sorts a range. |
| Sort(String, SortOrder, String, SortOrder, String, SortOrder, Boolean, SortOrientation, SortDataOption, SortDataOption, SortDataOption) | Sorts a range. |
| SpecialCells | Returns a CellList object that represents all the cells that match the specified type and value. |
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
| UnMerge | Unmerges cells in the range. |
See Also