Microsoft Excel · Example Payload

Excel Graph Api Range Example

AutomationData AnalysisMicrosoftMicrosoft 365OfficeSpreadsheets

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

Top-level fields

addressaddressLocalcellCountcolumnCountcolumnIndexrowCountrowIndexhiddenvaluestextnumberFormatvalueTypes

Example Payload

Raw ↑ 
{
  "address": "Sheet1!A1:B2",
  "addressLocal": "Sheet1!A1:B2",
  "cellCount": 4,
  "columnCount": 2,
  "columnIndex": 0,
  "rowCount": 2,
  "rowIndex": 0,
  "hidden": false,
  "values": [["Revenue", "Q1"], ["Product A", 15000]],
  "text": [["Revenue", "Q1"], ["Product A", "15000"]],
  "numberFormat": [["General", "General"], ["General", "#,##0"]],
  "valueTypes": [["String", "String"], ["String", "Double"]]
}