Advanced Excel · JSON Structure

Excel Api Range Structure

A cell range in a worksheet with values and formulas.

Type: object Properties: 3
AutomationBusiness IntelligenceData AnalysisData ProcessingExcelMicrosoftSpreadsheets

Excel Api Range Structure is a JSON Structure definition published by Advanced Excel, describing 3 properties. It conforms to the https://json-structure.org/meta/extended/v0/# meta-schema.

Properties

address values formulas

Meta-schema: https://json-structure.org/meta/extended/v0/#

JSON Structure

Raw ↑ 
{
  "$schema": "https://json-structure.org/meta/extended/v0/#",
  "$id": "excel-api-range-structure.json",
  "title": "Range",
  "description": "A cell range in a worksheet with values and formulas.",
  "type": "object",
  "properties": {
    "address": {
      "type": "string",
      "description": "A1-style range address."
    },
    "values": {
      "type": "array",
      "description": "2D array of cell values."
    },
    "formulas": {
      "type": "array",
      "description": "2D array of cell formulas."
    }
  }
}