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
194 lines
12 KiB
Bash
Executable File
194 lines
12 KiB
Bash
Executable File
#!/bin/bash
|
|
# Excel Shapes Gallery — generates shapes.xlsx exercising the xlsx `shape`
|
|
# property surface (officecli help xlsx shape).
|
|
#
|
|
# CLI twin of shapes.py (officecli Python SDK). Both produce an equivalent
|
|
# shapes.xlsx: a single "Gallery" sheet laid out as a shape gallery — each
|
|
# demo shape sits in a readable grid with a label cell above it.
|
|
#
|
|
# Shapes are anchored with cell-unit x/y/width/height (TwoCellAnchor
|
|
# column/row indices — NOT points/inches). Get reads position back as those
|
|
# same integer indices.
|
|
#
|
|
# Usage: ./shapes.sh [officecli path]
|
|
# 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.
|
|
CLI="${1:-officecli}"
|
|
FILE="$(dirname "$0")/shapes.xlsx"
|
|
|
|
rm -f "$FILE"
|
|
$CLI create "$FILE"
|
|
$CLI open "$FILE"
|
|
|
|
# Title cell + column widths so labels are legible.
|
|
$CLI set "$FILE" /Sheet1/A1 --prop value="Excel Shapes Gallery" --prop font.bold=true --prop font.size=16 --prop fill=1F4E79 --prop font.color=FFFFFF
|
|
$CLI set "$FILE" /Sheet1/A2 --prop value="Each shape sits below its label. Shapes are cell-anchored (x/y/width/height in column/row units)." --prop font.italic=true --prop font.color=595959
|
|
|
|
# Label helper cells sit on a header row above each shape band.
|
|
# Band 1 labels (row 4), shapes span rows 5-8.
|
|
$CLI set "$FILE" /Sheet1/A4 --prop value="geometry=rect" --prop font.bold=true
|
|
$CLI set "$FILE" /Sheet1/D4 --prop value="geometry=roundRect" --prop font.bold=true
|
|
$CLI set "$FILE" /Sheet1/G4 --prop value="geometry=ellipse" --prop font.bold=true
|
|
$CLI set "$FILE" /Sheet1/J4 --prop value="geometry=triangle" --prop font.bold=true
|
|
|
|
# ─────────────────────────────────────────────────────────────────────────────
|
|
# Band 1 — Geometry preset gallery (solid theme-accent fill, white text)
|
|
# ─────────────────────────────────────────────────────────────────────────────
|
|
# Features: geometry=rect, solid fill, text, color, bold, valign
|
|
$CLI add "$FILE" /Sheet1 --type shape --prop geometry=rect \
|
|
--prop x=0 --prop y=4 --prop width=2 --prop height=3 \
|
|
--prop fill=4472C4 --prop text="rect" --prop color=FFFFFF --prop bold=true
|
|
|
|
# Features: geometry=roundRect
|
|
$CLI add "$FILE" /Sheet1 --type shape --prop geometry=roundRect \
|
|
--prop x=3 --prop y=4 --prop width=2 --prop height=3 \
|
|
--prop fill=2A9D8F --prop text="roundRect" --prop color=FFFFFF --prop bold=true
|
|
|
|
# Features: geometry=ellipse
|
|
$CLI add "$FILE" /Sheet1 --type shape --prop geometry=ellipse \
|
|
--prop x=6 --prop y=4 --prop width=2 --prop height=3 \
|
|
--prop fill=E76F51 --prop text="ellipse" --prop color=FFFFFF --prop bold=true
|
|
|
|
# Features: geometry=triangle
|
|
$CLI add "$FILE" /Sheet1 --type shape --prop geometry=triangle \
|
|
--prop x=9 --prop y=4 --prop width=2 --prop height=3 \
|
|
--prop fill=E9C46A --prop text="triangle" --prop color=264653 --prop bold=true
|
|
|
|
# Band 2 labels (row 9), shapes span rows 10-13.
|
|
$CLI set "$FILE" /Sheet1/A9 --prop value="geometry=diamond" --prop font.bold=true
|
|
$CLI set "$FILE" /Sheet1/D9 --prop value="geometry=parallelogram" --prop font.bold=true
|
|
$CLI set "$FILE" /Sheet1/G9 --prop value="geometry=rightArrow" --prop font.bold=true
|
|
$CLI set "$FILE" /Sheet1/J9 --prop value="geometry=star5 (name=MyStar)" --prop font.bold=true
|
|
|
|
# Features: geometry=diamond
|
|
$CLI add "$FILE" /Sheet1 --type shape --prop geometry=diamond \
|
|
--prop x=0 --prop y=9 --prop width=2 --prop height=3 \
|
|
--prop fill=8E44AD --prop text="diamond" --prop color=FFFFFF --prop bold=true
|
|
|
|
# Features: geometry=parallelogram
|
|
$CLI add "$FILE" /Sheet1 --type shape --prop geometry=parallelogram \
|
|
--prop x=3 --prop y=9 --prop width=2 --prop height=3 \
|
|
--prop fill=457B9D --prop text="parallelogram" --prop color=FFFFFF --prop bold=true
|
|
|
|
# Features: geometry=rightArrow
|
|
$CLI add "$FILE" /Sheet1 --type shape --prop geometry=rightArrow \
|
|
--prop x=6 --prop y=9 --prop width=2 --prop height=3 \
|
|
--prop fill=F4A261 --prop text="rightArrow" --prop color=264653 --prop bold=true
|
|
|
|
# Features: geometry=star5, name (override cNvPr @name)
|
|
$CLI add "$FILE" /Sheet1 --type shape --prop geometry=star5 \
|
|
--prop x=9 --prop y=9 --prop width=2 --prop height=3 \
|
|
--prop fill=E63946 --prop name=MyStar
|
|
|
|
# Band 3 labels (row 14), shapes span rows 15-18.
|
|
$CLI set "$FILE" /Sheet1/A14 --prop value="flipH=true (mirrored arrow)" --prop font.bold=true
|
|
$CLI set "$FILE" /Sheet1/D14 --prop value="flipV=true" --prop font.bold=true
|
|
$CLI set "$FILE" /Sheet1/G14 --prop value="flipBoth=true" --prop font.bold=true
|
|
$CLI set "$FILE" /Sheet1/J14 --prop value="rotation=30" --prop font.bold=true
|
|
|
|
# ─────────────────────────────────────────────────────────────────────────────
|
|
# Band 3 — Flips & rotation
|
|
# ─────────────────────────────────────────────────────────────────────────────
|
|
# Features: flipH (horizontal mirror; Office-API alias of flip=h)
|
|
$CLI add "$FILE" /Sheet1 --type shape --prop geometry=rightArrow \
|
|
--prop x=0 --prop y=14 --prop width=2 --prop height=3 \
|
|
--prop fill=4472C4 --prop flipH=true
|
|
|
|
# Features: flipV (vertical mirror)
|
|
$CLI add "$FILE" /Sheet1 --type shape --prop geometry=triangle \
|
|
--prop x=3 --prop y=14 --prop width=2 --prop height=3 \
|
|
--prop fill=2A9D8F --prop flipV=true
|
|
|
|
# Features: flipBoth (both axes)
|
|
$CLI add "$FILE" /Sheet1 --type shape --prop geometry=parallelogram \
|
|
--prop x=6 --prop y=14 --prop width=2 --prop height=3 \
|
|
--prop fill=E76F51 --prop flipBoth=true
|
|
|
|
# Features: rotation (degrees clockwise; stored as 60000ths on @rot)
|
|
$CLI add "$FILE" /Sheet1 --type shape --prop geometry=rightArrow \
|
|
--prop x=9 --prop y=14 --prop width=2 --prop height=3 \
|
|
--prop fill=E9C46A --prop rotation=30 --prop text="30°" --prop color=264653 --prop bold=true
|
|
|
|
# Band 4 labels (row 19), shapes span rows 20-23.
|
|
$CLI set "$FILE" /Sheet1/A19 --prop value="glow=FFD700" --prop font.bold=true
|
|
$CLI set "$FILE" /Sheet1/D19 --prop value="gradientFill (2-stop)" --prop font.bold=true
|
|
$CLI set "$FILE" /Sheet1/G19 --prop value="reflection=true" --prop font.bold=true
|
|
$CLI set "$FILE" /Sheet1/J19 --prop value="shadow=000000 + softEdge=4" --prop font.bold=true
|
|
|
|
# ─────────────────────────────────────────────────────────────────────────────
|
|
# Band 4 — Effects: glow, gradient fill, reflection, shadow, soft edge
|
|
# ─────────────────────────────────────────────────────────────────────────────
|
|
# Features: glow (color halo; pass a color or 'true' for accent blue)
|
|
$CLI add "$FILE" /Sheet1 --type shape --prop geometry=ellipse \
|
|
--prop x=0 --prop y=19 --prop width=2 --prop height=3 \
|
|
--prop fill=2A9D8F --prop glow=FFD700
|
|
|
|
# Features: gradientFill (two-stop linear, C1-C2:angle; mutually exclusive with fill)
|
|
$CLI add "$FILE" /Sheet1 --type shape --prop geometry=roundRect \
|
|
--prop x=3 --prop y=19 --prop width=2 --prop height=3 \
|
|
--prop gradientFill=FF6B6B-4ECDC4:45 --prop text="gradient" --prop color=FFFFFF --prop bold=true
|
|
|
|
# Features: reflection (mirror-below effect; 'true' enables a default reflection)
|
|
$CLI add "$FILE" /Sheet1 --type shape --prop geometry=roundRect \
|
|
--prop x=6 --prop y=19 --prop width=2 --prop height=3 \
|
|
--prop fill=457B9D --prop reflection=true --prop text="reflection" --prop color=FFFFFF --prop bold=true
|
|
|
|
# Features: shadow (outer shadow) + softEdge (feathered border radius)
|
|
$CLI add "$FILE" /Sheet1 --type shape --prop geometry=rect \
|
|
--prop x=9 --prop y=19 --prop width=2 --prop height=3 \
|
|
--prop fill=8E44AD --prop shadow=000000 --prop softEdge=4 --prop text="shadow" --prop color=FFFFFF
|
|
|
|
# Band 5 labels (row 24), shapes span rows 25-28.
|
|
$CLI set "$FILE" /Sheet1/A24 --prop value="line=C00000:2:dash (color:width:style)" --prop font.bold=true
|
|
$CLI set "$FILE" /Sheet1/D24 --prop value="styled text (font/size/align)" --prop font.bold=true
|
|
$CLI set "$FILE" /Sheet1/G24 --prop value="fill=accent1 (theme color)" --prop font.bold=true
|
|
$CLI set "$FILE" /Sheet1/J24 --prop value="anchor=K25:L28 (cell range)" --prop font.bold=true
|
|
|
|
# ─────────────────────────────────────────────────────────────────────────────
|
|
# Band 5 — Outline, text styling, theme fill, cell-range anchor
|
|
# ─────────────────────────────────────────────────────────────────────────────
|
|
# Features: line compound form 'color[:width[:style]]' (width in pt; style is a
|
|
# prstDash token: solid/dash/dot/dashdot/longdash) — same grammar as
|
|
# pptx shape line. fill=none (no fill → outline-only shape).
|
|
$CLI add "$FILE" /Sheet1 --type shape --prop geometry=rect \
|
|
--prop x=0 --prop y=24 --prop width=2 --prop height=3 \
|
|
--prop fill=none --prop line=C00000:2:dash --prop text="outline" --prop color=C00000
|
|
|
|
# Features: font, size, italic, align (paragraph), valign, margin (text inset)
|
|
$CLI add "$FILE" /Sheet1 --type shape --prop geometry=roundRect \
|
|
--prop x=3 --prop y=24 --prop width=2 --prop height=3 \
|
|
--prop fill=E9C46A --prop text="Georgia italic center-top, inset 6pt" \
|
|
--prop font=Georgia --prop size=12 --prop italic=true \
|
|
--prop align=center --prop valign=top --prop margin=6 --prop color=264653
|
|
|
|
# Features: fill with a theme (scheme) color name — follows the workbook theme
|
|
$CLI add "$FILE" /Sheet1 --type shape --prop geometry=ellipse \
|
|
--prop x=6 --prop y=24 --prop width=2 --prop height=3 \
|
|
--prop fill=accent1 --prop text="accent1" --prop color=FFFFFF --prop bold=true
|
|
|
|
# Features: anchor (cell-range form B2:F7; readback normalizes to x/y/width/height)
|
|
$CLI add "$FILE" /Sheet1 --type shape --prop geometry=roundRect \
|
|
--prop anchor=K25:L28 \
|
|
--prop fill=1D3557 --prop text="anchored K25:L28" --prop color=FFFFFF --prop bold=true
|
|
|
|
# Widen columns so the label cells are readable.
|
|
for c in 1 2 3 4 5 6 7 8 9 10 11 12; do
|
|
$CLI set "$FILE" "/Sheet1/col[$c]" --prop width=13
|
|
done
|
|
|
|
$CLI close "$FILE"
|
|
|
|
# ─────────────────────────────────────────────────────────────────────────────
|
|
# Round-trip readback (fresh, from disk) — confirm props survive the write.
|
|
# ─────────────────────────────────────────────────────────────────────────────
|
|
$CLI query "$FILE" shape
|
|
$CLI get "$FILE" '/Sheet1/shape[8]' --json # star5 + name=MyStar
|
|
$CLI get "$FILE" '/Sheet1/shape[9]' --json # flipH
|
|
$CLI get "$FILE" '/Sheet1/shape[12]' --json # rotation=30
|
|
$CLI get "$FILE" '/Sheet1/shape[13]' --json # glow
|
|
$CLI get "$FILE" '/Sheet1/shape[20]' --json # anchor → x/y/width/height
|
|
|
|
$CLI validate "$FILE"
|
|
echo "Generated: $FILE"
|