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
}
}
]
}
{
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"
}
}
]
}
{
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" }] }]
}
]
}
{
name: "Blue Tab",
tabColor: { rgb: "FF4472C4" },
rows: [{ cells: [{ value: "Blue" }] }],
}
Page Setup Options Reference
| Option | Type | Description |
|---|---|---|
orientation | string | "portrait", "landscape", or "default" |
paperSize | number | Paper size index (1 = Letter, 9 = A4) |
scale | number | Scale percentage |
fitToWidth | number | Horizontal pages (0 = automatic) |
fitToHeight | number | Vertical pages (0 = automatic) |
pageOrder | string | "downThenOver" or "overThenDown" |
useFirstPageNumber | boolean | Use custom first page number |
firstPageNumber | number | First page number |
Header & Footer Options Reference
| Option | Type | Description |
|---|---|---|
oddHeader | string | Odd page header |
oddFooter | string | Odd page footer |
evenHeader | string | Even page header |
evenFooter | string | Even page footer |
firstHeader | string | First page header |
firstFooter | string | First page footer |