API Reference

Class

ExcelFluentReadRange

Namespace OfficeIMO.Excel.Fluent
Assembly OfficeIMO.Excel
Modifiers sealed

Fluent range scope and materializers.

Inheritance

  • Object
  • ExcelFluentReadRange

Usage

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

Methods

public IEnumerable<RowEdit> AsEditableRows() #
Returns: IEnumerable<RowEdit>

Returns editable rows over the range (header-aware cell access + write-back).

public IEnumerable<T> AsObjects<T>() #
Returns: IEnumerable<T>

Type Parameters

T
public IEnumerable<T> AsObjectsStream<T>(CancellationToken ct = null) #
Returns: IEnumerable<T>

Type Parameters

T

Parameters

ct CancellationToken = null optionalposition: 0
AsObjectsStream``1(System.Threading.CancellationToken ct) #

Streams rows (excluding header) as instances of T by matching headers to property names. Enumerate the returned sequence while the owning ExcelDocument is still open.

Parameters

ct System.Threading.CancellationToken required
AsObjects``1() #

Maps rows (excluding header) to instances of T by matching headers to property names.

public IEnumerable<Dictionary<String, Object>> AsRows() #
Returns: IEnumerable<Dictionary<String, Object>>

Reads the range as a sequence of dictionaries using the first row as headers.

public ExcelFluentReadRange NumericAsDecimal(Boolean enable = true) #
Returns: ExcelFluentReadRange

Prefer decimals when converting numeric cells.

Parameters

enable System.Boolean = true optionalposition: 0