mirrors / iofficeai--officecli

项目文件夹

iofficeai--officecli
文件
main
T
wehub-resource-sync 8cb1f9f479
Publish SDK (PyPI) / publish (push) Has been cancelled
详情
Publish SDK (npm) / publish (@aionui/officecli-sdk) (push) Has been cancelled
详情
SDK smoke / smoke (windows-latest) (push) Has been cancelled
详情
Publish SDK (npm) / publish (@officecli/officecli-sdk) (push) Has been cancelled
详情
Publish SDK (npm) / publish (@officecli/sdk) (push) Has been cancelled
详情
Publish SDK (npm) / publish (officecli-sdk) (push) Has been cancelled
详情
SDK smoke / smoke (macos-latest) (push) Has been cancelled
详情
SDK smoke / smoke (ubuntu-latest) (push) Has been cancelled
详情
Skill parity / diff (push) Has been cancelled
详情
chore: import upstream snapshot with attribution
2026-07-13 13:09:29 +08:00

672 行
28 KiB
Python
原始文件 永久链接 Blame 文件历史

#!/usr/bin/env python3
"""
Line Charts Showcase — line, lineStacked, linePercentStacked, and line3d with all variations.
Generates: charts-line.xlsx
Every line chart feature officecli supports is demonstrated at least once:
line styles, markers, smoothing, dash patterns, axis scaling, gridlines,
data labels, legend positioning, reference lines, secondary axis, error bars,
gradients, transparency, shadows, manual layout, data table, and 3D rotation.
9 sheets (Sheet1 data + 8 chart sheets), 32 charts total.
1-Line Fundamentals 4 charts — data input variants, markers, cell-range series
2-Line Styles 4 charts — lineWidth, lineDash, smooth, color palettes
3-Line Variants 4 charts — lineStacked, linePercentStacked, line3d
4-Axis & Gridlines 4 charts — axis scaling, log scale, reverse, tick marks
5-Labels & Legend 4 charts — data labels, custom labels, legend layout
6-Effects & Advanced 4 charts — shadows, gradients, secondary axis, reference lines
7-Line Elements 4 charts — drop lines, hi-low lines, up-down bars, 3D gap depth
8-Axis Extras 4 charts — crossesAt, dispBlanksAs, crosses=max
SDK twin of charts-line.sh (officecli CLI). Both produce an equivalent
charts-line.xlsx. This one drives the **officecli Python SDK**
(`pip install officecli-sdk`): one resident is started and every cell write and
chart is shipped over the named pipe via `doc.batch(...)` / `doc.send(...)`.
Each item is the same `{"command","parent"/"path","type","props"}` dict you'd
put in an `officecli batch` list.
Usage:
pip install officecli-sdk # plus the `officecli` binary on PATH
python3 charts-line.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-line.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, parented to the named sheet."""
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-Line Fundamentals
# ======================================================================
print("--- 1-Line Fundamentals ---")
items = [add_sheet("1-Line Fundamentals")]
# Chart 1: Basic line with inline named series and categories
# Features: chartType=line, inline series (series1=Name:v1,v2,...),
# categories, colors, catTitle, axisTitle, axisfont, gridlines
items.append(chart("1-Line Fundamentals",
chartType="line",
title="Quarterly Revenue",
series1="Product A:120,180,210,250",
series2="Product B:90,140,160,200",
series3="Product C:60,85,110,145",
categories="Q1,Q2,Q3,Q4",
colors="4472C4,ED7D31,70AD47",
x="0", y="0", width="12", height="18",
catTitle="Quarter", axisTitle="Revenue",
axisfont="9:C00000:Arial",
gridlines="D9D9D9:0.5:dot"))
# Chart 2: Line with cell-range series (dotted syntax) and markers
# Features: series.name/values/categories (cell range via dotted syntax),
# showMarkers, marker (style:size:color), minorGridlines
items.append(chart("1-Line Fundamentals",
chartType="line",
title="East Region Trend",
**{"series1.name": "East",
"series1.values": "Sheet1!B2:B13",
"series1.categories": "Sheet1!A2:A13"},
x="13", y="0", width="12", height="18",
showMarkers="true", marker="circle:6:2E75B6",
gridlines="D9D9D9:0.5:dot",
minorGridlines="EEEEEE:0.3:dot"))
# Chart 3: Line from dataRange with all four regions
# Features: dataRange (auto-reads headers as series names), marker=diamond,
# lineWidth, legend=bottom, legendfont
items.append(chart("1-Line Fundamentals",
chartType="line",
title="All Regions — Full Year",
dataRange="Sheet1!A1:E13",
x="0", y="19", width="12", height="18",
colors="2E75B6,70AD47,FFC000,C00000",
showMarkers="true", marker="diamond:5:333333",
lineWidth="2",
legend="bottom",
legendfont="9:58626E:Calibri"))
# Chart 4: Line with inline data shorthand and marker=none
# Features: data (inline shorthand Name:v1;Name2:v2), marker=none, legend=right
items.append(chart("1-Line Fundamentals",
chartType="line",
title="Simple Two-Series",
data="Actual:80,120,160,200,240;Target:100,130,160,190,220",
categories="Week 1,Week 2,Week 3,Week 4,Week 5",
colors="0070C0,FF0000",
x="13", y="19", width="12", height="18",
marker="none",
legend="right"))
doc.batch(items)
# ======================================================================
# Sheet: 2-Line Styles
# ======================================================================
print("--- 2-Line Styles ---")
items = [add_sheet("2-Line Styles")]
# Chart 1: Smooth line with thick width and shadow
# Features: smooth=true (Bezier curves), lineWidth=2.5, gridlines=none,
# axisVisible=false (hide both axes for sparkline-like minimal look),
# series.shadow (color-blur-angle-dist-opacity)
items.append(chart("2-Line Styles",
chartType="line",
title="Smooth Curves with Shadow",
dataRange="Sheet1!A1:E13",
x="0", y="0", width="12", height="18",
smooth="true", lineWidth="2.5",
colors="0070C0,00B050,FFC000,FF0000",
gridlines="none",
axisVisible="false",
**{"series.shadow": "000000-4-315-2-40"}))
# Chart 2: Dashed lines — all dash styles demonstrated
# Note: lineDash applies to ALL series. Supported values:
# solid, dot, dash, dashdot, longdash, longdashdot, longdashdotdot
# Features: lineDash (applied globally to all series), lineWidth
items.append(chart("2-Line Styles",
chartType="line",
title="Dash Pattern Gallery",
series1="solid:120,135,148,162,155",
series2="dot:95,108,115,128,142",
series3="dash:88,92,105,118,125",
series4="dashdot:110,118,130,145,138",
categories="Jan,Feb,Mar,Apr,May",
colors="2E75B6,ED7D31,70AD47,FFC000",
x="13", y="0", width="12", height="18",
lineDash="dash", lineWidth="2",
legend="bottom"))
# Chart 3: Multiple marker styles — circle, square, triangle, star
# Note: marker applies to ALL series. Supported styles:
# circle, diamond, square, triangle, star, x, plus, dash, dot, none
# Features: marker=square:7:color (style:size:fillColor),
# series.outline (white border around markers/lines)
items.append(chart("2-Line Styles",
chartType="line",
title="Marker Style Showcase",
dataRange="Sheet1!A1:E13",
x="0", y="19", width="12", height="18",
showMarkers="true", marker="square:7:4472C4",
lineWidth="1.5",
colors="4472C4,ED7D31,70AD47,FFC000",
**{"series.outline": "FFFFFF-0.5"}))
# Chart 4: Transparent lines with gradient plot area and styled title
# Features: transparency=30 (30% transparent), plotFill gradient,
# chartFill, title.font/size/color/bold, roundedCorners
items.append(chart("2-Line Styles",
chartType="line",
title="Translucent Lines on Gradient",
dataRange="Sheet1!A1:E13",
x="13", y="19", width="12", height="18",
lineWidth="3", smooth="true",
transparency="30",
plotFill="F0F4F8-D6E4F0:90",
chartFill="FFFFFF",
colors="1F4E79,2E75B6,5B9BD5,9DC3E6",
**{"title.font": "Georgia", "title.size": "14",
"title.color": "1F4E79", "title.bold": "true"},
roundedCorners="true"))
doc.batch(items)
# ======================================================================
# Sheet: 3-Line Variants
# ======================================================================
print("--- 3-Line Variants ---")
items = [add_sheet("3-Line Variants")]
# Chart 1: Stacked line chart
# Features: lineStacked (cumulative stacking), majorTickMark=outside, tickLabelPos=low
items.append(chart("3-Line Variants",
chartType="lineStacked",
title="Cumulative Sales by Region",
dataRange="Sheet1!A1:E13",
x="0", y="0", width="12", height="18",
catTitle="Month", axisTitle="Cumulative",
colors="4472C4,ED7D31,70AD47,FFC000",
majorTickMark="outside", tickLabelPos="low"))
# Chart 2: 100% stacked line chart with axis number format
# Features: linePercentStacked (each month sums to 100%),
# axisNumFmt (value axis number format)
items.append(chart("3-Line Variants",
chartType="linePercentStacked",
title="Regional Contribution %",
dataRange="Sheet1!A1:E13",
x="13", y="0", width="12", height="18",
colors="1F4E79,2E75B6,9DC3E6,BDD7EE",
axisNumFmt="0%",
legend="right",
gridlines="E0E0E0:0.5:solid"))
# Chart 3: 3D line chart with perspective
# Features: line3d (3D line chart), view3d (rotX,rotY,perspective),
# style/styleId (preset chart style 1-48)
items.append(chart("3-Line Variants",
chartType="line3d",
title="3D Regional Trends",
dataRange="Sheet1!A1:E13",
x="0", y="19", width="12", height="18",
view3d="15,20,30",
colors="4472C4,ED7D31,70AD47,FFC000",
chartFill="F8F8F8",
style="3"))
# Chart 4: Stacked line with area fill and data table
# Features: dataTable=true (show value table below chart),
# legend=none (hidden because data table shows series names)
items.append(chart("3-Line Variants",
chartType="lineStacked",
title="Stacked with Data Table",
dataRange="Sheet1!A1:E13",
x="13", y="19", width="12", height="18",
dataTable="true",
legend="none",
lineWidth="1.5",
colors="2E75B6,ED7D31,70AD47,FFC000",
plotFill="FAFAFA"))
doc.batch(items)
# ======================================================================
# Sheet: 4-Axis & Gridlines
# ======================================================================
print("--- 4-Axis & Gridlines ---")
items = [add_sheet("4-Axis & Gridlines")]
# Chart 1: Custom axis scaling — min, max, majorUnit
# Features: axisMin, axisMax, majorUnit, minorUnit,
# axisLine (value axis line styling — red), catAxisLine (category axis line — blue)
items.append(chart("4-Axis & Gridlines",
chartType="line",
title="Custom Axis Scale (80–220)",
dataRange="Sheet1!A1:E13",
x="0", y="0", width="12", height="18",
axisMin="80", axisMax="220", majorUnit="20",
minorUnit="10",
showMarkers="true", marker="circle:4:4472C4",
gridlines="D0D0D0:0.5:solid",
minorGridlines="EEEEEE:0.3:dot",
axisLine="C00000:1.5:solid",
catAxisLine="2E75B6:1.5:solid"))
doc.batch(items)
# Demonstrate chart-axis element (path: /SheetName/chart[N]/axis[@role=ROLE]).
# Properties: min, max, format, majorGridlines, labelRotation.
# These are the same semantics as axisMin/axisMax/gridlines/labelrotation at
# chart level but applied through the dedicated sub-element path, which also
# exposes role, dispUnits, majorUnit, title, visible, logBase.
doc.send({"command": "set",
"path": "/4-Axis & Gridlines/chart[1]/axis[@role=value]",
"props": {"min": "80", "max": "220",
"format": "#,##0",
"majorGridlines": "true",
"labelRotation": "0"}})
# Chart 2: Logarithmic scale with display units
# Features: logBase=10 (logarithmic scale), marker=triangle
items = [chart("4-Axis & Gridlines",
chartType="line",
title="Exponential Growth (Log Scale)",
series1="Growth:1,5,25,125,625,3125",
categories="Year 1,Year 2,Year 3,Year 4,Year 5,Year 6",
x="13", y="0", width="12", height="18",
logBase="10",
colors="C00000",
lineWidth="2.5",
showMarkers="true", marker="triangle:7:C00000",
axisTitle="Value (log)",
catTitle="Year",
gridlines="E0E0E0:0.5:dash")]
# Chart 3: Reversed axis and hidden axes
# Features: axisReverse=true (value axis direction flipped), smooth + markers together
items.append(chart("4-Axis & Gridlines",
chartType="line",
title="Reversed Value Axis",
series1="Depth:0,50,120,200,350,500",
categories="Station A,Station B,Station C,Station D,Station E,Station F",
x="0", y="19", width="12", height="18",
axisReverse="true",
colors="0070C0",
lineWidth="2",
showMarkers="true", marker="diamond:6:0070C0",
smooth="true",
axisTitle="Depth (m)",
gridlines="D9D9D9:0.5:solid"))
# Chart 4: Display units and tick mark styles
# Features: dispUnits=thousands (display units label),
# majorTickMark=outside, minorTickMark=inside, marker=star
items.append(chart("4-Axis & Gridlines",
chartType="line",
title="Revenue (in Thousands)",
series1="Revenue:12000,18500,22000,31000,45000,52000",
series2="Cost:8000,11000,14000,19500,28000,33000",
categories="2020,2021,2022,2023,2024,2025",
x="13", y="19", width="12", height="18",
dispUnits="thousands",
colors="2E75B6,C00000",
lineWidth="2",
majorTickMark="outside", minorTickMark="inside",
showMarkers="true", marker="star:7:2E75B6",
catTitle="Year", axisTitle="Amount (K)"))
doc.batch(items)
# ======================================================================
# Sheet: 5-Labels & Legend
# ======================================================================
print("--- 5-Labels & Legend ---")
items = [add_sheet("5-Labels & Legend")]
# Chart 1: Data labels at various positions with number format
# Features: dataLabels=true, labelPos=top, labelFont (size:color:bold),
# dataLabels.numFmt (number format), dataLabels.separator
items.append(chart("5-Labels & Legend",
chartType="line",
title="Sales with Labels",
series1="Revenue:120,180,210,250,280",
categories="Jan,Feb,Mar,Apr,May",
x="0", y="0", width="12", height="18",
colors="4472C4",
lineWidth="2",
showMarkers="true", marker="circle:6:4472C4",
dataLabels="true", labelPos="top",
labelFont="9:333333:true",
**{"dataLabels.numFmt": "#,##0",
"dataLabels.separator": ": "}))
# Chart 2: Custom individual data labels (highlight peak)
# Features: dataLabel{N}.delete (hide specific labels),
# dataLabel{N}.text (custom text on specific point),
# point{N}.color (highlight individual data point marker in red),
# dataLabel{N}.y (manual vertical position of individual label, 0-1 fraction)
items.append(chart("5-Labels & Legend",
chartType="line",
title="Peak Highlight",
series1="Sales:88,120,165,210,195,178",
categories="Jan,Feb,Mar,Apr,May,Jun",
x="13", y="0", width="12", height="18",
colors="2E75B6",
lineWidth="2.5", smooth="true",
showMarkers="true", marker="circle:5:2E75B6",
dataLabels="true", labelPos="top",
**{"dataLabel1.delete": "true", "dataLabel2.delete": "true",
"point4.color": "C00000",
"dataLabel4.text": "Peak: 210",
"dataLabel4.y": "0.15",
"dataLabel5.delete": "true", "dataLabel6.delete": "true"}))
# Chart 3: Legend positioning and overlay
# Features: legend=top, legend.overlay=true (legend overlays chart area),
# legendfont (size:color:fontname)
items.append(chart("5-Labels & Legend",
chartType="line",
title="Legend Overlay on Chart",
dataRange="Sheet1!A1:E13",
x="0", y="19", width="12", height="18",
colors="4472C4,ED7D31,70AD47,FFC000",
lineWidth="2",
legend="top",
**{"legend.overlay": "true"},
legendfont="10:1F4E79:Calibri",
plotFill="F5F5F5"))
# Chart 4: Manual layout — plotArea, title, and legend positioning
# Features: plotArea.x/y/w/h (plot area manual layout, 0-1 fraction),
# title.x/y (title position), legend.x/y/w/h (legend position/size)
items.append(chart("5-Labels & Legend",
chartType="line",
title="Manual Layout Control",
dataRange="Sheet1!A1:E13",
x="13", y="19", width="12", height="18",
colors="2E75B6,ED7D31,70AD47,FFC000",
lineWidth="1.5",
**{"plotArea.x": "0.12", "plotArea.y": "0.18",
"plotArea.w": "0.82", "plotArea.h": "0.55",
"title.x": "0.25", "title.y": "0.02",
"legend.x": "0.15", "legend.y": "0.82",
"legend.w": "0.7", "legend.h": "0.12",
"title.font": "Arial", "title.size": "13",
"title.bold": "true"}))
doc.batch(items)
# ======================================================================
# Sheet: 6-Effects & Advanced
# ======================================================================
print("--- 6-Effects & Advanced ---")
items = [add_sheet("6-Effects & Advanced")]
# Chart 1: Secondary axis — two series on different scales
# Features: secondaryAxis=2 (series 2 on right-hand axis), dual-scale visualization
items.append(chart("6-Effects & Advanced",
chartType="line",
title="Revenue vs Growth Rate",
series1="Revenue:120,180,250,310,380,420",
series2="Growth %:50,33,39,24,23,11",
categories="2020,2021,2022,2023,2024,2025",
x="0", y="0", width="12", height="18",
secondaryAxis="2",
colors="2E75B6,C00000",
lineWidth="2.5",
showMarkers="true", marker="circle:6:2E75B6",
catTitle="Year", axisTitle="Revenue",
dataLabels="true", labelPos="top"))
# Chart 2: Reference line (target/threshold) with error bars
# referenceLine format: value:color:width:dash
# - value: the threshold/target value on the Y axis
# - color: hex RGB (no #)
# - width: line thickness in pt (default 1.5)
# - dash: solid/dot/dash/dashdot/longdash
# Features: referenceLine (horizontal target line), lineDash=longdash
items.append(chart("6-Effects & Advanced",
chartType="line",
title="vs Target (150)",
dataRange="Sheet1!A1:C13",
x="13", y="0", width="12", height="18",
colors="4472C4,70AD47",
lineWidth="1.5",
referenceLine="150:FF0000:1.5:dash",
showMarkers="true", marker="circle:4:4472C4",
legend="bottom",
lineDash="longdash"))
# Chart 3: Title glow/shadow effects with per-series gradients
# Features: title.glow (color-radius-opacity), title.shadow,
# series.shadow on line charts, plotFill + chartFill
items.append(chart("6-Effects & Advanced",
chartType="line",
title="Glow & Shadow Effects",
series1="East:120,135,148,162,155,178",
series2="West:110,118,130,145,138,162",
categories="Jan,Feb,Mar,Apr,May,Jun",
x="0", y="19", width="12", height="18",
lineWidth="3", smooth="true",
colors="4472C4,ED7D31",
**{"title.glow": "4472C4-8-60",
"title.shadow": "000000-3-315-2-40",
"title.font": "Calibri", "title.size": "16",
"title.bold": "true", "title.color": "1F4E79",
"series.shadow": "000000-3-315-1-30"},
plotFill="F0F4F8", chartFill="FFFFFF"))
# Chart 4: Conditional coloring with chart/plot borders
# colorRule format: threshold:belowColor:aboveColor
# - values below 0 → red (C00000), above 0 → green (70AD47)
# Features: colorRule (threshold-based conditional coloring),
# chartArea.border, plotArea.border, referenceLine=0 (zero line)
items.append(chart("6-Effects & Advanced",
chartType="line",
title="Conditional Colors & Borders",
series1="Profit:80,120,-30,160,-50,200,140,-20,180,90",
categories="Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct",
x="13", y="19", width="12", height="18",
colors="2E75B6",
lineWidth="2",
showMarkers="true", marker="circle:6:2E75B6",
colorRule="0:C00000:70AD47",
referenceLine="0:888888:1:solid",
**{"chartArea.border": "D0D0D0:1:solid",
"plotArea.border": "E0E0E0:0.5:dot"},
dataLabels="true", labelPos="top",
labelFont="8:666666:false"))
doc.batch(items)
# ======================================================================
# Sheet: 7-Line Elements
# ======================================================================
print("--- 7-Line Elements ---")
items = [add_sheet("7-Line Elements")]
# Chart 1: Drop lines — vertical lines from data points to category axis
# Features: dropLines=true (simple toggle — default thin gray lines)
items.append(chart("7-Line Elements",
chartType="line",
title="Drop Lines",
dataRange="Sheet1!A1:C13",
x="0", y="0", width="12", height="18",
colors="4472C4,ED7D31",
showMarkers="true", marker="circle:5:4472C4",
dropLines="true",
legend="bottom"))
# Chart 2: High-low lines — connect highest and lowest series at each point
# Features: hiLowLines=true (lines connecting highest and lowest values)
items.append(chart("7-Line Elements",
chartType="line",
title="High-Low Lines",
series1="High:210,195,220,240,230,250",
series2="Low:150,135,160,170,155,180",
categories="Jan,Feb,Mar,Apr,May,Jun",
x="13", y="0", width="12", height="18",
colors="2E75B6,C00000",
showMarkers="true", marker="diamond:5:2E75B6",
hiLowLines="true",
legend="bottom"))
# Chart 3: Up-down bars with custom colors — show gain/loss between series
# updownbars format: gapWidth:upColor:downColor
# - gapWidth: gap between bars (0-500, default 150)
# - upColor: fill color for increase (Close > Open)
# - downColor: fill color for decrease (Close < Open)
# Features: updownbars with custom colors (gain=green, loss=red)
items.append(chart("7-Line Elements",
chartType="line",
title="Up-Down Bars (Gain/Loss)",
series1="Open:120,135,148,130,155,162",
series2="Close:135,128,162,145,170,155",
categories="Mon,Tue,Wed,Thu,Fri,Sat",
x="0", y="19", width="12", height="18",
colors="4472C4,ED7D31",
showMarkers="true", marker="circle:4:4472C4",
updownbars="100:70AD47:C00000",
legend="bottom"))
# Chart 4: Auto markers + 3D line with gapDepth
# Features: gapDepth=300 (3D depth spacing, 0-500), line3d with custom perspective
items.append(chart("7-Line Elements",
chartType="line3d",
title="3D Line with Gap Depth",
dataRange="Sheet1!A1:E13",
x="13", y="19", width="12", height="18",
view3d="15,25,30",
gapDepth="300",
colors="4472C4,ED7D31,70AD47,FFC000",
chartFill="F5F5F5"))
doc.batch(items)
# ======================================================================
# Sheet: 8-Axis Extras
# ======================================================================
print("--- 8-Axis Extras ---")
items = [add_sheet("8-Axis Extras")]
# Chart 1: crossesAt — value axis crosses category axis at specific value
# Features: crossesAt=50 (value axis crosses the category axis at y=50,
# so bars/lines below 50 appear below the midline — great for threshold viz)
items.append(chart("8-Axis Extras",
chartType="line",
title="crossesAt — axis baseline at 50",
series1="Score:40,65,55,80,45,90,70",
categories="Jan,Feb,Mar,Apr,May,Jun,Jul",
colors="2E75B6",
x="0", y="0", width="12", height="18",
crossesAt="50",
lineWidth="2", marker="circle", markerSize="6"))
# Chart 2: dispBlanksAs — how missing/null data points are rendered
# Features: dispBlanksAs=span (connect across null/blank data points with a
# straight line — see also: gap=leave hole, zero=plot blank as 0)
items.append(chart("8-Axis Extras",
chartType="line",
title="dispBlanksAs=span (connect gaps)",
series1="Revenue:100,120,130,150,160",
categories="Jan,Feb,Mar,Apr,May",
colors="548235",
x="13", y="0", width="12", height="18",
dispBlanksAs="span",
lineWidth="2", marker="circle", markerSize="6"))
# Chart 3: dispBlanksAs=zero + crossesAt=0
# Features: dispBlanksAs=zero (missing cells rendered as zero),
# crossesAt=0 (axis crosses at y=0 — default for most charts).
# Note: dispBlanksAs affects rendering when the data source has blank cells;
# here it is shown as a metadata property on the chart (also accepts: gap, span).
items.append(chart("8-Axis Extras",
chartType="line",
title="dispBlanksAs=zero + crossesAt=0",
series1="Revenue:100,120,130,150,160",
categories="Jan,Feb,Mar,Apr,May",
colors="C00000",
x="0", y="19", width="12", height="18",
dispBlanksAs="zero",
crossesAt="0",
lineWidth="2", marker="circle", markerSize="6"))
# Chart 4: crosses=max (value axis on right side of plot)
# Features: crosses=max (value axis appears at the far end of the category
# axis — i.e. on the right side for a left-to-right chart; also: autoZero,
# min for the left/bottom edge)
items.append(chart("8-Axis Extras",
chartType="line",
title="crosses=max (value axis at far end)",
series1="Index:45,60,52,75,80,68,90",
categories="Mon,Tue,Wed,Thu,Fri,Sat,Sun",
colors="7030A0",
x="13", y="19", width="12", height="18",
crosses="max",
lineWidth="2"))
doc.batch(items)
doc.send({"command": "save"})
# context exit closes the resident, flushing the workbook to disk.
print(f"Generated: {FILE}")
print(" 9 sheets (Sheet1 data + 8 chart sheets, 32 charts total)")
在新工单中引用 查看 Git Blame 复制永久链接