XLSX
图表
柱状图、折线图、饼图、面积图和散点图
在工作表中嵌入图表，与数据并列展示。
基本图表
{
"worksheets": [
{
"name": "Data",
"children": [
{ "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": "Quarterly Revenue",
"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 { Workbook, Packer } from "@office-open/xlsx";
const wb = new Workbook({
worksheets: [
{
name: "Data",
children: [
{ 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: "Quarterly Revenue",
categories: ["Q1", "Q2", "Q3", "Q4"],
series: [
{ name: "2023", values: [100, 150, 200, 180] },
{ name: "2024", values: [120, 170, 220, 200] },
],
col: 5,
row: 1,
},
],
},
],
});
图表类型
| 类型 | type 值 |
|---|---|
| 柱状图 | "column" |
| 条形图 | "bar" |
| 折线图 | "line" |
| 饼图 | "pie" |
| 面积图 | "area" |
| 散点图 | "scatter" |
折线图
{
"worksheets": [
{
"name": "Trend",
"children": [
{ "cells": [{ "value": "Month" }, { "value": "Revenue" }] },
{ "cells": [{ "value": "Jan" }, { "value": 100 }] },
{ "cells": [{ "value": "Feb" }, { "value": 150 }] },
{ "cells": [{ "value": "Mar" }, { "value": 200 }] }
],
"charts": [
{
"type": "line",
"title": "Growth Trend",
"categories": ["Jan", "Feb", "Mar"],
"series": [{ "name": "Revenue", "values": [100, 150, 200] }],
"col": 4,
"row": 1
}
]
}
]
}
charts: [{
type: "line",
title: "Growth Trend",
categories: ["Jan", "Feb", "Mar"],
series: [{ name: "Revenue", values: [100, 150, 200] }],
col: 4,
row: 1,
}],
多个图表
{
"worksheets": [
{
"name": "Data",
"children": [
{ "cells": [{ "value": "Quarter" }, { "value": "2024" }] },
{ "cells": [{ "value": "Q1" }, { "value": 120 }] },
{ "cells": [{ "value": "Q2" }, { "value": 170 }] }
],
"charts": [
{
"type": "column",
"title": "Revenue",
"categories": ["Q1", "Q2"],
"series": [{ "name": "2024", "values": [120, 170] }],
"col": 4,
"row": 1
},
{
"type": "line",
"title": "Trend",
"categories": ["Q1", "Q2"],
"series": [{ "name": "2024", "values": [120, 170] }],
"col": 4,
"row": 20
}
]
}
]
}
charts: [
{
type: "column",
title: "Revenue",
categories: ["Q1", "Q2"],
series: [{ name: "2024", values: [120, 170] }],
col: 4,
row: 1,
},
{
type: "line",
title: "Trend",
categories: ["Q1", "Q2"],
series: [{ name: "2024", values: [120, 170] }],
col: 4,
row: 20,
},
],
图表选项参考
| 选项 | 类型 | 说明 |
|---|---|---|
type | "column" | "bar" | "line" | "pie" | "area" | "scatter" | 图表类型 |
title | string | 图表标题 |
categories | string[] | 分类标签 |
series | { name: string, values: number[] }[] | 系列数据 |
col | number | 从 1 开始的列位置 |
row | number | 从 1 开始的行位置 |
showLegend | boolean | 显示图例 |
style | number | 图表样式（1-48） |