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 interface
Namespace: Bytescout.Spreadsheet.COM
Assembly: Bytescout.Spreadsheet (in Bytescout.Spreadsheet.dll) Version: 4.7.1.2054-master
Syntax
The IRange type exposes the following members.
Properties
Name | Description | |
---|---|---|
AlignmentHorizontal |
Sets the horizontal text alignment style of the row.
| |
AlignmentVertical |
Sets the vertical text alignment style of the row.
| |
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.
| |
DiagonalBorderColor |
Gets or sets the color of the diagonal border.
| |
DiagonalBorderStyle |
Gets or sets the diagonal border style.
| |
FillPattern |
Sets the fill pattern of the row.
| |
FillPatternBackColor |
Sets the background color for a fill pattern of the row.
| |
FillPatternForeColor |
Sets the foreground color for a fill pattern of the row.
| |
Font |
Sets the font.
| |
FontColor |
Sets the color of the font.
| |
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.
| |
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.
| |
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 row.
| |
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 whether a text is wrapped.
|
Methods
Name | Description | |
---|---|---|
Calculate |
Calculates the formulas in the Range.
| |
CopyInto(String) |
Makes copy and paste of the current range into position referenced by A1-style cell name
| |
CopyInto(Int32, Int32) |
Makes a copy and paste of the current range into the position referenced by (row, col) cell
|
See Also