Microsoft Excel · Schema

Range

Represents a cell range in a worksheet.

AutomationData AnalysisMicrosoftMicrosoft 365OfficeSpreadsheets

Properties

Name Type Description
address string Range reference in A1-style notation.
addressLocal string Range reference in locale-specific notation.
cellCount integer Number of cells in the range.
columnCount integer Number of columns.
columnIndex integer Column number of the first cell.
rowCount integer Number of rows.
rowIndex integer Row number of the first cell.
hidden boolean Whether the range is hidden.
formulas array Formulas in A1-style notation.
values array Raw values of the range.
text array Text values of the range.
numberFormat array Number format codes.
valueTypes array Type of data in each cell.
View JSON Schema on GitHub