图片

{
  "worksheets": [
    {
      "name": "Images",
      "children": [{ "cells": [{ "value": "Label" }, { "value": "Data" }] }],
      "images": [
        {
          "data": "<Uint8Array>",
          "type": "png",
          "col": 3,
          "row": 1
        }
      ]
    }
  ]
}

import { readFileSync } from "node:fs";
import { Workbook, Packer } from "@office-open/xlsx";

const wb = new Workbook({
  worksheets: [
    {
      name: "Images",
      children: [{ cells: [{ value: "Label" }, { value: "Data" }] }],
      images: [
        {
          data: readFileSync("./photo.png"),
          type: "png",
          col: 3, // 从 1 开始的列号（D 列）
          row: 1, // 从 1 开始的行号
        },
      ],
    },
  ],
});

{
  "worksheets": [
    {
      "name": "Gallery",
      "children": [{ "cells": [{ "value": "Photos" }] }],
      "images": [
        { "data": "<Uint8Array>", "type": "png", "col": 2, "row": 2 },
        { "data": "<Uint8Array>", "type": "jpeg", "col": 5, "row": 2 }
      ]
    }
  ]
}

images: [
  { data: pngData, type: "png", col: 2, row: 2 },
  { data: jpgData, type: "jpeg", col: 5, row: 2 },
],