Advanced Excel · Example Payload

Excel Api Range Example

AutomationBusiness IntelligenceData AnalysisData ProcessingExcelMicrosoftSpreadsheets

Excel Api Range Example is an example object payload from Advanced Excel, with 3 top-level fields. It illustrates the shape of data this provider's APIs accept or return.

Top-level fields

addressvaluesformulas

Example Payload

{
  "address": "Sheet1!A1:B3",
  "values": [
    [
      "Name",
      "Revenue"
    ],
    [
      "Q1",
      50000
    ],
    [
      "Q2",
      62000
    ]
  ],
  "formulas": [
    [
      "Name",
      "Revenue"
    ],
    [
      "Q1",
      "50000"
    ],
    [
      "Q2",
      "62000"
    ]
  ]
}