Cell Members
A single cell in a worksheet.Properties
Name | Description |
---|---|
Alignment | Provides access to cell alignment. Inherited from Formatting. |
Areas | Provides access to the ranges that comprise a complex (union) range. Inherited from CellRange. |
ArrayFormula | Gets or sets the array formula associated with the cell or cell range. Inherited from CellRange. |
ArrayFormulaInvariant | Gets or sets the array formula in the invariant culture. Inherited from CellRange. |
Borders | Provides access to cell borders. Inherited from Formatting. |
BottomRowIndex | Gets the index of the row that includes the bottom edge of the cell range. Inherited from CellRange. |
ColumnCount | Gets the number of columns in the cell range. Inherited from CellRange. |
ColumnIndex | Gets the index of the column that contains the current cell. |
ColumnWidth | Gets or sets the width of columns that contain this cell range. Inherited from CellRange. |
ColumnWidthInCharacters | Gets or sets the width of columns that contain the cell range in characters of the default font specified by the built-in Normal style. Inherited from CellRange. |
CurrentRegion | Gets a range with non-empty cells surrounded by empty rows and columns. Inherited from CellRange. |
Dependents | Gets a list of ranges (cells) whose formulas refer to the current range or cell, directly or indirectly (at any level). Inherited from CellRange. |
DirectDependents | Gets a list of ranges (cells) whose formulas use the current range or cell. Inherited from CellRange. |
DirectPrecedents | Gets a list of ranges (cells) that are directly referred to in the formulas in the current cell or range. Inherited from CellRange. |
DisplayText | Returns a cell’s displayed value. |
ExistingCells | Gets the existing cells in the current cell range. Inherited from CellRange. |
Fill | Provides access to cell background. Inherited from Formatting. |
FillColor | Gets or sets the cell background color. Inherited from CellRange. |
Flags | Provides access to flags that control which cell format attributes are specified by the applied cell style and which ones are specified by direct cell formatting. Inherited from Formatting. |
Font | Provides access to the cell font. Inherited from Formatting. |
Formula | Gets or sets the formula contained in the cell or cell range. Inherited from CellRange. |
FormulaInvariant | Gets or sets the range formula in the invariant culture. Inherited from CellRange. |
HasArrayFormula | Determines whether the current cell or cell range intersects a range filled with an array formula. Inherited from CellRange. |
HasData | Checks whether the current cell range contains data. Inherited from CellRange. |
HasFormula | Determines whether all cells in the range contain a formula. Inherited from CellRange. |
HasQuotePrefix | Indicates whether or not the cell value is prefixed with a single quote. |
HasRichText | Gets a value indicating whether a cell contains rich formatted text. Inherited from CellRange. |
IsDisplayedAsDateTime | Indicates whether a numeric value contained in the cell is displayed as a date and time value. |
IsMerged | Determines whether the range is created by merging cells. Inherited from CellRange. |
IsTopLeftCellInArrayFormulaRange | Indicates whether the current cell is the top left cell in the array formula range. |
Item[Int32, Int32] | Gets an individual cell by row and column offsets from the top left cell of the current range. Inherited from CellRange. |
Item[Int32] | Gets an individual cell by its index in the range of cells. Inherited from CellRange. |
LeftColumnIndex | Gets the index of the column that includes the left edge of the cell range. Inherited from CellRange. |
Name | Gets or sets the name of the cell range. Inherited from CellRange. |
NumberFormat | Specifies a number format for a numeric cell value in the invariant culture. Inherited from Formatting. |
NumberFormatLocal | Specifies a number format for a numeric cell value based on the current (local) culture. Inherited from Formatting. |
ParsedExpression | Gets or sets the expression tree from which the formula entered in the cell is built. |
Precedents | Gets a list of ranges (cells) that are used by a formula in the current cell or range. Inherited from CellRange. |
Protection | Provides access to options which are in effect when the worksheet is protected. Inherited from Formatting. |
RightColumnIndex | Gets the index of the column that includes the right edge of the cell range. Inherited from CellRange. |
RowCount | Gets the number of rows in the cell range. Inherited from CellRange. |
RowHeight | Gets or sets the height of rows that contain this cell range. Inherited from CellRange. |
RowIndex | Gets the index of the row that contains the current cell. |
Style | Gets or sets the style applied to the current range of cells. Inherited from CellRange. |
Tag | Gets or sets custom data associated with the cell. |
TopRowIndex | Gets the index of the row that includes the top edge of the cell range. Inherited from CellRange. |
Value | Gets or sets a cell value. Inherited from CellRange. |
Worksheet | Gets the worksheet that contains the cell range. Inherited from CellRange. |
Methods
Name | Description |
---|---|
BeginUpdate() |
Locks the Formatting object. Prevents visual updates until the EndUpdate method calls.
Inherited from Formatting. |
BeginUpdateFormatting() | Starts modifying the cell range formatting. Inherited from CellRange. |
Calculate() | Forces recalculation of the current cell range. Inherited from CellRange. |
Contains(CellRange) | Determines whether the current cell range contains the specified range. Inherited from CellRange. |
CopyFrom(CellRange, PasteSpecial, Boolean) | Copies the source range of cells and pastes the specified part of the copied data into the current cell range. Inherited from CellRange. |
CopyFrom(CellRange, PasteSpecial) | Copies the source range of cells and pastes the specified part of the copied data into the current cell range. Inherited from CellRange. |
CopyFrom(CellRange) | Copies the specified range of cells into the current range. Inherited from CellRange. |
EndUpdate() |
Unlocks the Formatting object after you call BeginUpdate . It also causes an immediate visual update.
Inherited from Formatting. |
EndUpdateFormatting(Formatting) | Finalizes the modification of the cell range formatting after calling the CellRange.BeginUpdateFormatting method. Inherited from CellRange. |
Equals(Object) | Determines whether or not the specified object is equal to the current Formatting instance. Inherited from Formatting. |
Exclude(CellRange) | Excludes the specified cell or cell range from the current range. Inherited from CellRange. |
GetArrayFormulaRange() | Gets the entire range filled with an array formula, if the cell belongs to that range. |
GetDataSource() | Creates the data source from the current cell range. Inherited from CellRange. |
GetDataSource(RangeDataSourceOptions) | Creates the data source from the current cell range using the specified options. Inherited from CellRange. |
GetDefinedName() | Returns a defined name associated with the current range. Inherited from CellRange. |
GetDefinedName(DefinedNameScope) | Returns a defined name declared in the specified scope and associated with the current cell range. Inherited from CellRange. |
GetEnumerator() | Returns an enumerator that iterates through the collection. Inherited from IEnumerable<T>. |
GetHtmlContent() | Gets cell content as a string in HTML format. |
GetHtmlContent(HtmlCellContentExportOptions) | Gets cell content as a string in HTML format. Allows you to specify export options. |
GetMergedRanges() | Returns merged ranges intersecting the current cell range. Inherited from CellRange. |
GetMinimumCover() | Returns the cell range that covers the current range and does not contain the intersecting ranges. Inherited from CellRange. |
GetRangeWithAbsoluteReference() | Returns the copy of the source range with its reference replaced by the absolute reference. Inherited from CellRange. |
GetRangeWithRelativeReference() | Returns the copy of the source range with its reference replaced by the relative reference. Inherited from CellRange. |
GetReferenceA1() | Gets the relative cell or cell range reference in the A1 reference style. Inherited from CellRange. |
GetReferenceA1(ReferenceElement) | Gets the cell or cell range reference in the A1 reference style. Inherited from CellRange. |
GetReferenceR1C1(Cell) | Gets the relative cell or cell range reference in the R1C1 reference style. Inherited from CellRange. |
GetReferenceR1C1(ReferenceElement, Cell) | Gets the cell or cell range reference in the R1C1 reference style. Inherited from CellRange. |
GetRichText() | Gets the rich text string contained in a cell. Inherited from CellRange. |
GetRtfContent() | Gets cell content as a string in RTF format. |
GetRtfContent(RtfCellContentExportOptions) | Gets cell content as a string in RTF format. Allows you to specify export options. |
Intersect(CellRange) | Returns the cell range that is the intersection of the current and specified ranges. Inherited from CellRange. |
IsIntersecting(CellRange) | Determines whether the current range intersects with the specified range. Inherited from CellRange. |
MoveTo(CellRange) | Moves a range to a specified location. Inherited from CellRange. |
Offset(Int32, Int32) | Returns a cell range that is a given number of rows and columns from the current range. Inherited from CellRange. |
Resize(Int32, Int32) | Resizes the current cell range. Inherited from CellRange. |
Search(String, SearchOptions) | Performs a search in the cell range using specified options. Inherited from CellRange. |
Search(String) | Performs a search in the cell range using the default parameters. Inherited from CellRange. |
SetInsideBorders(Color, BorderLineStyle) | Sets all inside borders of the cell range. Inherited from CellRange. |
SetRichText(RichTextString) | Assigns the rich formatted text to a cell. Inherited from CellRange. |
SetValue(Object) | Converts the specified object to the cell value. Inherited from CellRange. |
SetValueFromText(String, Boolean) | Parses the supplied string and creates a cell value to assign it to the cells in the current range. Inherited from CellRange. |
SetValueFromText(String) | Parses the supplied string and creates a cell value to assign it to the cells in the current range. Inherited from CellRange. |
Union(CellRange) | Creates a complex range that is the union of multiple ranges. Inherited from CellRange. |
See Also