Cell

A cell is the smallest element of an excel workbook. While most properties can and often will be set on higher levels like rows or columns, they can also be adjusted per cell, if necessary.

Example

"cells": [
    {
        "pos": [0,0],
        "picture": {
            "ref": "logo",
            "width": 230,
            "height": 71,
            "position": "move"
        }
    },
    {
        "pos": [0,4,4],
        "value": "Headline over 4 columns",
        "format": {
	    	"fontSize": 20,
		    "bold": true,
	    	"fontColor": {"rgb": [30, 140, 250]}
	    }
    }
]

See the complete reference: Cell Reference

Value

Like in rows, cell data can be pulled from Central Data Storage with the valueRef key, making it easy to deal with dynamic values. Alternatively the value is written directly into the cell using the value key.

Picture

Pictures can only be set in cells. They are set by either writing directly into the cell or by using a reference to the workbook pictures repository.