Skip to content

CellArray

type CellArray = (Cell | null)[][] & CellArrayLocation;

Represents a 2D array of cells, along with its location and dimensions within the model.

The array itself is a 2D array of Cell objects or null values, where null represents an empty cell. The additional properties from CellArrayLocation provide context about the location and dimensions of the array within the sheet and workbook.

This type is used as the return value when reading a cell array from the model, such as when evaluating a formula that returns an array of cells.