Range

A cell range in a worksheet with values and formulas.

AutomationBusiness IntelligenceData AnalysisData ProcessingExcelMicrosoftSpreadsheets

Properties

Name	Type	Description
address	string	A1-style range address.
values	array	2D array of cell values.
formulas	array	2D array of cell formulas.

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "Range",
  "description": "A cell range in a worksheet with values and formulas.",
  "type": "object",
  "properties": {
    "address": {
      "type": "string",
      "description": "A1-style range address.",
      "example": "Sheet1!A1:B10"
    },
    "values": {
      "type": "array",
      "description": "2D array of cell values.",
      "items": {
        "type": "array",
        "items": {
          "type": "string"
        }
      }
    },
    "formulas": {
      "type": "array",
      "description": "2D array of cell formulas.",
      "items": {
        "type": "array",
        "items": {
          "type": "string"
        }
      }
    }
  }
}