Free Trial
Web API version
Licensing
Request A Quote
HAVE QUESTIONS OR NEED HELP? SUBMIT THE SUPPORT REQUEST FORM or write email to SUPPORT@BYTESCOUT.COM
Range class
Inheritance Hierarchy
Bytescout.SpreadsheetRange
Namespace: Bytescout.Spreadsheet
Assembly: Bytescout.Spreadsheet (in Bytescout.Spreadsheet.dll) Version: 4.7.1.2054-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