Class ExcelRow

Namespace

SheetStream.Reading

Assembly

SheetStream.dll

One row read from a sheet. Values is zero-based like a DataRow (column A is index 0) and runs up to the last non-empty cell; missing cells are null.

public sealed class ExcelRow

Inheritance

object

ExcelRow

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Properties

Index

1-based row number in the sheet.

public int Index { get; }

Property Value

int

this[int]

Value at a zero-based column index, or null beyond the last cell.

public object? this[int column] { get; }

Parameters

column int

Property Value

object

Values

Cell values: string, double, bool, DateTime (date-formatted numbers), TimeSpan (elapsed-time formats), ExcelErrorValue, or null. Formula cells yield their cached result.

public IReadOnlyList<object?> Values { get; }

Property Value

IReadOnlyList<object>

Methods

GetDateTime(int)

Value as a date; serial numbers are converted. Null when empty.

public DateTime? GetDateTime(int column)

Parameters

column int

Returns

DateTime?

GetDouble(int)

Value as a number; text is parsed with the invariant culture. Null when empty.

public double? GetDouble(int column)

Parameters

column int

Returns

double?

GetString(int)

Value as text (numbers in invariant culture), or null.

public string? GetString(int column)

Parameters

column int

Returns

string