Skip to main content
SearchCtrl K
Community

Source code

OfficeIMO.NET libraries, CLI, Studio and browser tools 574 stars PSWriteOfficePowerShell module 165 stars

Talk and help

DiscordQuestions, ideas and show and tell Report an issueBugs and feature requests SponsorFund ongoing development

Mode

Background

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Search the whole siteOpen search page →
Documentation Search all OfficeIMO/

API Reference

Class

RangeBuilder

Edit on GitHub
Namespace OfficeIMO.Excel.Fluent
Assembly OfficeIMO.Excel
Source revision 02c4d39034ec with working tree changes
Source RangeBuilder.cs:22

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

Inheritance

  • Object
  • RangeBuilder

Usage

Explore 6 API references to this type

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

Returned or exposed by 5

Accepted by parameters 1

Methods

public RangeBuilder Cell(Int32 rowOffset, Int32 columnOffset, Object? value = null, String? formula = null, String? numberFormat = null) #
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() #
RangeBuilder.cs:59
Returns: RangeBuilder

Clears all cells in the range.

public RangeBuilder NumberFormat(String numberFormat) #
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) #
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[,] requiredposition: 0
public RangeBuilder Style(Action<StyleBuilder> action) #
RangeBuilder.cs:32
Returns: RangeBuilder

Applies styles to the range via a nested StyleBuilder.

Parameters

action System.Action<OfficeIMO.Excel.Fluent.StyleBuilder> requiredposition: 0