Skip to content

BH.oM.Adapters.Excel.CellRange

Object representing an orthogonal range between two cell in the spreadsheet.

Class structure

Implemented interfaces and base types

The CellRange is inheriting from the following base type(s) and implements the following interfaces:

Properties

Defining properties

The following properties are defined on the class

Name Type Description Quantity
From CellAddress Starting (upper left) cell of the range. -
To CellAddress Ending (bottom right) cell of the range. -

Derived properties

The following properties are defined as extension methods in one of the BHoM_Engines

Name Type Description Quantity Engine
IsValid bool Checks whether given BHoM CellRange is valid for use in Excel adapter and raises errors if not. - Excel_Engine

Code and Schema

C# implementation

C#
public class CellRange : BH.oM.Base.IObject

Assembly: Excel_oM.dll

The C# class definition is available on github:

All history and changes of the class can be found by inspection the history.

JSON Schema implementation

The object is defined as a JSON schema. You can validate a JSON instance against this schema by reference. To do this, use the schema reference below in a validator like this one.

JSON Schema
{
 "$ref" : "https://raw.githubusercontent.com/BHoM/BHoM_JSONSchema/develop/Excel_oM/CellRange.json"
}

The JSON Schema is available on github here: