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
271 lines
12 KiB
Bash
Executable File
271 lines
12 KiB
Bash
Executable File
#!/bin/bash
|
|
# Word Charts Showcase — every docx chart family, embedded inline in a document.
|
|
# CLI twin of charts.py (officecli Python SDK). Both produce an equivalent
|
|
# charts.docx.
|
|
#
|
|
# In Word a chart is an INLINE DrawingML object anchored on a paragraph. You
|
|
# add it with `add <file> /body/p[N] --type chart ...`, giving the chart its
|
|
# data inline (data=/series{N}=/categories=) — Word has no worksheet grid to
|
|
# pull a dataRange from, so inline data is the idiomatic path here. The chart
|
|
# is then addressed document-globally as `/chart[M]` for get/set/query (NOT
|
|
# `/body/p[N]/chart[M]`).
|
|
#
|
|
# Every meaningful docx chart family is demonstrated at least once:
|
|
# chart types (column/bar/line/pie/area/scatter/radar/doughnut/stock/combo
|
|
# plus extended cx types funnel/treemap/waterfall), titles & title styling,
|
|
# legend, data labels, colors & gradients (areafill), axis scaling/styling,
|
|
# display units, radar style, rounded corners, markers, and transparency.
|
|
#
|
|
# 14 charts, each under its own heading paragraph.
|
|
#
|
|
# Usage:
|
|
# ./charts.sh
|
|
# NOTE: intentionally NO `set -e`. Like the SDK twin's doc.batch, this script
|
|
# tolerates forward-compat 'UNSUPPORTED props' warnings (officecli exit 2) and
|
|
# keeps building so the full document is produced.
|
|
FILE="$(dirname "$0")/charts.docx"
|
|
rm -f "$FILE"
|
|
|
|
officecli create "$FILE"
|
|
officecli open "$FILE"
|
|
|
|
# Every chart anchors on its own body paragraph. We keep a running 1-based
|
|
# paragraph index ($P) so each chart's anchor path (/body/p[$P]) is explicit.
|
|
# Layout per demo: one Heading2 paragraph, then one empty body paragraph that
|
|
# hosts the inline chart. Charts are read back via the flat /chart[N] path.
|
|
P=0
|
|
heading() { officecli add "$FILE" /body --type paragraph --prop text="$1" --prop style=Heading2; P=$((P+1)); }
|
|
host() { officecli add "$FILE" /body --type paragraph --prop text=""; P=$((P+1)); }
|
|
|
|
# Title + intro (p[1], p[2])
|
|
officecli add "$FILE" /body --type paragraph --prop text="Word Charts Showcase" --prop style=Heading1 --prop align=center; P=$((P+1))
|
|
officecli add "$FILE" /body --type paragraph --prop text="Each chart below is an inline DrawingML object anchored on its own paragraph. Charts are addressed document-globally as /chart[N]."; P=$((P+1))
|
|
|
|
# ==========================================================================
|
|
# 1. Column — the workhorse. Axis titles, axis scaling, gridlines, colors.
|
|
# ==========================================================================
|
|
heading "1. Column — axis titles, scaling & gridlines"; host
|
|
# Features: chartType=column, data (inline Name:v;Name2:v), categories, colors,
|
|
# catTitle/axisTitle, axisMin/axisMax/axisNumFmt, gridlines, legend, width/height
|
|
officecli add "$FILE" "/body/p[$P]" --type chart \
|
|
--prop chartType=column \
|
|
--prop title="Quarterly Revenue by Region" \
|
|
--prop 'data=East:120,135,148,162;West:110,118,130,145;South:95,108,115,128' \
|
|
--prop categories="Q1,Q2,Q3,Q4" \
|
|
--prop colors=4472C4,ED7D31,70AD47 \
|
|
--prop catTitle=Quarter --prop axisTitle="Revenue (K)" \
|
|
--prop axisMin=0 --prop axisMax=200 --prop axisNumFmt="#,##0" \
|
|
--prop gridlines=D9D9D9:0.5:dot \
|
|
--prop legend=bottom \
|
|
--prop width=16cm --prop height=9cm
|
|
|
|
# ==========================================================================
|
|
# 2. Bar — horizontal columns with gap width & data labels.
|
|
# ==========================================================================
|
|
heading "2. Bar — gap width & data labels"; host
|
|
# Features: chartType=bar, gapwidth, dataLabels=value, labelPos=outsideEnd, labelfont
|
|
officecli add "$FILE" "/body/p[$P]" --type chart \
|
|
--prop chartType=bar \
|
|
--prop title="Product Units Sold" \
|
|
--prop 'data=Units:320,280,410,190,360' \
|
|
--prop categories="Laptop,Phone,Tablet,Watch,Buds" \
|
|
--prop colors=2E75B6 \
|
|
--prop gapwidth=80 \
|
|
--prop dataLabels=value --prop labelPos=outsideEnd \
|
|
--prop labelfont=9:333333:Calibri \
|
|
--prop legend=none \
|
|
--prop width=16cm --prop height=9cm
|
|
|
|
# ==========================================================================
|
|
# 3. Line — markers, smoothing, drop lines.
|
|
# ==========================================================================
|
|
heading "3. Line — markers, smoothing & drop lines"; host
|
|
# Features: chartType=line, marker (symbol:size), smooth, droplines, linewidth
|
|
officecli add "$FILE" "/body/p[$P]" --type chart \
|
|
--prop chartType=line \
|
|
--prop title="Monthly Active Users" \
|
|
--prop 'data=2023:120,180,210,250,280,310;2024:150,220,260,300,340,380' \
|
|
--prop categories="Jan,Feb,Mar,Apr,May,Jun" \
|
|
--prop colors=4472C4,ED7D31 \
|
|
--prop marker=circle:6 \
|
|
--prop smooth=true \
|
|
--prop droplines=808080:0.5 \
|
|
--prop linewidth=2 \
|
|
--prop legend=bottom \
|
|
--prop width=16cm --prop height=9cm
|
|
|
|
# ==========================================================================
|
|
# 4. Pie — percent labels, slice explosion, first-slice angle.
|
|
# ==========================================================================
|
|
heading "4. Pie — percent labels & slice explosion"; host
|
|
# Features: chartType=pie, dataLabels=percent, explosion, firstSliceAngle, colors
|
|
officecli add "$FILE" "/body/p[$P]" --type chart \
|
|
--prop chartType=pie \
|
|
--prop title="Market Share" \
|
|
--prop 'data=Share:42,28,18,12' \
|
|
--prop categories="Alpha,Beta,Gamma,Other" \
|
|
--prop colors=4472C4,ED7D31,70AD47,FFC000 \
|
|
--prop dataLabels=percent \
|
|
--prop explosion=8 \
|
|
--prop firstSliceAngle=90 \
|
|
--prop legend=right \
|
|
--prop width=14cm --prop height=9cm
|
|
|
|
# ==========================================================================
|
|
# 5. Area — gradient fill via areafill (docx-specific shortcut).
|
|
# ==========================================================================
|
|
heading "5. Area — gradient fill (areafill)"; host
|
|
# Features: chartType=area, areafill=c1-c2:angle (gradient applied to every series shape)
|
|
officecli add "$FILE" "/body/p[$P]" --type chart \
|
|
--prop chartType=area \
|
|
--prop title="Cumulative Traffic" \
|
|
--prop 'data=Visits:20,35,30,55,48,70,65' \
|
|
--prop categories="Mon,Tue,Wed,Thu,Fri,Sat,Sun" \
|
|
--prop areafill=4472C4-A5C8FF:90 \
|
|
--prop gridlines=E0E0E0:0.5:solid \
|
|
--prop legend=none \
|
|
--prop width=16cm --prop height=9cm
|
|
|
|
# ==========================================================================
|
|
# 6. Scatter — XY scatter with smoothed-marker style.
|
|
# ==========================================================================
|
|
heading "6. Scatter — smoothMarker style"; host
|
|
# Features: chartType=scatter, scatterstyle=smoothMarker, marker, catTitle/axisTitle
|
|
officecli add "$FILE" "/body/p[$P]" --type chart \
|
|
--prop chartType=scatter \
|
|
--prop title="Load vs Response Time" \
|
|
--prop series1="Latency:12,18,27,41,60,88" \
|
|
--prop categories="10,20,40,80,160,320" \
|
|
--prop scatterstyle=smoothMarker \
|
|
--prop marker=diamond:7:C00000 \
|
|
--prop catTitle="Concurrent Users" --prop axisTitle="ms" \
|
|
--prop legend=none \
|
|
--prop width=16cm --prop height=9cm
|
|
|
|
# ==========================================================================
|
|
# 7. Radar — filled radar style (radarstyle docx shortcut).
|
|
# ==========================================================================
|
|
heading "7. Radar — filled style (radarstyle)"; host
|
|
# Features: chartType=radar, radarstyle=filled, multi-series, transparency
|
|
officecli add "$FILE" "/body/p[$P]" --type chart \
|
|
--prop chartType=radar \
|
|
--prop title="Product Comparison" \
|
|
--prop 'data=Model A:4,5,3,4,5;Model B:5,3,4,5,3' \
|
|
--prop categories="Speed,Battery,Camera,Price,Display" \
|
|
--prop radarstyle=filled \
|
|
--prop colors=4472C4,ED7D31 \
|
|
--prop transparency=40 \
|
|
--prop legend=bottom \
|
|
--prop width=14cm --prop height=10cm
|
|
|
|
# ==========================================================================
|
|
# 8. Doughnut — hole size & percent labels.
|
|
# ==========================================================================
|
|
heading "8. Doughnut — hole size & percent labels"; host
|
|
# Features: chartType=doughnut, holeSize, dataLabels=percent, colors
|
|
officecli add "$FILE" "/body/p[$P]" --type chart \
|
|
--prop chartType=doughnut \
|
|
--prop title="Budget Allocation" \
|
|
--prop 'data=Budget:35,25,20,20' \
|
|
--prop categories="R&D,Sales,Ops,Admin" \
|
|
--prop holeSize=55 \
|
|
--prop dataLabels=percent \
|
|
--prop colors=4472C4,ED7D31,70AD47,FFC000 \
|
|
--prop legend=right \
|
|
--prop width=14cm --prop height=9cm
|
|
|
|
# ==========================================================================
|
|
# 9. Stock — high/low/close (OHLC-style) series.
|
|
# ==========================================================================
|
|
heading "9. Stock — high / low / close series"; host
|
|
# Features: chartType=stock, three ordered series (High, Low, Close), hilowlines
|
|
officecli add "$FILE" "/body/p[$P]" --type chart \
|
|
--prop chartType=stock \
|
|
--prop title="Share Price (5 Days)" \
|
|
--prop series1="High:32,35,34,38,37" \
|
|
--prop series2="Low:28,29,30,32,33" \
|
|
--prop series3="Close:30,34,31,37,35" \
|
|
--prop categories="Mon,Tue,Wed,Thu,Fri" \
|
|
--prop hilowlines=true \
|
|
--prop legend=bottom \
|
|
--prop width=16cm --prop height=9cm
|
|
|
|
# ==========================================================================
|
|
# 10. Combo — mixed column + line on a secondary axis.
|
|
# ==========================================================================
|
|
heading "10. Combo — column + line on secondary axis"; host
|
|
# Features: chartType=combo, combotypes=column,line, secondaryaxis=2
|
|
officecli add "$FILE" "/body/p[$P]" --type chart \
|
|
--prop chartType=combo \
|
|
--prop title="Revenue vs Growth Rate" \
|
|
--prop series1="Revenue:120,180,250,310,380" \
|
|
--prop series2="Growth %:50,33,39,24,23" \
|
|
--prop categories="2021,2022,2023,2024,2025" \
|
|
--prop combotypes="column,line" \
|
|
--prop secondaryaxis=2 \
|
|
--prop colors=2E75B6,C00000 \
|
|
--prop legend=bottom \
|
|
--prop width=16cm --prop height=9cm
|
|
|
|
# ==========================================================================
|
|
# 11. Column with display units & rounded chart corners + title styling.
|
|
# ==========================================================================
|
|
heading "11. Column — display units & rounded corners"; host
|
|
# Features: dispUnits=thousands, roundedcorners=true, chartFill, title.font/size/color/bold
|
|
officecli add "$FILE" "/body/p[$P]" --type chart \
|
|
--prop chartType=column \
|
|
--prop title="Revenue (in Thousands)" \
|
|
--prop 'data=Revenue:12000,18500,22000,31000,45000' \
|
|
--prop categories="2021,2022,2023,2024,2025" \
|
|
--prop colors=1F4E79 \
|
|
--prop dispUnits=thousands \
|
|
--prop axisNumFmt="#,##0" \
|
|
--prop roundedcorners=true \
|
|
--prop chartFill=F8F8F8 \
|
|
--prop title.font=Georgia --prop title.size=15 --prop title.color=1F4E79 --prop title.bold=true \
|
|
--prop legend=none \
|
|
--prop width=16cm --prop height=9cm
|
|
|
|
# ==========================================================================
|
|
# 12. Funnel — extended cx chart type.
|
|
# ==========================================================================
|
|
heading "12. Funnel — extended (cx) chart"; host
|
|
# Features: chartType=funnel (extended cx:chart), single-series stage breakdown
|
|
officecli add "$FILE" "/body/p[$P]" --type chart \
|
|
--prop chartType=funnel \
|
|
--prop title="Sales Funnel" \
|
|
--prop 'data=Stage:1000,720,430,210,95' \
|
|
--prop categories="Visitors,Leads,MQL,SQL,Won" \
|
|
--prop width=16cm --prop height=9cm
|
|
|
|
# ==========================================================================
|
|
# 13. Treemap — extended cx chart type.
|
|
# ==========================================================================
|
|
heading "13. Treemap — extended (cx) chart"; host
|
|
# Features: chartType=treemap (extended cx:chart), proportional area tiles
|
|
officecli add "$FILE" "/body/p[$P]" --type chart \
|
|
--prop chartType=treemap \
|
|
--prop title="Storage by File Type" \
|
|
--prop 'data=Size:420,310,180,90,45' \
|
|
--prop categories="Video,Images,Docs,Audio,Other" \
|
|
--prop width=16cm --prop height=9cm
|
|
|
|
# ==========================================================================
|
|
# 14. Waterfall — extended cx chart with increase/decrease/total colors.
|
|
# ==========================================================================
|
|
heading "14. Waterfall — increase / decrease / total colors"; host
|
|
# Features: chartType=waterfall, increaseColor, decreaseColor, totalColor (all add-time)
|
|
officecli add "$FILE" "/body/p[$P]" --type chart \
|
|
--prop chartType=waterfall \
|
|
--prop title="Cash Flow" \
|
|
--prop 'data=Cash:100,-30,50,-20,80' \
|
|
--prop categories="Start,Q1,Q2,Q3,End" \
|
|
--prop increaseColor=00AA00 \
|
|
--prop decreaseColor=C00000 \
|
|
--prop totalColor=4472C4 \
|
|
--prop width=16cm --prop height=9cm
|
|
|
|
officecli close "$FILE"
|
|
officecli validate "$FILE"
|
|
echo "Generated: $FILE"
|