OfficeIMO

API Reference

Class

RangeBuilder

Edit on GitHub
Namespace OfficeIMO.Excel.Fluent
Assembly OfficeIMO.Excel
Source OfficeIMO.Excel/Fluent/RangeBuilder.cs:22

Fluent helper for operating over a rectangular A1 range (formatting, setting, clearing, per‑cell writes).

Inheritance

  • Object
  • RangeBuilder

Methods

public RangeBuilder Cell(Int32 rowOffset, Int32 columnOffset, Object value = null, String formula = null, String numberFormat = null) #
OfficeIMO.Excel/Fluent/RangeBuilder.cs:71
Returns: RangeBuilder

Writes an individual cell within the range by offset (1‑based) from the top‑left corner.

Parameters

rowOffset System.Int32 requiredposition: 0
columnOffset System.Int32 requiredposition: 1
value System.Object = null optionalposition: 2
formula System.String = null optionalposition: 3
numberFormat System.String = null optionalposition: 4
public RangeBuilder Clear() #
OfficeIMO.Excel/Fluent/RangeBuilder.cs:59
Returns: RangeBuilder

Clears all cells in the range.

public RangeBuilder NumberFormat(String numberFormat) #
OfficeIMO.Excel/Fluent/RangeBuilder.cs:22
Returns: RangeBuilder

Applies a number format to all cells in the range.

Parameters

numberFormat System.String requiredposition: 0
public RangeBuilder Set(Object[] values) #
OfficeIMO.Excel/Fluent/RangeBuilder.cs:41
Returns: RangeBuilder

Writes a 2D array of values into the range. The array dimensions must match the range size.

Parameters

values System.Object[0:,0:] requiredposition: 0
public RangeBuilder Style(Action<StyleBuilder> action) #
OfficeIMO.Excel/Fluent/RangeBuilder.cs:32
Returns: RangeBuilder

Applies styles to the range via a nested StyleBuilder.

Parameters

action System.Action{OfficeIMO.Excel.Fluent.StyleBuilder} requiredposition: 0