XLSX

Page Setup & Headers/Footers

Print orientation, paper size, scaling, headers and footers

Page Setup

Configure worksheet print options:

{
  "worksheets": [
    {
      "name": "Landscape",
      "rows": [
        { "cells": [{ "value": "Product" }, { "value": "Q1" }, { "value": "Q2" }] },
        { "cells": [{ "value": "Widget A" }, { "value": 100 }, { "value": 200 }] }
      ],
      "pageSetup": {
        "orientation": "landscape",
        "paperSize": 1,
        "fitToWidth": 1,
        "fitToHeight": 0
      }
    }
  ]
}

Headers & Footers

Add header and footer text for printed pages. Special codes: &P (page number), &N (total pages):

{
  "worksheets": [
    {
      "name": "Report",
      "rows": [{ "cells": [{ "value": "Data" }] }],
      "headerFooter": {
        "oddHeader": "Sales Report - &P",
        "oddFooter": "Confidential"
      }
    }
  ]
}

Tab Colors

Set worksheet tab color with tabColor:

{
  "worksheets": [
    {
      "name": "Blue Tab",
      "tabColor": { "rgb": "FF4472C4" },
      "rows": [{ "cells": [{ "value": "Blue" }] }]
    },
    {
      "name": "Theme Tab",
      "tabColor": { "theme": 3, "tint": 0.3 },
      "rows": [{ "cells": [{ "value": "Theme color" }] }]
    }
  ]
}

Page Setup Options Reference

OptionTypeDescription
orientationstring"portrait", "landscape", or "default"
paperSizenumberPaper size index (1 = Letter, 9 = A4)
scalenumberScale percentage
fitToWidthnumberHorizontal pages (0 = automatic)
fitToHeightnumberVertical pages (0 = automatic)
pageOrderstring"downThenOver" or "overThenDown"
useFirstPageNumberbooleanUse custom first page number
firstPageNumbernumberFirst page number
OptionTypeDescription
oddHeaderstringOdd page header
oddFooterstringOdd page footer
evenHeaderstringEven page header
evenFooterstringEven page footer
firstHeaderstringFirst page header
firstFooterstringFirst page footer
Copyright © 2026