wehub-resource-sync
8cb1f9f479
Publish SDK (PyPI) / publish (push) Waiting to run
Publish SDK (npm) / publish (@aionui/officecli-sdk) (push) Waiting to run
Publish SDK (npm) / publish (@officecli/officecli-sdk) (push) Waiting to run
Publish SDK (npm) / publish (@officecli/sdk) (push) Waiting to run
Publish SDK (npm) / publish (officecli-sdk) (push) Waiting to run
SDK smoke / smoke (windows-latest) (push) Waiting to run
SDK smoke / smoke (macos-latest) (push) Waiting to run
SDK smoke / smoke (ubuntu-latest) (push) Waiting to run
Skill parity / diff (push) Waiting to run
548 lines
25 KiB
Python
548 lines
25 KiB
Python
#!/usr/bin/env python3
|
|
"""
|
|
Basic Charts Showcase — column, bar, line, and area charts with all variations.
|
|
|
|
Generates: charts-basic.xlsx
|
|
|
|
Each sheet demonstrates one chart family with all its variants and key properties.
|
|
See charts-basic.md for a guide to each sheet.
|
|
|
|
SDK twin of charts-basic.sh (officecli CLI). Both produce an equivalent
|
|
charts-basic.xlsx. This one drives the **officecli Python SDK**
|
|
(`pip install officecli-sdk`): one resident is started, every cell write and
|
|
every chart is shipped over the named pipe, batched per sheet. Each item is the
|
|
same `{"command","parent","type","props"}` / `{"command":"set","path","props"}`
|
|
dict you'd put in an `officecli batch` list.
|
|
|
|
Usage:
|
|
pip install officecli-sdk # plus the `officecli` binary on PATH
|
|
python3 charts-basic.py
|
|
"""
|
|
|
|
import os
|
|
import sys
|
|
|
|
# --- locate the SDK: prefer an installed `officecli-sdk`, else the in-repo copy
|
|
try:
|
|
import officecli # pip install officecli-sdk
|
|
except ImportError:
|
|
sys.path.insert(0, os.path.join(os.path.dirname(os.path.abspath(__file__)),
|
|
"..", "..", "..", "sdk", "python"))
|
|
import officecli
|
|
|
|
FILE = os.path.join(os.path.dirname(os.path.abspath(__file__)), "charts-basic.xlsx")
|
|
|
|
|
|
def add_sheet(name):
|
|
"""One `add sheet` item in batch-shape."""
|
|
return {"command": "add", "parent": "/", "type": "sheet", "props": {"name": name}}
|
|
|
|
|
|
def chart(sheet, **props):
|
|
"""One `add chart` item in batch-shape (parent is the sheet path)."""
|
|
return {"command": "add", "parent": f"/{sheet}", "type": "chart", "props": props}
|
|
|
|
|
|
print(f"Building {FILE} ...")
|
|
|
|
with officecli.create(FILE, "--force") as doc:
|
|
|
|
# ======================================================================
|
|
# Source data — shared across all charts
|
|
# ======================================================================
|
|
print("--- Populating source data ---")
|
|
|
|
data_items = []
|
|
for j, h in enumerate(["Month", "East", "South", "North", "West"]):
|
|
data_items.append({"command": "set", "path": f"/Sheet1/{'ABCDE'[j]}1",
|
|
"props": {"text": h, "bold": "true"}})
|
|
|
|
months = ["Jan", "Feb", "Mar", "Apr", "May", "Jun",
|
|
"Jul", "Aug", "Sep", "Oct", "Nov", "Dec"]
|
|
east = [120, 135, 148, 162, 155, 178, 195, 210, 188, 172, 165, 198]
|
|
south = [95, 108, 115, 128, 142, 155, 168, 175, 160, 148, 135, 158]
|
|
north = [88, 92, 105, 118, 125, 138, 145, 152, 140, 130, 122, 142]
|
|
west = [110, 118, 130, 145, 138, 162, 175, 190, 170, 155, 148, 180]
|
|
|
|
for i in range(12):
|
|
r = i + 2
|
|
for j, val in enumerate([months[i], east[i], south[i], north[i], west[i]]):
|
|
data_items.append({"command": "set", "path": f"/Sheet1/{'ABCDE'[j]}{r}",
|
|
"props": {"text": str(val)}})
|
|
|
|
doc.batch(data_items)
|
|
|
|
# ======================================================================
|
|
# Sheet: 1-Column Charts
|
|
# ======================================================================
|
|
print("--- 1-Column Charts ---")
|
|
doc.batch([
|
|
add_sheet("1-Column Charts"),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 1: Basic clustered column from cell range with axis titles
|
|
# Features: chartType=column, dataRange, catTitle, axisTitle, axisfont, gridlines
|
|
# ------------------------------------------------------------------
|
|
chart("1-Column Charts",
|
|
chartType="column",
|
|
title="Regional Sales by Month",
|
|
dataRange="Sheet1!A1:E13",
|
|
x="0", y="0", width="12", height="18",
|
|
catTitle="Month", axisTitle="Sales",
|
|
axisfont="9:58626E:Arial",
|
|
gridlines="D9D9D9:0.5:dot"),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 2: Stacked column with custom colors, data labels, and gap control
|
|
# Features: columnStacked, colors, dataLabels, labelPos, gapwidth, series.outline
|
|
# ------------------------------------------------------------------
|
|
chart("1-Column Charts",
|
|
chartType="columnStacked",
|
|
title="Stacked Regional Sales",
|
|
dataRange="Sheet1!A1:E13",
|
|
colors="2E75B6,70AD47,FFC000,C00000",
|
|
x="13", y="0", width="12", height="18",
|
|
dataLabels="true", labelPos="center",
|
|
gapwidth="60",
|
|
**{"series.outline": "FFFFFF-0.5"}),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 3: 100% stacked column with legend position and plotFill
|
|
# Features: columnPercentStacked, legend=bottom, legendfont, plotFill
|
|
# ------------------------------------------------------------------
|
|
chart("1-Column Charts",
|
|
chartType="columnPercentStacked",
|
|
title="Market Share by Month",
|
|
dataRange="Sheet1!A1:E13",
|
|
x="0", y="19", width="12", height="18",
|
|
legend="bottom",
|
|
legendfont="9:8B949E",
|
|
plotFill="F5F5F5"),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 4: 3D column with perspective and title styling
|
|
# Features: column3d, view3d (rotX,rotY,perspective), title.font/size/color/bold
|
|
# ------------------------------------------------------------------
|
|
chart("1-Column Charts",
|
|
chartType="column3d",
|
|
title="3D Regional Sales",
|
|
dataRange="Sheet1!A1:E13",
|
|
x="13", y="19", width="12", height="18",
|
|
view3d="15,20,30",
|
|
**{"title.font": "Calibri", "title.size": "16",
|
|
"title.color": "1F4E79", "title.bold": "true"}),
|
|
])
|
|
|
|
# ======================================================================
|
|
# Sheet: 2-Bar Charts
|
|
# ======================================================================
|
|
print("--- 2-Bar Charts ---")
|
|
doc.batch([
|
|
add_sheet("2-Bar Charts"),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 1: Horizontal bar with inline data and gapwidth
|
|
# Features: bar, inline data (Name:v1;Name2:v2), gapwidth, labelPos=outsideEnd
|
|
# ------------------------------------------------------------------
|
|
chart("2-Bar Charts",
|
|
chartType="bar",
|
|
title="Q4 Sales by Region",
|
|
data="East:198;South:158;North:142;West:180",
|
|
categories="East,South,North,West",
|
|
colors="2E75B6,70AD47,FFC000,C00000",
|
|
x="0", y="0", width="12", height="18",
|
|
gapwidth="80",
|
|
dataLabels="true", labelPos="outsideEnd"),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 2: Stacked bar with named series and overlap
|
|
# Features: barStacked, named series (series1=Name:v1,v2), overlap
|
|
# ------------------------------------------------------------------
|
|
chart("2-Bar Charts",
|
|
chartType="barStacked",
|
|
title="H1 vs H2 Sales",
|
|
series1="H1:663,598,528,661",
|
|
series2="H2:833,718,669,868",
|
|
categories="East,South,North,West",
|
|
colors="4472C4,ED7D31",
|
|
x="13", y="0", width="12", height="18",
|
|
dataLabels="true", labelPos="center",
|
|
gapwidth="50", overlap="0"),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 3: 100% stacked bar with reference line
|
|
#
|
|
# Note: on a barPercentStacked chart, the value axis is 0-1 (displayed as
|
|
# 0%-100%), so a 50% reference line must be written as 0.5 — not 50.
|
|
# referenceLine supports: value | value:color | value:color:label |
|
|
# value:color:width:dash | value:color:label:dash (legacy) |
|
|
# value:color:width:dash:label (canonical). Width is in points; default 1.5pt.
|
|
#
|
|
# Features: barPercentStacked, referenceLine, axisLine, catAxisLine
|
|
# ------------------------------------------------------------------
|
|
chart("2-Bar Charts",
|
|
chartType="barPercentStacked",
|
|
title="Regional Contribution %",
|
|
dataRange="Sheet1!A1:E13",
|
|
x="0", y="19", width="12", height="18",
|
|
referenceLine="0.5:FF0000:Target:dash",
|
|
axisLine="333333:1:solid",
|
|
catAxisLine="333333:1:solid"),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 4: 3D bar with chart area fill and display units
|
|
# Features: bar3d, chartFill (chart area background), style/styleId (preset 1-48)
|
|
# ------------------------------------------------------------------
|
|
chart("2-Bar Charts",
|
|
chartType="bar3d",
|
|
title="3D Regional Comparison",
|
|
dataRange="Sheet1!A1:E13",
|
|
x="13", y="19", width="12", height="18",
|
|
view3d="10,30,20",
|
|
chartFill="F2F2F2",
|
|
style="3"),
|
|
])
|
|
|
|
# ======================================================================
|
|
# Sheet: 3-Line Charts
|
|
# ======================================================================
|
|
print("--- 3-Line Charts ---")
|
|
doc.batch([
|
|
add_sheet("3-Line Charts"),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 1: Line with markers and cell-range series (dotted syntax)
|
|
# Features: series.name/values/categories (cell range), marker (style:size:color),
|
|
# gridlines, minorGridlines
|
|
# ------------------------------------------------------------------
|
|
chart("3-Line Charts",
|
|
chartType="line",
|
|
title="East Region Trend",
|
|
x="0", y="0", width="12", height="18",
|
|
showMarkers="true", marker="circle:6:2E75B6",
|
|
gridlines="D9D9D9:0.5:dot",
|
|
minorGridlines="EEEEEE:0.3:dot",
|
|
**{"series1.name": "East",
|
|
"series1.values": "Sheet1!B2:B13",
|
|
"series1.categories": "Sheet1!A2:A13"}),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 2: Smooth line with custom width and no gridlines
|
|
# Features: smooth, lineWidth, gridlines=none, series.shadow (color-blur-angle-dist-opacity)
|
|
# ------------------------------------------------------------------
|
|
chart("3-Line Charts",
|
|
chartType="line",
|
|
title="Smoothed Sales Trend",
|
|
dataRange="Sheet1!A1:E13",
|
|
x="13", y="0", width="12", height="18",
|
|
smooth="true", lineWidth="2.5",
|
|
colors="0070C0,00B050,FFC000,FF0000",
|
|
gridlines="none",
|
|
**{"series.shadow": "000000-4-315-2-40"}),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 3: Stacked line
|
|
# Features: lineStacked, majorTickMark, tickLabelPos
|
|
# ------------------------------------------------------------------
|
|
chart("3-Line Charts",
|
|
chartType="lineStacked",
|
|
title="Cumulative Sales",
|
|
dataRange="Sheet1!A1:E13",
|
|
x="0", y="19", width="12", height="18",
|
|
catTitle="Month", axisTitle="Cumulative",
|
|
majorTickMark="outside", tickLabelPos="low"),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 4: Line with dashed lines, data table, and hidden legend
|
|
# Features: lineDash (solid/dot/dash/dashdot/longdash), dataTable, legend=none
|
|
# ------------------------------------------------------------------
|
|
chart("3-Line Charts",
|
|
chartType="line",
|
|
title="Trend with Data Table",
|
|
dataRange="Sheet1!A1:E13",
|
|
x="13", y="19", width="12", height="18",
|
|
lineDash="dash", lineWidth="1.5",
|
|
dataTable="true",
|
|
legend="none"),
|
|
])
|
|
|
|
# ======================================================================
|
|
# Sheet: 4-Area Charts
|
|
# ======================================================================
|
|
print("--- 4-Area Charts ---")
|
|
doc.batch([
|
|
add_sheet("4-Area Charts"),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 1: Area with transparency and gradient fill
|
|
# Features: area, transparency (0-100%), gradient (color1-color2:angle)
|
|
# ------------------------------------------------------------------
|
|
chart("4-Area Charts",
|
|
chartType="area",
|
|
title="Sales Volume",
|
|
dataRange="Sheet1!A1:E13",
|
|
x="0", y="0", width="12", height="18",
|
|
transparency="40",
|
|
gradient="4472C4-BDD7EE:90"),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 2: Stacked area with plotFill and rounded corners
|
|
# Features: areaStacked, plotFill, roundedCorners
|
|
# ------------------------------------------------------------------
|
|
chart("4-Area Charts",
|
|
chartType="areaStacked",
|
|
title="Stacked Volume",
|
|
dataRange="Sheet1!A1:E13",
|
|
x="13", y="0", width="12", height="18",
|
|
plotFill="F5F5F5",
|
|
roundedCorners="true",
|
|
transparency="30"),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 3: 100% stacked area with axis control
|
|
# Features: areaPercentStacked, axisVisible, axisLine
|
|
# ------------------------------------------------------------------
|
|
chart("4-Area Charts",
|
|
chartType="areaPercentStacked",
|
|
title="Regional Mix %",
|
|
dataRange="Sheet1!A1:E13",
|
|
x="0", y="19", width="12", height="18",
|
|
transparency="20",
|
|
axisVisible="true",
|
|
axisLine="999999:0.5:solid"),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 4: 3D area with perspective
|
|
# Features: area3d, view3d
|
|
# ------------------------------------------------------------------
|
|
chart("4-Area Charts",
|
|
chartType="area3d",
|
|
title="3D Sales Volume",
|
|
dataRange="Sheet1!A1:E13",
|
|
x="13", y="19", width="12", height="18",
|
|
view3d="20,25,15",
|
|
colors="5B9BD5,A5D5A5,FFD966,F4B183"),
|
|
])
|
|
|
|
# ======================================================================
|
|
# Sheet: 5-Styling
|
|
# Demonstrates all styling/layout properties on a single column chart
|
|
# ======================================================================
|
|
print("--- 5-Styling ---")
|
|
doc.batch([
|
|
add_sheet("5-Styling"),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 1: Fully styled column chart — title, legend, axis, series effects
|
|
# Features: title.font/size/color/bold/shadow, legendfont, axisfont,
|
|
# series.outline, series.shadow, roundedCorners, referenceLine
|
|
# ------------------------------------------------------------------
|
|
chart("5-Styling",
|
|
chartType="column",
|
|
title="Fully Styled Chart",
|
|
dataRange="Sheet1!A1:E13",
|
|
x="0", y="0", width="14", height="20",
|
|
legend="right",
|
|
axisfont="9:58626E:Arial",
|
|
catTitle="Month", axisTitle="Revenue",
|
|
gridlines="CCCCCC:0.5:dot",
|
|
plotFill="FAFAFA",
|
|
chartFill="FFFFFF",
|
|
gapwidth="100",
|
|
roundedCorners="true",
|
|
referenceLine="160:FF0000:1:dash",
|
|
colors="4472C4,ED7D31,70AD47,FFC000",
|
|
legendfont="10:444444:Helvetica",
|
|
**{"title.font": "Georgia", "title.size": "18",
|
|
"title.color": "1F4E79", "title.bold": "true",
|
|
"title.shadow": "000000-3-315-2-30",
|
|
"series.outline": "FFFFFF-0.5",
|
|
"series.shadow": "000000-3-315-2-25"}),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 2: Column with secondary axis (dual Y-axis)
|
|
# Features: secondaryAxis (comma-separated 1-based series indices for second Y-axis)
|
|
# ------------------------------------------------------------------
|
|
chart("5-Styling",
|
|
chartType="column",
|
|
title="Sales vs Growth Rate",
|
|
series1="Sales:120,135,148,162",
|
|
series2="Growth:5.2,8.1,12.3,15.6",
|
|
categories="Q1,Q2,Q3,Q4",
|
|
x="15", y="0", width="10", height="20",
|
|
secondaryAxis="2",
|
|
colors="4472C4,FF0000"),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 3: Column with individual point colors and inverted negatives
|
|
# Features: point{N}.color (per-point coloring), invertIfNeg
|
|
# ------------------------------------------------------------------
|
|
chart("5-Styling",
|
|
chartType="column",
|
|
title="Quarterly P&L",
|
|
series1="P&L:500,300,-200,800",
|
|
categories="Q1,Q2,Q3,Q4",
|
|
x="0", y="21", width="10", height="18",
|
|
invertIfNeg="true",
|
|
dataLabels="true", labelPos="outsideEnd",
|
|
**{"point1.color": "70AD47", "point2.color": "70AD47",
|
|
"point3.color": "FF0000", "point4.color": "70AD47"}),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 4: Line with gradient plot area and custom data labels
|
|
# Features: plotFill gradient (color1-color2:angle), marker styles (diamond),
|
|
# dataLabels.numFmt, dataLabel{N}.text (custom text for one label)
|
|
# ------------------------------------------------------------------
|
|
chart("5-Styling",
|
|
chartType="line",
|
|
title="Custom Labels Demo",
|
|
series1="Revenue:100,200,300,250",
|
|
categories="Q1,Q2,Q3,Q4",
|
|
x="11", y="21", width="14", height="18",
|
|
plotFill="E8F0FE-FFFFFF:90",
|
|
showMarkers="true", marker="diamond:8:4472C4",
|
|
lineWidth="2",
|
|
dataLabels="true", labelPos="top",
|
|
**{"dataLabels.numFmt": "#,##0",
|
|
"dataLabel3.text": "Peak!"}),
|
|
])
|
|
|
|
# ======================================================================
|
|
# Sheet: 6-Layout
|
|
# Manual layout of plot area, title, legend; axis orientation; log scale;
|
|
# display units; label font and separator; error bars
|
|
# ======================================================================
|
|
print("--- 6-Layout ---")
|
|
doc.batch([
|
|
add_sheet("6-Layout"),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 1: Manual layout positioning of plot area, title, legend
|
|
# Features: plotArea.x/y/w/h (0-1 fraction), title.x/y, legend.x/y, legend.overlay
|
|
# ------------------------------------------------------------------
|
|
chart("6-Layout",
|
|
chartType="column",
|
|
title="Manual Layout",
|
|
dataRange="Sheet1!A1:C13",
|
|
x="0", y="0", width="12", height="18",
|
|
**{"plotArea.x": "0.15", "plotArea.y": "0.15",
|
|
"plotArea.w": "0.7", "plotArea.h": "0.7",
|
|
"title.x": "0.3", "title.y": "0.01",
|
|
"legend.x": "0.02", "legend.y": "0.4",
|
|
"legend.overlay": "true"}),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 2: Reversed axis, log scale, display units
|
|
# Features: logBase (logarithmic scale), axisOrientation=maxMin (reversed),
|
|
# dispUnits (thousands/millions)
|
|
# ------------------------------------------------------------------
|
|
chart("6-Layout",
|
|
chartType="bar",
|
|
title="Log Scale + Reversed Axis",
|
|
series1="Revenue:10,100,1000,10000",
|
|
categories="Startup,Small,Medium,Enterprise",
|
|
x="13", y="0", width="12", height="18",
|
|
logBase="10",
|
|
axisOrientation="maxMin",
|
|
dispUnits="thousands"),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 3: Label font, separator, leader lines, and per-label layout
|
|
# Features: labelFont (size:color:bold), dataLabels.separator,
|
|
# dataLabel{N}.text (custom), dataLabel{N}.delete (hide one label)
|
|
# ------------------------------------------------------------------
|
|
chart("6-Layout",
|
|
chartType="column",
|
|
title="Label Formatting",
|
|
series1="Sales:120,200,150,180",
|
|
categories="Q1,Q2,Q3,Q4",
|
|
x="0", y="19", width="12", height="18",
|
|
dataLabels="true", labelPos="outsideEnd",
|
|
labelFont="11:2E75B6:true",
|
|
**{"dataLabels.separator": ": ",
|
|
"dataLabel2.text": "Best!",
|
|
"dataLabel3.delete": "true"}),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 4: Error bars, minor ticks, opacity
|
|
# Features: errBars (percentage/stdDev/fixed), minorTickMark, opacity (0-100%)
|
|
# ------------------------------------------------------------------
|
|
chart("6-Layout",
|
|
chartType="line",
|
|
title="Error Bars + Ticks",
|
|
series1="Measurement:50,55,48,62,58",
|
|
categories="Mon,Tue,Wed,Thu,Fri",
|
|
x="13", y="19", width="12", height="18",
|
|
showMarkers="true", marker="square:7:4472C4",
|
|
errBars="percentage",
|
|
majorTickMark="outside", minorTickMark="inside",
|
|
opacity="80"),
|
|
])
|
|
|
|
# ======================================================================
|
|
# Sheet: 7-Effects
|
|
# Gradients, conditional color, area fill, title glow, preset themes
|
|
# ======================================================================
|
|
print("--- 7-Effects ---")
|
|
doc.batch([
|
|
add_sheet("7-Effects"),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 1: Per-series gradients
|
|
# Features: gradients (per-series, semicolon-separated "C1-C2:angle")
|
|
# ------------------------------------------------------------------
|
|
chart("7-Effects",
|
|
chartType="column",
|
|
title="Per-Series Gradients",
|
|
series1="East:120,135,148",
|
|
series2="West:110,118,130",
|
|
categories="Q1,Q2,Q3",
|
|
x="0", y="0", width="12", height="18",
|
|
gradients="4472C4-BDD7EE:90;ED7D31-FBE5D6:90"),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 2: Area fill gradient and title glow effect
|
|
# Features: areafill (area gradient), title.glow (color-radius-opacity)
|
|
# ------------------------------------------------------------------
|
|
chart("7-Effects",
|
|
chartType="area",
|
|
title="Glow Title + Area Fill",
|
|
dataRange="Sheet1!A1:C13",
|
|
x="13", y="0", width="12", height="18",
|
|
areafill="4472C4-BDD7EE:90",
|
|
transparency="30",
|
|
**{"title.glow": "4472C4-8-60", "title.size": "16"}),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 3: Conditional coloring rule
|
|
# Features: colorRule (threshold:belowColor:aboveColor — below 60 red, above green)
|
|
# ------------------------------------------------------------------
|
|
chart("7-Effects",
|
|
chartType="column",
|
|
title="Conditional Colors",
|
|
series1="Score:85,42,91,38,76,55",
|
|
categories="A,B,C,D,E,F",
|
|
x="0", y="19", width="12", height="18",
|
|
colorRule="60:FF0000:70AD47",
|
|
dataLabels="true", labelPos="outsideEnd"),
|
|
|
|
# ------------------------------------------------------------------
|
|
# Chart 4: Preset style/theme and leader lines
|
|
# Features: style (preset 1-48), dataLabels.showLeaderLines
|
|
# ------------------------------------------------------------------
|
|
chart("7-Effects",
|
|
chartType="column",
|
|
title="Preset Style 26",
|
|
dataRange="Sheet1!A1:E13",
|
|
x="13", y="19", width="12", height="18",
|
|
style="26",
|
|
dataLabels="true",
|
|
**{"dataLabels.showLeaderLines": "true"}),
|
|
])
|
|
|
|
doc.send({"command": "save"})
|
|
# context exit closes the resident, flushing the workbook to disk.
|
|
|
|
print(f"Generated: {FILE}")
|
|
print(" 8 sheets (Sheet1 data + 7 chart sheets, 28 charts total)")
|