图表

{
  "worksheets": [
    {
      "name": "Data",
      "rows": [
        { "cells": [{ "value": "Quarter" }, { "value": "2023" }, { "value": "2024" }] },
        { "cells": [{ "value": "Q1" }, { "value": 100 }, { "value": 120 }] },
        { "cells": [{ "value": "Q2" }, { "value": 150 }, { "value": 170 }] },
        { "cells": [{ "value": "Q3" }, { "value": 200 }, { "value": 220 }] },
        { "cells": [{ "value": "Q4" }, { "value": 180 }, { "value": 200 }] }
      ],
      "charts": [
        {
          "type": "column",
          "title": "季度营收",
          "categories": ["Q1", "Q2", "Q3", "Q4"],
          "series": [
            { "name": "2023", "values": [100, 150, 200, 180] },
            { "name": "2024", "values": [120, 170, 220, 200] }
          ],
          "col": 5,
          "row": 1
        }
      ]
    }
  ]
}

import { generateWorkbook } from "@office-open/xlsx";

const buffer = await generateWorkbook({
  worksheets: [
    {
      name: "Data",
      rows: [
        { cells: [{ value: "Quarter" }, { value: "2023" }, { value: "2024" }] },
        { cells: [{ value: "Q1" }, { value: 100 }, { value: 120 }] },
        { cells: [{ value: "Q2" }, { value: 150 }, { value: 170 }] },
        { cells: [{ value: "Q3" }, { value: 200 }, { value: 220 }] },
        { cells: [{ value: "Q4" }, { value: 180 }, { value: 200 }] },
      ],
      charts: [
        {
          type: "column",
          title: "季度营收",
          categories: ["Q1", "Q2", "Q3", "Q4"],
          series: [
            { name: "2023", values: [100, 150, 200, 180] },
            { name: "2024", values: [120, 170, 220, 200] },
          ],
          col: 5,
          row: 1,
        },
      ],
    },
  ],
});

{
  "worksheets": [
    {
      "name": "Trend",
      "rows": [
        { "cells": [{ "value": "Month" }, { "value": "Revenue" }] },
        { "cells": [{ "value": "Jan" }, { "value": 100 }] },
        { "cells": [{ "value": "Feb" }, { "value": 150 }] },
        { "cells": [{ "value": "Mar" }, { "value": 200 }] }
      ],
      "charts": [
        {
          "type": "line",
          "title": "增长趋势",
          "categories": ["Jan", "Feb", "Mar"],
          "series": [{ "name": "Revenue", "values": [100, 150, 200] }],
          "col": 4,
          "row": 1
        }
      ]
    }
  ]
}

charts: [{
  type: "line",
  title: "增长趋势",
  categories: ["Jan", "Feb", "Mar"],
  series: [{ name: "Revenue", values: [100, 150, 200] }],
  col: 4,
  row: 1,
}],

{
  "worksheets": [
    {
      "name": "Data",
      "rows": [
        { "cells": [{ "value": "Quarter" }, { "value": "2024" }] },
        { "cells": [{ "value": "Q1" }, { "value": 120 }] },
        { "cells": [{ "value": "Q2" }, { "value": 170 }] }
      ],
      "charts": [
        {
          "type": "column",
          "title": "营收",
          "categories": ["Q1", "Q2"],
          "series": [{ "name": "2024", "values": [120, 170] }],
          "col": 4,
          "row": 1
        },
        {
          "type": "line",
          "title": "趋势",
          "categories": ["Q1", "Q2"],
          "series": [{ "name": "2024", "values": [120, 170] }],
          "col": 4,
          "row": 20
        }
      ]
    }
  ]
}

charts: [
  {
    type: "column",
    title: "营收",
    categories: ["Q1", "Q2"],
    series: [{ name: "2024", values: [120, 170] }],
    col: 4,
    row: 1,
  },
  {
    type: "line",
    title: "趋势",
    categories: ["Q1", "Q2"],
    series: [{ name: "2024", values: [120, 170] }],
    col: 4,
    row: 20,
  },
],