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
273 lines
10 KiB
Bash
Executable File
273 lines
10 KiB
Bash
Executable File
#!/bin/bash
|
|
# Radar Charts Showcase — radar with standard, filled, and marker styles.
|
|
# Generates charts-radar.xlsx (16 charts across 4 sheets).
|
|
# CLI twin of charts-radar.py (officecli Python SDK).
|
|
# Usage: ./charts-radar.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-radar.xlsx"
|
|
|
|
rm -f "$FILE"
|
|
officecli create "$FILE"
|
|
officecli open "$FILE"
|
|
|
|
# ==========================================================================
|
|
# Sheet: 1-Radar Fundamentals
|
|
# ==========================================================================
|
|
officecli add "$FILE" / --type sheet --prop name="1-Radar Fundamentals"
|
|
|
|
# Chart 1: Basic radar (standard style) with 3 series
|
|
officecli add "$FILE" "/1-Radar Fundamentals" --type chart \
|
|
--prop chartType=radar \
|
|
--prop radarStyle=standard \
|
|
--prop title="Athlete Comparison" \
|
|
--prop series1="Alice:85,70,90,60,75" \
|
|
--prop series2="Bob:65,90,70,80,85" \
|
|
--prop series3="Carol:75,80,80,70,65" \
|
|
--prop categories=Speed,Strength,Stamina,Agility,Accuracy \
|
|
--prop colors=4472C4,ED7D31,70AD47 \
|
|
--prop x=0 --prop y=0 --prop width=12 --prop height=18 \
|
|
--prop legend=bottom
|
|
|
|
# Chart 2: Radar with markers (marker style)
|
|
officecli add "$FILE" "/1-Radar Fundamentals" --type chart \
|
|
--prop chartType=radar \
|
|
--prop radarStyle=marker \
|
|
--prop title="Product Ratings" \
|
|
--prop series1="Product A:9,7,8,6,8" \
|
|
--prop series2="Product B:6,9,7,8,5" \
|
|
--prop categories=Quality,Price,Design,Support,Delivery \
|
|
--prop colors=2E75B6,C00000 \
|
|
--prop marker=circle:6:2E75B6 \
|
|
--prop x=13 --prop y=0 --prop width=12 --prop height=18 \
|
|
--prop legend=bottom \
|
|
--prop dataLabels=true
|
|
|
|
# Chart 3: Filled radar with transparency
|
|
officecli add "$FILE" "/1-Radar Fundamentals" --type chart \
|
|
--prop chartType=radar \
|
|
--prop radarStyle=filled \
|
|
--prop title="Skills Assessment" \
|
|
--prop series1="Junior:50,40,60,70,55" \
|
|
--prop series2="Senior:85,80,75,90,80" \
|
|
--prop categories=Coding,Design,Testing,Communication,Leadership \
|
|
--prop colors=4472C4,70AD47 \
|
|
--prop transparency=40 \
|
|
--prop x=0 --prop y=19 --prop width=12 --prop height=18 \
|
|
--prop legend=bottom
|
|
|
|
# Chart 4: Filled radar with per-series colors and white outline
|
|
officecli add "$FILE" "/1-Radar Fundamentals" --type chart \
|
|
--prop chartType=radar \
|
|
--prop radarStyle=filled \
|
|
--prop title="Department Scores" \
|
|
--prop series1="Engineering:90,75,60,85,70" \
|
|
--prop series2="Marketing:60,85,80,70,90" \
|
|
--prop series3="Sales:70,80,75,65,85" \
|
|
--prop categories=Innovation,Teamwork,Efficiency,Quality,Growth \
|
|
--prop colors=4472C4,ED7D31,70AD47 \
|
|
--prop series.outline=FFFFFF-0.5 \
|
|
--prop transparency=35 \
|
|
--prop x=13 --prop y=19 --prop width=12 --prop height=18 \
|
|
--prop legend=bottom
|
|
|
|
# ==========================================================================
|
|
# Sheet: 2-Radar Styling
|
|
# ==========================================================================
|
|
officecli add "$FILE" / --type sheet --prop name="2-Radar Styling"
|
|
|
|
# Chart 1: Title styling (font, size, color, bold, shadow)
|
|
officecli add "$FILE" "/2-Radar Styling" --type chart \
|
|
--prop chartType=radar \
|
|
--prop radarStyle=marker \
|
|
--prop title="Styled Title Demo" \
|
|
--prop series1="Team A:80,65,90,70,85" \
|
|
--prop categories=Attack,Defense,Speed,Skill,Stamina \
|
|
--prop colors=2E75B6 \
|
|
--prop x=0 --prop y=0 --prop width=12 --prop height=18 \
|
|
--prop title.font=Georgia --prop title.size=18 \
|
|
--prop title.color=1F4E79 --prop title.bold=true \
|
|
--prop title.shadow=000000-3-315-2-30
|
|
|
|
# Chart 2: Series shadow effects
|
|
officecli add "$FILE" "/2-Radar Styling" --type chart \
|
|
--prop chartType=radar \
|
|
--prop radarStyle=filled \
|
|
--prop title="Shadow Effects" \
|
|
--prop series1="Region A:75,80,65,90,70" \
|
|
--prop series2="Region B:60,70,85,75,80" \
|
|
--prop categories=Revenue,Profit,Growth,Retention,Satisfaction \
|
|
--prop colors=4472C4,ED7D31 \
|
|
--prop series.shadow=000000-4-315-2-30 \
|
|
--prop transparency=30 \
|
|
--prop x=13 --prop y=0 --prop width=12 --prop height=18 \
|
|
--prop legend=bottom
|
|
|
|
# Chart 3: Axis font and gridlines styling
|
|
officecli add "$FILE" "/2-Radar Styling" --type chart \
|
|
--prop chartType=radar \
|
|
--prop radarStyle=marker \
|
|
--prop title="Axis & Gridlines" \
|
|
--prop series1="Actual:70,85,60,75,80" \
|
|
--prop series2="Target:80,80,80,80,80" \
|
|
--prop categories="KPI 1,KPI 2,KPI 3,KPI 4,KPI 5" \
|
|
--prop colors=4472C4,C00000 \
|
|
--prop axisfont=10:333333:Calibri \
|
|
--prop gridlines=D9D9D9:0.5 \
|
|
--prop x=0 --prop y=19 --prop width=12 --prop height=18 \
|
|
--prop legend=bottom
|
|
|
|
# Chart 4: Plot fill, chart fill, rounded corners, borders
|
|
officecli add "$FILE" "/2-Radar Styling" --type chart \
|
|
--prop chartType=radar \
|
|
--prop radarStyle=filled \
|
|
--prop title="Chart Area Styling" \
|
|
--prop series1="Score:85,70,90,60,75" \
|
|
--prop categories=Speed,Power,Technique,Endurance,Flexibility \
|
|
--prop colors=4472C4 \
|
|
--prop transparency=25 \
|
|
--prop x=13 --prop y=19 --prop width=12 --prop height=18 \
|
|
--prop plotFill=F5F5F5 --prop chartFill=FAFAFA \
|
|
--prop roundedCorners=true \
|
|
--prop chartArea.border=BFBFBF:0.5 \
|
|
--prop plotArea.border=D9D9D9:0.25
|
|
|
|
# ==========================================================================
|
|
# Sheet: 3-Labels & Legend
|
|
# ==========================================================================
|
|
officecli add "$FILE" / --type sheet --prop name="3-Labels & Legend"
|
|
|
|
# Chart 1: Data labels with font styling and position
|
|
officecli add "$FILE" "/3-Labels & Legend" --type chart \
|
|
--prop chartType=radar \
|
|
--prop radarStyle=marker \
|
|
--prop title="Data Labels" \
|
|
--prop series1="Performance:88,72,95,67,81" \
|
|
--prop categories=Speed,Strength,Stamina,Agility,Accuracy \
|
|
--prop colors=2E75B6 \
|
|
--prop marker=circle:6:2E75B6 \
|
|
--prop x=0 --prop y=0 --prop width=12 --prop height=18 \
|
|
--prop dataLabels=true --prop labelPos=outsideEnd \
|
|
--prop labelFont=9:333333:true
|
|
|
|
# Chart 2: Legend positioning and styling with overlay
|
|
officecli add "$FILE" "/3-Labels & Legend" --type chart \
|
|
--prop chartType=radar \
|
|
--prop radarStyle=standard \
|
|
--prop title="Legend Styles" \
|
|
--prop series1="Alpha:80,60,75,90,70" \
|
|
--prop series2="Beta:70,80,85,65,75" \
|
|
--prop series3="Gamma:65,75,70,80,85" \
|
|
--prop categories="Metric A,Metric B,Metric C,Metric D,Metric E" \
|
|
--prop colors=4472C4,ED7D31,70AD47 \
|
|
--prop x=13 --prop y=0 --prop width=12 --prop height=18 \
|
|
--prop legend=right \
|
|
--prop legendfont=10:1F4E79:Calibri \
|
|
--prop legend.overlay=true
|
|
|
|
# Chart 3: Manual plot area layout
|
|
officecli add "$FILE" "/3-Labels & Legend" --type chart \
|
|
--prop chartType=radar \
|
|
--prop radarStyle=filled \
|
|
--prop title="Custom Layout" \
|
|
--prop series1="Team:85,70,90,65,80" \
|
|
--prop categories=Vision,Execution,Culture,Agility,Impact \
|
|
--prop colors=4472C4 \
|
|
--prop transparency=30 \
|
|
--prop x=0 --prop y=19 --prop width=12 --prop height=18 \
|
|
--prop plotArea.x=0.1 --prop plotArea.y=0.15 \
|
|
--prop plotArea.w=0.8 --prop plotArea.h=0.75
|
|
|
|
# Chart 4: Multiple series (5+) comparison
|
|
officecli add "$FILE" "/3-Labels & Legend" --type chart \
|
|
--prop chartType=radar \
|
|
--prop radarStyle=standard \
|
|
--prop title="Multi-Team Comparison" \
|
|
--prop series1="Dev:90,70,80,65,75" \
|
|
--prop series2="QA:60,85,70,80,90" \
|
|
--prop series3="Design:75,80,85,70,60" \
|
|
--prop series4="PM:80,65,75,90,70" \
|
|
--prop series5="DevOps:70,75,60,85,80" \
|
|
--prop categories=Speed,Quality,Innovation,Teamwork,Delivery \
|
|
--prop colors=4472C4,ED7D31,70AD47,FFC000,7030A0 \
|
|
--prop x=13 --prop y=19 --prop width=12 --prop height=18 \
|
|
--prop legend=bottom \
|
|
--prop legendfont=9:333333:Calibri
|
|
|
|
# ==========================================================================
|
|
# Sheet: 4-Advanced
|
|
# ==========================================================================
|
|
officecli add "$FILE" / --type sheet --prop name="4-Advanced"
|
|
|
|
# Chart 1: Title glow and shadow effects
|
|
officecli add "$FILE" "/4-Advanced" --type chart \
|
|
--prop chartType=radar \
|
|
--prop radarStyle=marker \
|
|
--prop title="Glow & Shadow Title" \
|
|
--prop series1="Score:75,85,65,90,80" \
|
|
--prop categories=Creativity,Logic,Memory,Focus,Speed \
|
|
--prop colors=2E75B6 \
|
|
--prop marker=diamond:7:2E75B6 \
|
|
--prop x=0 --prop y=0 --prop width=12 --prop height=18 \
|
|
--prop title.font=Georgia --prop title.size=16 \
|
|
--prop title.bold=true --prop title.color=1F4E79 \
|
|
--prop title.glow=4472C4-8 \
|
|
--prop title.shadow=000000-3-315-2-30
|
|
|
|
# Chart 2: Radar with many spokes (8 categories)
|
|
officecli add "$FILE" "/4-Advanced" --type chart \
|
|
--prop chartType=radar \
|
|
--prop radarStyle=filled \
|
|
--prop title="8-Spoke Assessment" \
|
|
--prop series1="Candidate:85,70,90,60,75,80,65,88" \
|
|
--prop series2="Benchmark:70,70,70,70,70,70,70,70" \
|
|
--prop categories=Technical,Communication,Leadership,Creativity,Analytical,Teamwork,Adaptability,Initiative \
|
|
--prop colors=4472C4,BFBFBF \
|
|
--prop transparency=35 \
|
|
--prop x=13 --prop y=0 --prop width=12 --prop height=18 \
|
|
--prop legend=bottom \
|
|
--prop gridlines=D9D9D9:0.25
|
|
|
|
# Chart 3: Single-series radar with full styling
|
|
officecli add "$FILE" "/4-Advanced" --type chart \
|
|
--prop chartType=radar \
|
|
--prop radarStyle=marker \
|
|
--prop title="Personal Profile" \
|
|
--prop series1="Self:92,78,85,65,88,70" \
|
|
--prop categories=Python,JavaScript,SQL,DevOps,Testing,Design \
|
|
--prop colors=7030A0 \
|
|
--prop marker=square:7:7030A0 \
|
|
--prop x=0 --prop y=19 --prop width=12 --prop height=18 \
|
|
--prop dataLabels=true --prop labelFont=9:7030A0:true \
|
|
--prop title.font=Calibri --prop title.size=14 \
|
|
--prop title.color=7030A0 --prop title.bold=true \
|
|
--prop plotFill=F8F0FF --prop chartFill=FFFFFF \
|
|
--prop roundedCorners=true \
|
|
--prop chartArea.border=7030A0:0.5
|
|
|
|
# Chart 4: Two-series filled radar with low transparency for overlap
|
|
officecli add "$FILE" "/4-Advanced" --type chart \
|
|
--prop chartType=radar \
|
|
--prop radarStyle=filled \
|
|
--prop title="Before vs After" \
|
|
--prop series1="Before:55,40,65,50,45" \
|
|
--prop series2="After:85,75,80,70,80" \
|
|
--prop categories=Revenue,Efficiency,Satisfaction,Innovation,Retention \
|
|
--prop colors=C00000,70AD47 \
|
|
--prop transparency=20 \
|
|
--prop series.outline=FFFFFF-0.75 \
|
|
--prop x=13 --prop y=19 --prop width=12 --prop height=18 \
|
|
--prop legend=bottom \
|
|
--prop dataLabels=true --prop labelFont=9:333333:false \
|
|
--prop chartFill=FAFAFA --prop plotFill=F5F5F5
|
|
|
|
# Remove blank default Sheet1 (all data is inline)
|
|
officecli remove "$FILE" /Sheet1
|
|
|
|
officecli close "$FILE"
|
|
|
|
officecli validate "$FILE"
|
|
echo "Generated: $FILE"
|