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
149 lines
10 KiB
Bash
149 lines
10 KiB
Bash
#!/bin/bash
|
|
# tables-nested.sh — BUILD, NAVIGATE, and FULLY EXERCISE a nested pptx element:
|
|
# the table tree (slide → table → tr → tc). 4 slides, so the full property
|
|
# surface of each level fits without cramming one table:
|
|
#
|
|
# Slide 1 Structure & ownership — the teaching table: levels, path tokens,
|
|
# property ownership, colspan, navigation.
|
|
# Slide 2 Table-level surface — every `table` property (banding, fills,
|
|
# per-side borders, sizing, name/zorder/id, data).
|
|
# Slide 3 Cell box surface — every `tc` box property (all borders incl.
|
|
# diagonals, padding, valign, wrap, textdir,
|
|
# direction, bevel, opacity, image fill, merge).
|
|
# Slide 4 Cell text surface — every `tc` text property (font, size, weight,
|
|
# underline/strike, color, align, line/para spacing).
|
|
#
|
|
# Coverage target: 100% of the settable props on pptx table / table-row /
|
|
# table-cell (verify with `help pptx <element> --json`). The two lessons a flat
|
|
# example can't teach are still front-and-centre on slide 1:
|
|
# 1. path token ≠ element name: table-row → tr, table-cell → tc
|
|
# → a cell is /slide[N]/table[M]/tr[R]/tc[C]
|
|
# 2. property ownership: table owns style/banding/structure; tr owns height;
|
|
# tc owns the cell box AND the cell text (pptx flattens text onto the cell).
|
|
#
|
|
# SDK twin: tables-nested.py.
|
|
# 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")/tables-nested.pptx"
|
|
echo "Building $FILE ..."
|
|
rm -f "$FILE"
|
|
officecli create "$FILE"
|
|
officecli open "$FILE"
|
|
|
|
# A 1x1 PNG for the cell image-fill demo (slide 3). image= needs a real file, not
|
|
# a data-URI; generate one in a temp path so the example stays self-contained.
|
|
IMG="$(dirname "$0")/.cell-dot.png"
|
|
python3 -c "import base64,sys; open(sys.argv[1],'wb').write(base64.b64decode('iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAQAAAC1HAwCAAAAC0lEQVR42mP8z8BQDwAEhQGAhKmMIQAAAABJRU5ErkJggg=='))" "$IMG"
|
|
|
|
title() { # title <slide> <text>
|
|
officecli add "$FILE" "/slide[$1]" --type shape --prop geometry=rect \
|
|
--prop x=1.2cm --prop y=0.6cm --prop width=30cm --prop height=1.3cm \
|
|
--prop fill=none --prop line=none --prop text="$2" --prop size=20 --prop bold=true --prop color=1F4E79
|
|
}
|
|
# cell <slide> <tr/tc path> <--prop ...> — full --prop tokens forwarded verbatim.
|
|
cell() { local sl="$1" p="$2"; shift 2; officecli set "$FILE" "/slide[$sl]/table[1]/$p" "$@"; }
|
|
|
|
# ════════════════════════════ SLIDE 1 — Structure & ownership ════════════════════════════
|
|
officecli add "$FILE" / --type slide
|
|
title 1 "1 · Structure & ownership (slide → table → tr → tc)"
|
|
# Level 1: the table (returns /slide[1]/table[1]).
|
|
# rows/cols/colWidths are add-time structure; style/banding are settable later.
|
|
officecli add "$FILE" "/slide[1]" --type table --prop rows=5 --prop cols=3 \
|
|
--prop x=2.5cm --prop y=2.4cm --prop width=28cm --prop height=9cm --prop colWidths=12cm,8cm,8cm
|
|
officecli set "$FILE" "/slide[1]/table[1]" --prop style=medium2-accent1 \
|
|
--prop firstRow=true --prop bandedRows=true # ← table owns style + banding
|
|
# Level 2: a row owns only its height.
|
|
officecli set "$FILE" "/slide[1]/table[1]/tr[1]" --prop height=2cm
|
|
# Level 3: a cell owns box + text together.
|
|
cell 1 "tr[1]/tc[1]" --prop text="Region" --prop bold=true --prop color=FFFFFF --prop align=center --prop valign=middle --prop fill=1F6FEB
|
|
cell 1 "tr[1]/tc[2]" --prop text="Units" --prop bold=true --prop color=FFFFFF --prop align=center --prop valign=middle --prop fill=1F6FEB
|
|
cell 1 "tr[1]/tc[3]" --prop text="Revenue" --prop bold=true --prop color=FFFFFF --prop align=center --prop valign=middle --prop fill=1F6FEB
|
|
d1() { cell 1 "tr[$1]/tc[1]" --prop text="$2" --prop align=left --prop valign=middle
|
|
cell 1 "tr[$1]/tc[2]" --prop text="$3" --prop align=right --prop valign=middle
|
|
cell 1 "tr[$1]/tc[3]" --prop text="$4" --prop align=right --prop valign=middle; }
|
|
d1 2 "North" "1,240" "\$11,780"; d1 3 "South" "980" "\$9,310"; d1 4 "East" "1,520" "\$14,440"
|
|
# Nesting-only op: colspan (alias gridspan). Total row spans all 3 columns.
|
|
cell 1 "tr[5]/tc[1]" --prop colspan=3 --prop valign=middle --prop bold=true --prop align=center \
|
|
--prop text="TOTAL 3,740 units \$35,530" --prop fill=DDEBF7
|
|
# Navigate: address a deep node AFTER building — same path that built it reaches it.
|
|
echo "--- deep readback ---"; officecli get "$FILE" "/slide[1]/table[1]/tr[4]/tc[3]"
|
|
cell 1 "tr[4]/tc[3]" --prop fill=FFF2CC --prop bold=true
|
|
|
|
# ════════════════════════════ SLIDE 2 — Table-level full surface ════════════════════════════
|
|
officecli add "$FILE" / --type slide
|
|
title 2 "2 · Table level — banding · fills · per-side borders · sizing"
|
|
# Add-time props (data defines the grid; zorder/rowHeight/colWidths/header+body
|
|
# fills are add-only) go on the ADD; banding flags + name are settable later.
|
|
# NOTE: `id` is intentionally NOT set — table ids are auto-assigned and must stay
|
|
# unique, so hardcoding one risks collisions. (It's settable for round-trip
|
|
# fidelity, but never something to set by hand.)
|
|
officecli add "$FILE" "/slide[2]" --type table \
|
|
--prop x=2cm --prop y=2.4cm --prop width=29cm --prop height=9cm \
|
|
--prop data="Q,FY24,FY25,Growth;Q1,120,138,+15%;Q2,95,121,+27%;Q3,140,162,+16%" \
|
|
--prop zorder=2 --prop rowHeight=1.8cm --prop colWidths=8cm,7cm,7cm,7cm \
|
|
--prop headerFill=1F6FEB --prop bodyFill=EEF3FB
|
|
officecli set "$FILE" "/slide[2]/table[1]" \
|
|
--prop name=QuarterlySales \
|
|
--prop firstRow=true --prop lastRow=true --prop firstCol=true --prop lastCol=false \
|
|
--prop bandedRows=true --prop bandedCols=false
|
|
# Every table-level border edge (outer 4 + inner horizontal/vertical):
|
|
officecli set "$FILE" "/slide[2]/table[1]" \
|
|
--prop border.all="1pt solid B7C7E0" \
|
|
--prop border.top="3pt solid 1F4E79" --prop border.bottom="3pt solid 1F4E79" \
|
|
--prop border.left="1.5pt solid 1F6FEB" --prop border.right="1.5pt solid 1F6FEB" \
|
|
--prop border.horizontal="1pt solid CCD8EC" --prop border.vertical="1pt solid CCD8EC"
|
|
|
|
# ════════════════════════════ SLIDE 3 — Cell box full surface ════════════════════════════
|
|
officecli add "$FILE" / --type slide
|
|
title 3 "3 · Cell box — borders · padding · valign · direction · bevel · opacity · image · merge"
|
|
officecli add "$FILE" "/slide[3]" --type table --prop rows=5 --prop cols=4 \
|
|
--prop x=2cm --prop y=2.4cm --prop width=29cm --prop height=12cm --prop style=none
|
|
# Row 1 — per-side, full, and diagonal borders (one kind per cell so each renders distinctly)
|
|
cell 3 "tr[1]/tc[1]" --prop text="border.all" --prop border.all="1.5pt solid 1F6FEB"
|
|
cell 3 "tr[1]/tc[2]" --prop text="top+bottom" --prop border.top="3pt solid C00000" --prop border.bottom="3pt solid C00000"
|
|
cell 3 "tr[1]/tc[3]" --prop text="left+right" --prop border.left="3pt solid 2DA44E" --prop border.right="3pt solid 2DA44E"
|
|
cell 3 "tr[1]/tc[4]" --prop text="diagonals" --prop border.tl2br="1.5pt solid BF8700" --prop border.tr2bl="1.5pt solid BF8700"
|
|
# Row 2 — fill, opacity, bevel, image fill
|
|
cell 3 "tr[2]/tc[1]" --prop text="fill" --prop fill=FFE699
|
|
cell 3 "tr[2]/tc[2]" --prop text="opacity=0.5" --prop fill=1F6FEB --prop opacity=0.5
|
|
cell 3 "tr[2]/tc[3]" --prop text="bevel=circle" --prop fill=DDEBF7 --prop bevel=circle
|
|
cell 3 "tr[2]/tc[4]" --prop text="image fill" --prop image="$IMG"
|
|
# Row 3 — padding, padding.bottom, valign (top + bottom)
|
|
cell 3 "tr[3]/tc[1]" --prop text="padding=0.4cm" --prop padding=0.4cm --prop fill=F2F2F2
|
|
cell 3 "tr[3]/tc[2]" --prop text="padding.bottom=0.5cm" --prop padding.bottom=0.5cm --prop fill=F2F2F2
|
|
cell 3 "tr[3]/tc[3]" --prop text="valign=top" --prop valign=top --prop fill=F2F2F2
|
|
cell 3 "tr[3]/tc[4]" --prop text="valign=bottom" --prop valign=bottom --prop fill=F2F2F2
|
|
# Row 4 — wrap, vertical text, RTL direction, and merge.down (eats the cell below it)
|
|
cell 3 "tr[4]/tc[1]" --prop text="wrap=false: this long line will not wrap inside the cell" --prop wrap=false --prop fill=E2EFDA
|
|
cell 3 "tr[4]/tc[2]" --prop text="textdir=vertical270" --prop textdirection=vertical270 --prop fill=E2EFDA
|
|
cell 3 "tr[4]/tc[3]" --prop text="direction=rtl العربية" --prop direction=rtl --prop fill=E2EFDA
|
|
cell 3 "tr[4]/tc[4]" --prop text="merge.down=1 ↓" --prop merge.down=1 --prop align=center --prop fill=FCE4D6
|
|
# Row 5 — merge.right (eats the cell to its right). tc[4] is swallowed by the merge.down above.
|
|
cell 3 "tr[5]/tc[1]" --prop text="merge.right=2 →" --prop merge.right=2 --prop align=center --prop fill=FCE4D6
|
|
|
|
# ════════════════════════════ SLIDE 4 — Cell text full surface ════════════════════════════
|
|
officecli add "$FILE" / --type slide
|
|
title 4 "4 · Cell text — font · size · weight · underline/strike · color · align · spacing"
|
|
officecli add "$FILE" "/slide[4]" --type table --prop rows=4 --prop cols=3 \
|
|
--prop x=2cm --prop y=2.4cm --prop width=29cm --prop height=10cm --prop style=light1
|
|
cell 4 "tr[1]/tc[1]" --prop text="font=Georgia" --prop font=Georgia
|
|
cell 4 "tr[1]/tc[2]" --prop text="size=20pt" --prop size=20pt
|
|
cell 4 "tr[1]/tc[3]" --prop text="color" --prop color=C00000
|
|
cell 4 "tr[2]/tc[1]" --prop text="bold" --prop bold=true
|
|
cell 4 "tr[2]/tc[2]" --prop text="italic" --prop italic=true
|
|
cell 4 "tr[2]/tc[3]" --prop text="underline" --prop underline=double
|
|
cell 4 "tr[3]/tc[1]" --prop text="strike" --prop strike=single
|
|
cell 4 "tr[3]/tc[2]" --prop text="align=center" --prop align=center
|
|
cell 4 "tr[3]/tc[3]" --prop text="align=right" --prop align=right
|
|
cell 4 "tr[4]/tc[1]" --prop text="linespacing=1.5x — line one is followed by line two in this cell" --prop linespacing=1.5x
|
|
cell 4 "tr[4]/tc[2]" --prop text="spacebefore=10pt" --prop spacebefore=10pt
|
|
cell 4 "tr[4]/tc[3]" --prop text="spaceafter=10pt" --prop spaceafter=10pt
|
|
# table-row also owns height (set on slide 1 too); set one here to keep row 4 roomy.
|
|
officecli set "$FILE" "/slide[4]/table[1]/tr[4]" --prop height=2.4cm
|
|
|
|
rm -f "$IMG"
|
|
officecli close "$FILE"
|
|
officecli validate "$FILE"
|
|
echo "Created: $FILE"
|