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
125 lines
6.3 KiB
Bash
125 lines
6.3 KiB
Bash
#!/bin/bash
|
|
# Real-world PowerPoint table example — quarterly financial report deck.
|
|
# Combines: built-in style, header banding, per-cell fills for traffic-light
|
|
# status, gridSpan section headers, right-aligned numbers, totals row.
|
|
|
|
# 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-financial.pptx"
|
|
|
|
rm -f "$PPTX"
|
|
officecli create "$PPTX"
|
|
officecli open "$PPTX"
|
|
|
|
# Theme colors
|
|
NAVY=1F3864; STEEL=2E75B6; PALE=DEEAF6
|
|
GREEN=00B050; AMBER=FFC000; RED=C00000
|
|
|
|
# --- Slide 1: Title ---
|
|
officecli add "$PPTX" / --type slide
|
|
officecli add "$PPTX" '/slide[1]' --type shape \
|
|
--prop text="Q4 2025 Financial Review" --prop size=44 --prop bold=true --prop color="$NAVY" \
|
|
--prop x=1in --prop y=2.5in --prop width=11in --prop height=1.2in --prop align=center
|
|
officecli add "$PPTX" '/slide[1]' --type shape \
|
|
--prop text="Revenue · Expenses · Margin · Forecast" --prop size=22 --prop color=595959 \
|
|
--prop x=1in --prop y=4in --prop width=11in --prop height=0.8in --prop align=center
|
|
|
|
# --- Slide 2: Quarterly P&L (sections via gridSpan) ---
|
|
officecli add "$PPTX" / --type slide
|
|
officecli add "$PPTX" '/slide[2]' --type shape \
|
|
--prop text="Quarterly P&L (USD, thousands)" --prop size=28 --prop bold=true --prop color="$NAVY" \
|
|
--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=12in --prop height=5.5in \
|
|
--prop rows=11 --prop cols=6
|
|
|
|
# Header
|
|
for entry in "1:Line Item" "2:Q1" "3:Q2" "4:Q3" "5:Q4" "6:FY Total"; do
|
|
c="${entry%%:*}"; t="${entry#*:}"
|
|
officecli set "$PPTX" "/slide[2]/table[1]/tr[1]/tc[$c]" \
|
|
--prop text="$t" --prop bold=true --prop color=FFFFFF --prop fill="$NAVY" \
|
|
--prop align=center
|
|
done
|
|
|
|
# Section: Revenue
|
|
officecli set "$PPTX" '/slide[2]/table[1]/tr[2]/tc[1]' \
|
|
--prop text="REVENUE" --prop bold=true --prop fill="$STEEL" --prop color=FFFFFF \
|
|
--prop gridSpan=6
|
|
|
|
set_row () {
|
|
local r="$1" label="$2" q1="$3" q2="$4" q3="$5" q4="$6" tot="$7" emphasize="$8"
|
|
local fill=""
|
|
[ "$emphasize" = "1" ] && fill="--prop fill=$PALE"
|
|
officecli set "$PPTX" "/slide[2]/table[1]/tr[$r]/tc[1]" --prop text="$label" $fill
|
|
officecli set "$PPTX" "/slide[2]/table[1]/tr[$r]/tc[2]" --prop text="$q1" --prop align=right $fill
|
|
officecli set "$PPTX" "/slide[2]/table[1]/tr[$r]/tc[3]" --prop text="$q2" --prop align=right $fill
|
|
officecli set "$PPTX" "/slide[2]/table[1]/tr[$r]/tc[4]" --prop text="$q3" --prop align=right $fill
|
|
officecli set "$PPTX" "/slide[2]/table[1]/tr[$r]/tc[5]" --prop text="$q4" --prop align=right $fill
|
|
officecli set "$PPTX" "/slide[2]/table[1]/tr[$r]/tc[6]" --prop text="$tot" --prop align=right --prop bold=true $fill
|
|
}
|
|
|
|
set_row 3 " Product Sales" "1,200" "1,350" "1,480" "1,720" "5,750" 0
|
|
set_row 4 " Services" "480" "520" "590" "640" "2,230" 0
|
|
set_row 5 " Licensing" "120" "140" "165" "195" "620" 0
|
|
set_row 6 " Subtotal" "1,800" "2,010" "2,235" "2,555" "8,600" 1
|
|
|
|
# Section: Expenses
|
|
officecli set "$PPTX" '/slide[2]/table[1]/tr[7]/tc[1]' \
|
|
--prop text="EXPENSES" --prop bold=true --prop fill="$STEEL" --prop color=FFFFFF \
|
|
--prop gridSpan=6
|
|
|
|
set_row 8 " COGS" "720" "810" "895" "1,025" "3,450" 0
|
|
set_row 9 " Operating" "380" "410" "445" "490" "1,725" 0
|
|
set_row 10 " Subtotal" "1,100" "1,220" "1,340" "1,515" "5,175" 1
|
|
|
|
# Net row
|
|
officecli set "$PPTX" '/slide[2]/table[1]/tr[11]/tc[1]' \
|
|
--prop text="NET INCOME" --prop bold=true --prop fill="$GREEN" --prop color=FFFFFF
|
|
for entry in "2:700" "3:790" "4:895" "5:1,040" "6:3,425"; do
|
|
c="${entry%%:*}"; v="${entry#*:}"
|
|
officecli set "$PPTX" "/slide[2]/table[1]/tr[11]/tc[$c]" \
|
|
--prop text="$v" --prop align=right --prop bold=true \
|
|
--prop fill="$GREEN" --prop color=FFFFFF
|
|
done
|
|
|
|
# --- Slide 3: Risk register (traffic-light fills) ---
|
|
officecli add "$PPTX" / --type slide
|
|
officecli add "$PPTX" '/slide[3]' --type shape \
|
|
--prop text="Risk Register" --prop size=28 --prop bold=true --prop color="$NAVY" \
|
|
--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 style=medium2 --prop firstRow=true --prop bandedRows=true \
|
|
--prop data="Risk,Impact,Likelihood,Owner,Status;FX volatility,High,Medium,CFO,At risk;Supply chain,Medium,Low,COO,On track;Talent attrition,High,High,CPO,Critical;Reg compliance,Medium,Medium,GC,On track;Cybersecurity,High,Low,CTO,On track"
|
|
|
|
# Color the Status column (col 5, rows 2..6)
|
|
officecli set "$PPTX" '/slide[3]/table[1]/tr[2]/tc[5]' \
|
|
--prop text="At risk" --prop fill="$AMBER" --prop bold=true --prop align=center
|
|
officecli set "$PPTX" '/slide[3]/table[1]/tr[3]/tc[5]' \
|
|
--prop text="On track" --prop fill="$GREEN" --prop color=FFFFFF --prop bold=true --prop align=center
|
|
officecli set "$PPTX" '/slide[3]/table[1]/tr[4]/tc[5]' \
|
|
--prop text="Critical" --prop fill="$RED" --prop color=FFFFFF --prop bold=true --prop align=center
|
|
officecli set "$PPTX" '/slide[3]/table[1]/tr[5]/tc[5]' \
|
|
--prop text="On track" --prop fill="$GREEN" --prop color=FFFFFF --prop bold=true --prop align=center
|
|
officecli set "$PPTX" '/slide[3]/table[1]/tr[6]/tc[5]' \
|
|
--prop text="On track" --prop fill="$GREEN" --prop color=FFFFFF --prop bold=true --prop align=center
|
|
|
|
# --- Slide 4: KPI summary (small table) ---
|
|
officecli add "$PPTX" / --type slide
|
|
officecli add "$PPTX" '/slide[4]' --type shape \
|
|
--prop text="KPI Summary" --prop size=28 --prop bold=true --prop color="$NAVY" \
|
|
--prop x=0.5in --prop y=0.3in --prop width=12in --prop height=0.6in
|
|
|
|
officecli add "$PPTX" '/slide[4]' --type table \
|
|
--prop x=2in --prop y=1.5in --prop width=9in --prop height=3.5in \
|
|
--prop style=medium4 --prop firstRow=true --prop firstCol=true --prop lastRow=true \
|
|
--prop data="Metric,Target,Actual,Variance;Revenue (\$M),8.0,8.6,+7.5%;Gross Margin,38%,40.1%,+2.1pp;Op Margin,18%,19.8%,+1.8pp;CAC Payback,14 mo,12 mo,-2 mo;Total,—,—,Beat"
|
|
|
|
officecli close "$PPTX"
|
|
officecli validate "$PPTX"
|
|
echo "Created: $PPTX"
|