Cell 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
Cell class
Inheritance Hierarchy
Bytescout.SpreadsheetCell
Namespace:Bytescout.Spreadsheet
Assembly: Bytescout.Spreadsheet (in Bytescout.Spreadsheet.dll) Version: 4.7.0.2045-master
Syntax
The Cell type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
 | AlignmentHorizontal | Gets or sets a horizontal text alignment style of the cell. |
| AlignmentVertical | Gets or sets the vertical text alignment style of the cell. |
| BottomBorderColor | Gets or sets the color of the bottom border. |
| BottomBorderStyle | Gets or sets the bottom border style. |
| CellFormat | Gets or sets the cell format. |
| ColIndex | Column index. |
| ContainsArrayFormula | Gets a value indicating whether this cell contains an array formula. |
| DiagonalBorderColor | Gets or sets the color of the diagonal border. |
| DiagonalBorderStyle | Gets or sets the diagonal border style. |
| FillPattern | Gets or sets the fill pattern. |
 | FillPatternBackColor | Gets or sets the background color for a fill pattern. |
| FillPatternBackColorOLE | OLE/COM version of FillPatternBackColor property for environments with the late object binding, like VBScript. |
| FillPatternForeColor | Gets or sets the foreground color for a fill pattern. |
| FillPatternForeColorOLE | OLE/COM version of FillPatternForeColor property for environments with the late object binding, like VBScript. |
| Font | Gets or sets the font of the cell. |
| FontColor | Gets or sets the color of the font. |
| FontColorIndex | Gets or sets the index of the font color. |
| FontEscapement | Gets or sets the font escapement. |
| FontUnderline | Gets or sets the font underline style. |
| Formula | Gets or sets the formula for the cell. |
| HiddenFormula | Gets or sets a value indicating whether formula is hidden. |
| Indent | Gets or sets the Indent value for the cell. |
| IsDiagonalDownLine | Gets or sets a value indicating whether this instance is diagonal line from top left to right bottom |
| IsDiagonalUpLine | Gets or sets a value indicating whether this instance is diagonal line from bottom left to right top |
| IsInteger | Gets a value indicating whether this Cell contains integer number. |
| LeftBorderColor | Gets or sets the color of the left border. |
| LeftBorderStyle | Gets or sets the left border style. |
| Locked | Gets or sets a value indicating whether this IExtFormat is locked. |
| Merged | Gets a value indicating whether this Cell is merged. |
| MergedWith | Gets the Range merged with this cell. |
| MergedWithCell | Gets the top left cell of Range merged this with cell. |
| NumberFormatString | Gets or sets the number format string. |
| RightBorderColor | Gets or sets the color of the right border. |
| RightBorderStyle | Gets or sets the right border style. |
| Rotation | Gets or sets the text rotation angle for the cell. |
| RowIndex | Row index. |
| ShrinkToFit | Gets or sets a value indicating shrink content to fit into cell. |
| TextDirection | Gets or sets the reading order. |
| TopBorderColor | Gets or sets the color of the top border. |
| TopBorderStyle | Gets or sets the top border style. |
| Validation | Gets the Validation object that represents data validation for the specified cell. |
| Value | Gets or sets the value of cell. |
| ValueAsBoolean | Gets a value as boolean. |
| ValueAsDateTime | Gets or sets the value as date time, see type DateTime |
| ValueAsDouble | Gets the value as double. |
| ValueAsExcelDisplays | Returns the formatted string value of the cell in the sam way you would see in Excel or another spreadsheet editor. Formatting uses the NumberFormatType settings to format the value. |
| ValueAsHTML | Gets or sets the formatted text (Rich-Text) in HTML coded format |
| ValueAsInteger | Gets the value as integer. |
| ValueAsString | Returns the formatted string value of the cell in the sam way you would see in Excel or another spreadsheet editor. Formatting uses the NumberFormatType settings to format the value or NumberFormatString format string. |
| ValueAsUnformattedString | Gets the value as unformatted string. |
| ValueDataType | Gets the type of the value data. |
| ValueDataTypeByNumberFormatString | Gets or sets the type (NumberFormatType) of the number format. |
| Wrap | Gets or sets a value indicating a text is wrapped. |
Methods
| Name | Description | |
|---|---|---|
 | Calculate | Calculates of formula this cell (if formula is set for this cell) |
| Clear | Clears this cell. |
| Dispose | Disposes the instance |
 | Dispose(Boolean) | Disposes the instance |
| Equals | Determines whether the specified Object is equal to the current Object. (Inherited from Object.) |
| Finalize | Cell destructor (Overrides ObjectFinalize.) |
| GetAddress | Returns address of the cell as CellAddress 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.) |
| SetFontColorRGB | Sets the color of the font from the specified 8-bit color values (red, green, and blue). |
| SetFontProperties | Sets the font properties. |
| ToDateTime | Return the cell value as date time, see type DateTime |
| ToDouble | Return cell value as double, see type Double. |
| ToHTML | Return the formatted text (Rich-Text) in HTML coded format |
| ToInteger | Return cell value as integer, see type Int32. |
| ToString | Returns a String that represents the current Object. (Overrides ObjectToString.) |
See Also