XLSX

页面设置与页眉页脚

打印方向、纸张大小、缩放比例、页眉和页脚

页面设置

配置工作表的打印选项:

{
  "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
      }
    }
  ]
}

页眉页脚

为打印页面添加页眉和页脚文本。支持特殊代码:&P(页码)、&N(总页数):

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

工作表标签颜色

通过 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" }] }]
    }
  ]
}

页面设置选项参考

选项类型说明
orientationstring"portrait""landscape""default"
paperSizenumber纸张大小编号(1 = Letter, 9 = A4)
scalenumber缩放百分比
fitToWidthnumber水平页数(0 = 自动)
fitToHeightnumber垂直页数(0 = 自动)
pageOrderstring"downThenOver""overThenDown"
useFirstPageNumberboolean使用自定义首页页码
firstPageNumbernumber首页页码

页眉页脚选项参考

选项类型说明
oddHeaderstring奇数页页眉
oddFooterstring奇数页页脚
evenHeaderstring偶数页页眉
evenFooterstring偶数页页脚
firstHeaderstring首页页眉
firstFooterstring首页页脚
Copyright © 2026