Skip to content

File format

JSON, version 2. Version 1 files (single sheet, top-level cells) still load.

{
  "version": 2,
  "mode": "HYBRID",
  "active": "Inputs",
  "code": "def margin(rev, cost):\n    return (rev - cost) / rev * 100\n",
  "names":  { "revenue": "A1:A12", "costs": "B1:B12" },
  "models": { "default": { "sense": "max", "objective": "B4",
                           "vars": "A4:A5", "constraints": "D4:D6" } },
  "sheets": [
    { "name": "Inputs", "cells": [["Rev","Cost"],[1000,600],[1200,700]] },
    { "name": "Summary","cells": [["Total","=SUM(Inputs!A2:A3)"]] }
  ],
  "format": { "width": 10 }
}

  • mode: "EXCEL", "HYBRID", or "PYTHON". Absent means PYTHON. See Formula modes.

  • sheets (v2): each is {name, cells} with a 2D cells array.

  • active (v2): the name of the sheet to focus on load.

  • names: workbook-global named ranges (sheet-relative when used).

  • models: persisted LP/MIP definitions -- see Optimization.

  • code: the per-workbook Python module string, editable with :e.

A sheet entry may also carry widths, a {"<column index>": pixels} map recording columns resized in the desktop app. It is written only when a sheet has at least one resized column, and the curses renderer ignores it -- the terminal lays columns out from a single uniform width.

.xlsx is a separate path, read and written through a C++ extension rather than being a second native format -- see Import and export.