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
229 lines
11 KiB
Bash
229 lines
11 KiB
Bash
#!/bin/bash
|
|
# Basic PowerPoint table — header row, body rows, fills, font sizing.
|
|
# Demonstrates: add table with inline `data=` CSV, headerFill/bodyFill,
|
|
# per-cell text override via set, table dimensions (x/y/width/height).
|
|
|
|
# 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.
|
|
DIR="$(dirname "$0")"
|
|
PPTX="$DIR/tables-basic.pptx"
|
|
|
|
rm -f "$PPTX"
|
|
officecli create "$PPTX"
|
|
officecli open "$PPTX"
|
|
|
|
# --- Slide 1: minimal 3x3 table seeded inline ---
|
|
officecli add "$PPTX" / --type slide
|
|
officecli add "$PPTX" '/slide[1]' --type shape \
|
|
--prop text="Basic Table — Inline Data" --prop size=28 --prop bold=true \
|
|
--prop x=0.5in --prop y=0.3in --prop width=12in --prop height=0.6in
|
|
|
|
# 'data=' uses CSV (comma = cell sep, semicolon = row sep).
|
|
officecli add "$PPTX" '/slide[1]' --type table \
|
|
--prop x=0.5in --prop y=1.2in --prop width=12in --prop height=2in \
|
|
--prop headerFill=4472C4 --prop bodyFill=DEEAF6 \
|
|
--prop data="Region,Q1,Q2,Q3,Q4;North,120,135,142,168;South,98,110,121,140;East,165,178,190,205"
|
|
|
|
# --- Slide 2: explicit rows/cols then per-cell text ---
|
|
officecli add "$PPTX" / --type slide
|
|
officecli add "$PPTX" '/slide[2]' --type shape \
|
|
--prop text="Basic Table — Per-Cell Set" --prop size=28 --prop bold=true \
|
|
--prop x=0.5in --prop y=0.3in --prop width=12in --prop height=0.6in
|
|
|
|
officecli add "$PPTX" '/slide[2]' --type table \
|
|
--prop x=0.5in --prop y=1.2in --prop width=10in --prop height=2.5in \
|
|
--prop rows=4 --prop cols=3 --prop headerFill=2E75B6
|
|
|
|
# Header
|
|
for entry in "1:Product" "2:Units" "3:Revenue"; do
|
|
col="${entry%%:*}"; txt="${entry#*:}"
|
|
officecli set "$PPTX" "/slide[2]/table[1]/tr[1]/tc[$col]" \
|
|
--prop text="$txt" --prop bold=true --prop color=FFFFFF
|
|
done
|
|
|
|
# Body
|
|
officecli set "$PPTX" '/slide[2]/table[1]/tr[2]/tc[1]' --prop text="Widget"
|
|
officecli set "$PPTX" '/slide[2]/table[1]/tr[2]/tc[2]' --prop text="1,200"
|
|
officecli set "$PPTX" '/slide[2]/table[1]/tr[2]/tc[3]' --prop text="\$48,000"
|
|
officecli set "$PPTX" '/slide[2]/table[1]/tr[3]/tc[1]' --prop text="Gizmo"
|
|
officecli set "$PPTX" '/slide[2]/table[1]/tr[3]/tc[2]' --prop text="850"
|
|
officecli set "$PPTX" '/slide[2]/table[1]/tr[3]/tc[3]' --prop text="\$72,250"
|
|
officecli set "$PPTX" '/slide[2]/table[1]/tr[4]/tc[1]' --prop text="Sprocket"
|
|
officecli set "$PPTX" '/slide[2]/table[1]/tr[4]/tc[2]' --prop text="430"
|
|
officecli set "$PPTX" '/slide[2]/table[1]/tr[4]/tc[3]' --prop text="\$25,800"
|
|
|
|
# --- Slide 3: Cell fill variations (solid hex, theme color, gradient, none) ---
|
|
officecli add "$PPTX" / --type slide
|
|
officecli add "$PPTX" '/slide[3]' --type shape \
|
|
--prop text="Cell Fill Variations" --prop size=28 --prop bold=true \
|
|
--prop x=0.5in --prop y=0.3in --prop width=12in --prop height=0.6in
|
|
|
|
officecli add "$PPTX" '/slide[3]' --type table \
|
|
--prop x=0.5in --prop y=1.2in --prop width=12in --prop height=4in \
|
|
--prop rows=5 --prop cols=2 --prop style=none --prop border.all="1pt solid 808080"
|
|
|
|
officecli set "$PPTX" '/slide[3]/table[1]/tr[1]/tc[1]' --prop text="fill spec" --prop bold=true --prop fill=404040 --prop color=FFFFFF
|
|
officecli set "$PPTX" '/slide[3]/table[1]/tr[1]/tc[2]' --prop text="rendered" --prop bold=true --prop fill=404040 --prop color=FFFFFF
|
|
|
|
# Solid hex
|
|
officecli set "$PPTX" '/slide[3]/table[1]/tr[2]/tc[1]' --prop text='fill=FF0000 (solid hex)'
|
|
officecli set "$PPTX" '/slide[3]/table[1]/tr[2]/tc[2]' --prop fill=FF0000
|
|
|
|
# Named color
|
|
officecli set "$PPTX" '/slide[3]/table[1]/tr[3]/tc[1]' --prop text='fill=red / fill=rgb(255,0,0) (named / rgb forms)'
|
|
officecli set "$PPTX" '/slide[3]/table[1]/tr[3]/tc[2]' --prop fill=red
|
|
|
|
# Theme color — accent1 follows the deck theme
|
|
officecli set "$PPTX" '/slide[3]/table[1]/tr[4]/tc[1]' --prop text='fill=accent1 (theme color, follows deck theme)'
|
|
officecli set "$PPTX" '/slide[3]/table[1]/tr[4]/tc[2]' --prop fill=accent1
|
|
|
|
# Gradient — "COLOR1-COLOR2[-ANGLE]"
|
|
officecli set "$PPTX" '/slide[3]/table[1]/tr[5]/tc[1]' --prop text='fill="FF0000-0000FF-90" (gradient, 90° angle)'
|
|
officecli set "$PPTX" '/slide[3]/table[1]/tr[5]/tc[2]' --prop fill="FF0000-0000FF-90"
|
|
|
|
# fill=none demo (separate small table so 'none' is visible against page bg)
|
|
officecli add "$PPTX" '/slide[3]' --type shape \
|
|
--prop text='fill=none (explicit no-fill; cell becomes transparent):' --prop size=14 \
|
|
--prop x=0.5in --prop y=5.4in --prop width=12in --prop height=0.4in
|
|
officecli add "$PPTX" '/slide[3]' --type table \
|
|
--prop x=0.5in --prop y=5.9in --prop width=4in --prop height=0.8in \
|
|
--prop rows=1 --prop cols=2 --prop style=none --prop border.all="1pt solid 000000"
|
|
officecli set "$PPTX" '/slide[3]/table[2]/tr[1]/tc[1]' --prop text="solid" --prop fill=FFE699
|
|
officecli set "$PPTX" '/slide[3]/table[2]/tr[1]/tc[2]' --prop text="none" --prop fill=none
|
|
|
|
# --- Slide 4: Cell typography — italic / underline / strike / font / wrap ---
|
|
# --- and paragraph spacing — linespacing / spacebefore / spaceafter ---
|
|
officecli add "$PPTX" / --type slide
|
|
officecli add "$PPTX" '/slide[4]' --type shape \
|
|
--prop text="Cell Typography — italic / underline / strike / font / wrap / spacing" \
|
|
--prop size=24 --prop bold=true \
|
|
--prop x=0.5in --prop y=0.3in --prop width=13in --prop height=0.6in
|
|
|
|
officecli add "$PPTX" '/slide[4]' --type table \
|
|
--prop x=0.5in --prop y=1.1in --prop width=13in --prop height=5in \
|
|
--prop rows=7 --prop cols=2 --prop style=none --prop border.all="1pt solid 808080"
|
|
|
|
# Header
|
|
officecli set "$PPTX" '/slide[4]/table[1]/tr[1]/tc[1]' \
|
|
--prop text="Property" --prop bold=true --prop fill=2E75B6 --prop color=FFFFFF
|
|
officecli set "$PPTX" '/slide[4]/table[1]/tr[1]/tc[2]' \
|
|
--prop text="Example" --prop bold=true --prop fill=2E75B6 --prop color=FFFFFF
|
|
|
|
# italic
|
|
officecli set "$PPTX" '/slide[4]/table[1]/tr[2]/tc[1]' --prop text="italic=true"
|
|
officecli set "$PPTX" '/slide[4]/table[1]/tr[2]/tc[2]' \
|
|
--prop text="This cell text is italic." --prop italic=true
|
|
|
|
# underline
|
|
officecli set "$PPTX" '/slide[4]/table[1]/tr[3]/tc[1]' --prop text="underline=single"
|
|
officecli set "$PPTX" '/slide[4]/table[1]/tr[3]/tc[2]' \
|
|
--prop text="This cell text is underlined." --prop underline=single
|
|
|
|
# strike
|
|
officecli set "$PPTX" '/slide[4]/table[1]/tr[4]/tc[1]' --prop text="strike=single"
|
|
officecli set "$PPTX" '/slide[4]/table[1]/tr[4]/tc[2]' \
|
|
--prop text="This cell text has strikethrough." --prop strike=single
|
|
|
|
# font
|
|
officecli set "$PPTX" '/slide[4]/table[1]/tr[5]/tc[1]' --prop text="font=Georgia"
|
|
officecli set "$PPTX" '/slide[4]/table[1]/tr[5]/tc[2]' \
|
|
--prop text="This cell uses Georgia." --prop font="Georgia" --prop size=16
|
|
|
|
# wrap=false (text doesn't wrap; overflow is clipped)
|
|
officecli set "$PPTX" '/slide[4]/table[1]/tr[6]/tc[1]' --prop text="wrap=false"
|
|
officecli set "$PPTX" '/slide[4]/table[1]/tr[6]/tc[2]' \
|
|
--prop text="This is a long sentence that will not wrap because wrap is disabled — it just runs off the edge." \
|
|
--prop wrap=false
|
|
|
|
# linespacing / spacebefore / spaceafter
|
|
officecli set "$PPTX" '/slide[4]/table[1]/tr[7]/tc[1]' \
|
|
--prop text="linespacing=1.5x + spacebefore=4pt + spaceafter=4pt"
|
|
officecli set "$PPTX" '/slide[4]/table[1]/tr[7]/tc[2]' \
|
|
--prop text="Paragraph A" \
|
|
--prop linespacing=1.5x --prop spacebefore=4pt --prop spaceafter=4pt
|
|
|
|
# --- Slide 5: Cell layout — padding / padding.bottom / opacity / image / ---
|
|
# --- textdirection / direction / merge.right / bevel / border.right ---
|
|
officecli add "$PPTX" / --type slide
|
|
officecli add "$PPTX" '/slide[5]' --type shape \
|
|
--prop text="Cell Layout — padding / opacity / image / textdirection / merge.right / bevel" \
|
|
--prop size=22 --prop bold=true \
|
|
--prop x=0.5in --prop y=0.3in --prop width=13in --prop height=0.6in
|
|
|
|
officecli add "$PPTX" '/slide[5]' --type table \
|
|
--prop x=0.5in --prop y=1.1in --prop width=13in --prop height=6.2in \
|
|
--prop rows=8 --prop cols=2 --prop style=none --prop border.all="1pt solid 808080"
|
|
|
|
# Header
|
|
officecli set "$PPTX" '/slide[5]/table[1]/tr[1]/tc[1]' \
|
|
--prop text="Property" --prop bold=true --prop fill=1F4E79 --prop color=FFFFFF
|
|
officecli set "$PPTX" '/slide[5]/table[1]/tr[1]/tc[2]' \
|
|
--prop text="Example" --prop bold=true --prop fill=1F4E79 --prop color=FFFFFF
|
|
|
|
# padding — uniform inner margin
|
|
officecli set "$PPTX" '/slide[5]/table[1]/tr[2]/tc[1]' --prop text="padding=0.25in"
|
|
officecli set "$PPTX" '/slide[5]/table[1]/tr[2]/tc[2]' \
|
|
--prop text="Large inner margin." --prop fill=F1FAEE --prop padding=0.25in
|
|
|
|
# padding.bottom — single-edge padding override
|
|
officecli set "$PPTX" '/slide[5]/table[1]/tr[3]/tc[1]' --prop text="padding.bottom=0.3in"
|
|
officecli set "$PPTX" '/slide[5]/table[1]/tr[3]/tc[2]' \
|
|
--prop text="Extra space below this text." --prop fill=F1FAEE --prop "padding.bottom=0.3in"
|
|
|
|
# opacity — fill transparency (0=opaque, 1=invisible)
|
|
officecli set "$PPTX" '/slide[5]/table[1]/tr[4]/tc[1]' --prop text="opacity=0.4 (requires fill)"
|
|
officecli set "$PPTX" '/slide[5]/table[1]/tr[4]/tc[2]' \
|
|
--prop text="40% transparent fill." --prop fill=4472C4 --prop opacity=0.4
|
|
|
|
# image — picture fill (blipFill on the cell)
|
|
IMGFILE="$(python3 - <<'PY'
|
|
import struct, zlib, tempfile, os
|
|
W = H = 32
|
|
rows = []
|
|
for y in range(H):
|
|
row = b'\x00'
|
|
for x in range(W):
|
|
cell = (x // 8 + y // 8) & 1
|
|
row += (b'\x4a\x72\xc4' if cell else b'\xa8\xda\xdc')
|
|
rows.append(row)
|
|
raw = b''.join(rows)
|
|
def chunk(t, d):
|
|
return struct.pack('>I', len(d)) + t + d + struct.pack('>I', zlib.crc32(t + d) & 0xffffffff)
|
|
png = b'\x89PNG\r\n\x1a\n'
|
|
png += chunk(b'IHDR', struct.pack('>IIBBBBB', W, H, 8, 2, 0, 0, 0))
|
|
png += chunk(b'IDAT', zlib.compress(raw))
|
|
png += chunk(b'IEND', b'')
|
|
p = tempfile.mktemp(suffix='.png')
|
|
open(p, 'wb').write(png)
|
|
print(p)
|
|
PY
|
|
)"
|
|
officecli set "$PPTX" '/slide[5]/table[1]/tr[5]/tc[1]' --prop text="image=/path/to/img.png"
|
|
officecli set "$PPTX" '/slide[5]/table[1]/tr[5]/tc[2]' \
|
|
--prop image="$IMGFILE"
|
|
rm -f "$IMGFILE"
|
|
|
|
# textdirection — vertical text rendering in a cell
|
|
officecli set "$PPTX" '/slide[5]/table[1]/tr[6]/tc[1]' --prop text="textdirection=vert"
|
|
officecli set "$PPTX" '/slide[5]/table[1]/tr[6]/tc[2]' \
|
|
--prop text="Vertical text" --prop textdirection=vert --prop fill=FFE699
|
|
|
|
# direction — RTL paragraph direction within a cell
|
|
officecli set "$PPTX" '/slide[5]/table[1]/tr[7]/tc[1]' --prop text="direction=rtl"
|
|
officecli set "$PPTX" '/slide[5]/table[1]/tr[7]/tc[2]' \
|
|
--prop text="مرحبا" --prop direction=rtl --prop size=18 --prop fill=A8DADC
|
|
|
|
# merge.right + bevel + border.right (per-cell border)
|
|
officecli set "$PPTX" '/slide[5]/table[1]/tr[8]/tc[1]' \
|
|
--prop text="merge.right=1 bevel=circle border.right=2pt solid E63946" \
|
|
--prop fill=F4A261 --prop size=11
|
|
officecli set "$PPTX" '/slide[5]/table[1]/tr[8]/tc[2]' \
|
|
--prop text="Merged, beveled, custom right border." \
|
|
--prop fill=F4A261 --prop bevel=circle \
|
|
--prop "border.right=2pt solid E63946"
|
|
|
|
officecli close "$PPTX"
|
|
officecli validate "$PPTX"
|
|
echo "Created: $PPTX"
|