Class ExcelCell

Namespace

SheetStream

Assembly

SheetStream.dll

One cell in random-access mode.

public sealed class ExcelCell

Inheritance

object

ExcelCell

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Properties

Address

A1 address.

public string Address { get; }

Property Value

string

Column

1-based column.

public int Column { get; }

Property Value

int

Formula

A formula such as "SUM(A1:A10)" (leading "=" optional). Setting it clears the value. On an edited workbook, the formula text stored in the file; a cell that shares another cell's formula reports null because the text lives in the master cell.

public string? Formula { get; set; }

Property Value

string

Row

1-based row.

public int Row { get; }

Property Value

int

Style

The cell style, or null for the default. On an edited workbook, the style index the cell had in the file, which stays valid in the saved copy. Changing only the style keeps the content as it was.

public CellStyle? Style { get; set; }

Property Value

CellStyle

Value

The value: string, number, bool, DateTime, TimeSpan, RichText[], ExcelErrorValue or null. On an edited workbook, loaded cells report their stored value (a formula cell its cached result; a number with a date format a DateTime). Setting it clears any formula; setting null empties the cell but keeps its style, see Clear() to remove it.

public object? Value { get; set; }

Property Value

object

Methods

Clear()

Removes the cell altogether: value, formula and style. Nothing is written for it.

public void Clear()