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
396 lines
17 KiB
Bash
Executable File
396 lines
17 KiB
Bash
Executable File
#!/bin/bash
|
|
# Area Charts Showcase — area, areaStacked, areaPercentStacked, and area3d.
|
|
# CLI twin of charts-area.py (officecli Python SDK). Both produce an
|
|
# equivalent charts-area.xlsx.
|
|
#
|
|
# 5 sheets, 20 charts total. Every area chart feature officecli supports is
|
|
# demonstrated at least once: area fills, gradients, transparency, stacking,
|
|
# axis scaling, gridlines, data labels, legend positioning, reference lines,
|
|
# secondary axis, shadows, manual layout, and 3D rotation.
|
|
#
|
|
# Usage: ./charts-area.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-area.xlsx"
|
|
rm -f "$FILE"
|
|
|
|
officecli create "$FILE"
|
|
officecli open "$FILE"
|
|
|
|
# ==========================================================================
|
|
# Source data — shared across all charts
|
|
# ==========================================================================
|
|
officecli set "$FILE" /Sheet1/A1 --prop text=Month --prop bold=true
|
|
officecli set "$FILE" /Sheet1/B1 --prop text=Organic --prop bold=true
|
|
officecli set "$FILE" /Sheet1/C1 --prop text=Paid --prop bold=true
|
|
officecli set "$FILE" /Sheet1/D1 --prop text=Social --prop bold=true
|
|
officecli set "$FILE" /Sheet1/E1 --prop text=Referral --prop bold=true
|
|
|
|
officecli set "$FILE" /Sheet1/A2 --prop text=Jan
|
|
officecli set "$FILE" /Sheet1/B2 --prop text=4200
|
|
officecli set "$FILE" /Sheet1/C2 --prop text=3100
|
|
officecli set "$FILE" /Sheet1/D2 --prop text=1800
|
|
officecli set "$FILE" /Sheet1/E2 --prop text=1200
|
|
officecli set "$FILE" /Sheet1/A3 --prop text=Feb
|
|
officecli set "$FILE" /Sheet1/B3 --prop text=4800
|
|
officecli set "$FILE" /Sheet1/C3 --prop text=3500
|
|
officecli set "$FILE" /Sheet1/D3 --prop text=2100
|
|
officecli set "$FILE" /Sheet1/E3 --prop text=1400
|
|
officecli set "$FILE" /Sheet1/A4 --prop text=Mar
|
|
officecli set "$FILE" /Sheet1/B4 --prop text=5100
|
|
officecli set "$FILE" /Sheet1/C4 --prop text=3800
|
|
officecli set "$FILE" /Sheet1/D4 --prop text=2400
|
|
officecli set "$FILE" /Sheet1/E4 --prop text=1500
|
|
officecli set "$FILE" /Sheet1/A5 --prop text=Apr
|
|
officecli set "$FILE" /Sheet1/B5 --prop text=5600
|
|
officecli set "$FILE" /Sheet1/C5 --prop text=4200
|
|
officecli set "$FILE" /Sheet1/D5 --prop text=2800
|
|
officecli set "$FILE" /Sheet1/E5 --prop text=1700
|
|
officecli set "$FILE" /Sheet1/A6 --prop text=May
|
|
officecli set "$FILE" /Sheet1/B6 --prop text=6200
|
|
officecli set "$FILE" /Sheet1/C6 --prop text=4800
|
|
officecli set "$FILE" /Sheet1/D6 --prop text=3200
|
|
officecli set "$FILE" /Sheet1/E6 --prop text=1900
|
|
officecli set "$FILE" /Sheet1/A7 --prop text=Jun
|
|
officecli set "$FILE" /Sheet1/B7 --prop text=6800
|
|
officecli set "$FILE" /Sheet1/C7 --prop text=5200
|
|
officecli set "$FILE" /Sheet1/D7 --prop text=3600
|
|
officecli set "$FILE" /Sheet1/E7 --prop text=2100
|
|
officecli set "$FILE" /Sheet1/A8 --prop text=Jul
|
|
officecli set "$FILE" /Sheet1/B8 --prop text=7500
|
|
officecli set "$FILE" /Sheet1/C8 --prop text=5800
|
|
officecli set "$FILE" /Sheet1/D8 --prop text=4000
|
|
officecli set "$FILE" /Sheet1/E8 --prop text=2300
|
|
officecli set "$FILE" /Sheet1/A9 --prop text=Aug
|
|
officecli set "$FILE" /Sheet1/B9 --prop text=8100
|
|
officecli set "$FILE" /Sheet1/C9 --prop text=6300
|
|
officecli set "$FILE" /Sheet1/D9 --prop text=4300
|
|
officecli set "$FILE" /Sheet1/E9 --prop text=2500
|
|
officecli set "$FILE" /Sheet1/A10 --prop text=Sep
|
|
officecli set "$FILE" /Sheet1/B10 --prop text=7600
|
|
officecli set "$FILE" /Sheet1/C10 --prop text=5900
|
|
officecli set "$FILE" /Sheet1/D10 --prop text=3900
|
|
officecli set "$FILE" /Sheet1/E10 --prop text=2300
|
|
officecli set "$FILE" /Sheet1/A11 --prop text=Oct
|
|
officecli set "$FILE" /Sheet1/B11 --prop text=7200
|
|
officecli set "$FILE" /Sheet1/C11 --prop text=5500
|
|
officecli set "$FILE" /Sheet1/D11 --prop text=3500
|
|
officecli set "$FILE" /Sheet1/E11 --prop text=2100
|
|
officecli set "$FILE" /Sheet1/A12 --prop text=Nov
|
|
officecli set "$FILE" /Sheet1/B12 --prop text=6900
|
|
officecli set "$FILE" /Sheet1/C12 --prop text=5100
|
|
officecli set "$FILE" /Sheet1/D12 --prop text=3200
|
|
officecli set "$FILE" /Sheet1/E12 --prop text=1900
|
|
officecli set "$FILE" /Sheet1/A13 --prop text=Dec
|
|
officecli set "$FILE" /Sheet1/B13 --prop text=7800
|
|
officecli set "$FILE" /Sheet1/C13 --prop text=5700
|
|
officecli set "$FILE" /Sheet1/D13 --prop text=3800
|
|
officecli set "$FILE" /Sheet1/E13 --prop text=2200
|
|
|
|
# ==========================================================================
|
|
# Sheet: 1-Area Fundamentals
|
|
# ==========================================================================
|
|
officecli add "$FILE" / --type sheet --prop name="1-Area Fundamentals"
|
|
|
|
# Chart 1: Basic area chart with dataRange, axis titles, and custom colors
|
|
# Features: chartType=area, dataRange, colors, catTitle, axisTitle, gridlines
|
|
officecli add "$FILE" "/1-Area Fundamentals" --type chart \
|
|
--prop chartType=area \
|
|
--prop title="Website Traffic Overview" \
|
|
--prop dataRange=Sheet1!A1:E13 \
|
|
--prop colors=4472C4,ED7D31,70AD47,FFC000 \
|
|
--prop x=0 --prop y=0 --prop width=12 --prop height=18 \
|
|
--prop catTitle=Month --prop axisTitle=Visitors \
|
|
--prop gridlines=D9D9D9:0.5:dot
|
|
|
|
# Chart 2: Inline series with transparency
|
|
# Features: inline series, transparency (0-100), legend=bottom
|
|
officecli add "$FILE" "/1-Area Fundamentals" --type chart \
|
|
--prop chartType=area \
|
|
--prop title="Quarterly Revenue Streams" \
|
|
--prop series1="Subscriptions:120,180,210,250" \
|
|
--prop series2="One-time:90,140,160,200" \
|
|
--prop series3="Services:60,85,110,145" \
|
|
--prop categories=Q1,Q2,Q3,Q4 \
|
|
--prop colors=2E75B6,70AD47,FFC000 \
|
|
--prop x=13 --prop y=0 --prop width=12 --prop height=18 \
|
|
--prop transparency=40 \
|
|
--prop legend=bottom
|
|
|
|
# Chart 3: Area with areafill gradient
|
|
# Features: areafill (gradient from-to:angle), legend=none, single series
|
|
officecli add "$FILE" "/1-Area Fundamentals" --type chart \
|
|
--prop chartType=area \
|
|
--prop title="Monthly Active Users" \
|
|
--prop series1="Users:3200,3800,4500,5100,5800,6400" \
|
|
--prop categories=Jul,Aug,Sep,Oct,Nov,Dec \
|
|
--prop x=0 --prop y=19 --prop width=12 --prop height=18 \
|
|
--prop areafill=4472C4-BDD7EE:90 \
|
|
--prop legend=none
|
|
|
|
# Chart 4: Per-series gradient fills
|
|
# Features: gradients (per-series gradient fills from-to:angle;...),
|
|
# legendfont (size:color:font)
|
|
officecli add "$FILE" "/1-Area Fundamentals" --type chart \
|
|
--prop chartType=area \
|
|
--prop title="Revenue by Channel" \
|
|
--prop series1="Direct:45,52,61,70" \
|
|
--prop series2="Partner:30,38,42,55" \
|
|
--prop categories=Q1,Q2,Q3,Q4 \
|
|
--prop x=13 --prop y=19 --prop width=12 --prop height=18 \
|
|
--prop "gradients=4472C4-BDD7EE:90;ED7D31-FBE5D6:90" \
|
|
--prop legend=right --prop legendfont=10:333333:Calibri
|
|
|
|
# ==========================================================================
|
|
# Sheet: 2-Area Variants
|
|
# ==========================================================================
|
|
officecli add "$FILE" / --type sheet --prop name="2-Area Variants"
|
|
|
|
# Chart 1: Stacked area with plotFill and rounded corners
|
|
# Features: chartType=areaStacked, plotFill (solid), roundedCorners
|
|
officecli add "$FILE" "/2-Area Variants" --type chart \
|
|
--prop chartType=areaStacked \
|
|
--prop title="Cumulative Traffic Sources" \
|
|
--prop dataRange=Sheet1!A1:E13 \
|
|
--prop colors=4472C4,ED7D31,70AD47,FFC000 \
|
|
--prop x=0 --prop y=0 --prop width=12 --prop height=18 \
|
|
--prop plotFill=F5F5F5 \
|
|
--prop roundedCorners=true \
|
|
--prop legend=bottom
|
|
|
|
# Chart 2: 100% stacked area with axis number format and axis line
|
|
# Features: chartType=areaPercentStacked, axisNumFmt, axisLine
|
|
officecli add "$FILE" "/2-Area Variants" --type chart \
|
|
--prop chartType=areaPercentStacked \
|
|
--prop title="Traffic Share by Channel" \
|
|
--prop dataRange=Sheet1!A1:E13 \
|
|
--prop colors=2E75B6,C55A11,548235,BF8F00 \
|
|
--prop x=13 --prop y=0 --prop width=12 --prop height=18 \
|
|
--prop axisNumFmt=0% \
|
|
--prop axisLine=333333:1:solid \
|
|
--prop legend=bottom
|
|
|
|
# Chart 3: 3D area with perspective rotation
|
|
# Features: chartType=area3d, view3d (rotX,rotY,perspective)
|
|
officecli add "$FILE" "/2-Area Variants" --type chart \
|
|
--prop chartType=area3d \
|
|
--prop title="3D Regional Sales" \
|
|
--prop series1="East:120,135,148,162,155,178" \
|
|
--prop series2="West:95,108,115,128,142,155" \
|
|
--prop series3="Central:88,92,105,118,125,138" \
|
|
--prop categories=Jan,Feb,Mar,Apr,May,Jun \
|
|
--prop colors=4472C4,ED7D31,70AD47 \
|
|
--prop x=0 --prop y=19 --prop width=12 --prop height=18 \
|
|
--prop view3d=20,25,15 \
|
|
--prop legend=right
|
|
|
|
# Chart 4: 3D stacked area
|
|
# Features: area3d stacked appearance, multiple series, gridlines
|
|
officecli add "$FILE" "/2-Area Variants" --type chart \
|
|
--prop chartType=area3d \
|
|
--prop title="3D Stacked Inventory" \
|
|
--prop series1="Warehouse A:500,480,520,550,530,560" \
|
|
--prop series2="Warehouse B:320,350,340,380,400,410" \
|
|
--prop series3="Warehouse C:180,200,210,230,250,240" \
|
|
--prop categories=Jan,Feb,Mar,Apr,May,Jun \
|
|
--prop colors=1F4E79,2E75B6,9DC3E6 \
|
|
--prop x=13 --prop y=19 --prop width=12 --prop height=18 \
|
|
--prop view3d=15,20,20 \
|
|
--prop gridlines=D9D9D9:0.5:dot
|
|
|
|
# ==========================================================================
|
|
# Sheet: 3-Area Styling
|
|
# ==========================================================================
|
|
officecli add "$FILE" / --type sheet --prop name="3-Area Styling"
|
|
|
|
# Chart 1: Title styling (font, size, color, bold, shadow)
|
|
# Features: title.font, title.size, title.color, title.bold, title.shadow
|
|
officecli add "$FILE" "/3-Area Styling" --type chart \
|
|
--prop chartType=area \
|
|
--prop title="Styled Title Demo" \
|
|
--prop series1="Revenue:80,120,160,200,240,280" \
|
|
--prop categories=Jan,Feb,Mar,Apr,May,Jun \
|
|
--prop colors=4472C4 \
|
|
--prop x=0 --prop y=0 --prop width=12 --prop height=18 \
|
|
--prop title.font=Georgia --prop title.size=16 \
|
|
--prop title.color=1F4E79 --prop title.bold=true \
|
|
--prop title.shadow=000000-3-315-2-30 \
|
|
--prop transparency=30
|
|
|
|
# Chart 2: Series shadow, outline, and smooth curve
|
|
# Features: smooth, series.shadow (color-blur-angle-dist-opacity),
|
|
# series.outline (color-width)
|
|
officecli add "$FILE" "/3-Area Styling" --type chart \
|
|
--prop chartType=area \
|
|
--prop title="Smooth Area with Effects" \
|
|
--prop series1="Signups:150,180,220,260,310,350" \
|
|
--prop series2="Trials:90,110,140,170,200,230" \
|
|
--prop categories=Jan,Feb,Mar,Apr,May,Jun \
|
|
--prop colors=4472C4,70AD47 \
|
|
--prop x=13 --prop y=0 --prop width=12 --prop height=18 \
|
|
--prop smooth=true \
|
|
--prop series.shadow=000000-4-315-2-40 \
|
|
--prop series.outline=333333-1 \
|
|
--prop transparency=25
|
|
|
|
# Chart 3: Axis font styling, gridlines, and minor gridlines
|
|
# Features: axisfont (size:color:font), gridlines (color:width:dash),
|
|
# minorGridlines
|
|
officecli add "$FILE" "/3-Area Styling" --type chart \
|
|
--prop chartType=area \
|
|
--prop title="Gridline Configuration" \
|
|
--prop dataRange=Sheet1!A1:C13 \
|
|
--prop colors=2E75B6,C55A11 \
|
|
--prop x=0 --prop y=19 --prop width=12 --prop height=18 \
|
|
--prop axisfont=9:58626E:Arial \
|
|
--prop gridlines=D9D9D9:0.5:dot \
|
|
--prop minorGridlines=EEEEEE:0.3:dot \
|
|
--prop catTitle=Month --prop axisTitle=Visitors
|
|
|
|
# Chart 4: Chart fill, plot fill gradient, chart/plot area borders
|
|
# Features: chartFill, plotFill (gradient from-to:angle),
|
|
# chartArea.border, plotArea.border, roundedCorners
|
|
officecli add "$FILE" "/3-Area Styling" --type chart \
|
|
--prop chartType=area \
|
|
--prop title="Fills and Borders" \
|
|
--prop series1="Sales:200,240,280,320,360,400" \
|
|
--prop categories=Jan,Feb,Mar,Apr,May,Jun \
|
|
--prop colors=4472C4 \
|
|
--prop x=13 --prop y=19 --prop width=12 --prop height=18 \
|
|
--prop chartFill=FAFAFA \
|
|
--prop "plotFill=E8F0FE-D6E4F0:90" \
|
|
--prop chartArea.border=D0D0D0:1:solid \
|
|
--prop plotArea.border=E0E0E0:0.5:dot \
|
|
--prop roundedCorners=true
|
|
|
|
# ==========================================================================
|
|
# Sheet: 4-Labels & Legend
|
|
# ==========================================================================
|
|
officecli add "$FILE" / --type sheet --prop name="4-Labels & Legend"
|
|
|
|
# Chart 1: Data labels with position, font, and number format
|
|
# Features: dataLabels, labelPos (top), labelFont (size:color:bold),
|
|
# dataLabels.numFmt
|
|
officecli add "$FILE" "/4-Labels & Legend" --type chart \
|
|
--prop chartType=area \
|
|
--prop title="Labeled Area Chart" \
|
|
--prop series1="Users:3200,3800,4500,5100,5800,6400" \
|
|
--prop categories=Jul,Aug,Sep,Oct,Nov,Dec \
|
|
--prop colors=4472C4 \
|
|
--prop x=0 --prop y=0 --prop width=12 --prop height=18 \
|
|
--prop dataLabels=true --prop labelPos=top \
|
|
--prop labelFont=9:333333:true \
|
|
--prop dataLabels.numFmt=#,##0
|
|
|
|
# Chart 2: Individual label deletion and per-point colors
|
|
# Features: dataLabel{N}.delete, point{N}.color
|
|
officecli add "$FILE" "/4-Labels & Legend" --type chart \
|
|
--prop chartType=area \
|
|
--prop title="Highlighted Peak Month" \
|
|
--prop series1="Revenue:180,210,250,310,280,260" \
|
|
--prop categories=Jul,Aug,Sep,Oct,Nov,Dec \
|
|
--prop colors=2E75B6 \
|
|
--prop x=13 --prop y=0 --prop width=12 --prop height=18 \
|
|
--prop dataLabels=true \
|
|
--prop dataLabel1.delete=true --prop dataLabel2.delete=true \
|
|
--prop dataLabel5.delete=true --prop dataLabel6.delete=true \
|
|
--prop point4.color=C00000 \
|
|
--prop transparency=30
|
|
|
|
# Chart 3: Legend positioning with overlay and font styling
|
|
# Features: legend=right, legendfont, legend.overlay
|
|
officecli add "$FILE" "/4-Labels & Legend" --type chart \
|
|
--prop chartType=area \
|
|
--prop title="Legend Overlay Demo" \
|
|
--prop series1="Desktop:4200,4800,5100,5600" \
|
|
--prop series2="Mobile:3100,3500,3800,4200" \
|
|
--prop series3="Tablet:1200,1400,1500,1700" \
|
|
--prop categories=Q1,Q2,Q3,Q4 \
|
|
--prop colors=4472C4,ED7D31,70AD47 \
|
|
--prop x=0 --prop y=19 --prop width=12 --prop height=18 \
|
|
--prop legend=right --prop legendfont=10:1F4E79:Calibri \
|
|
--prop legend.overlay=true \
|
|
--prop transparency=35
|
|
|
|
# Chart 4: Manual layout — plotArea positioning
|
|
# Features: plotArea.x/y/w/h, title.x/y, legend.x/y/w/h (manual layout)
|
|
officecli add "$FILE" "/4-Labels & Legend" --type chart \
|
|
--prop chartType=area \
|
|
--prop title="Manual Layout" \
|
|
--prop series1="Growth:100,130,170,220,280,350" \
|
|
--prop categories=Jan,Feb,Mar,Apr,May,Jun \
|
|
--prop colors=70AD47 \
|
|
--prop x=13 --prop y=19 --prop width=12 --prop height=18 \
|
|
--prop plotArea.x=0.12 --prop plotArea.y=0.18 \
|
|
--prop plotArea.w=0.82 --prop plotArea.h=0.55 \
|
|
--prop title.x=0.25 --prop title.y=0.02 \
|
|
--prop legend.x=0.15 --prop legend.y=0.82 \
|
|
--prop legend.w=0.7 --prop legend.h=0.12
|
|
|
|
# ==========================================================================
|
|
# Sheet: 5-Advanced
|
|
# ==========================================================================
|
|
officecli add "$FILE" / --type sheet --prop name="5-Advanced"
|
|
|
|
# Chart 1: Secondary axis (dual scale)
|
|
# Features: secondaryAxis (1-based series index on secondary Y axis)
|
|
officecli add "$FILE" "/5-Advanced" --type chart \
|
|
--prop chartType=area \
|
|
--prop title="Revenue vs Conversion Rate" \
|
|
--prop series1="Revenue:120,180,250,310,280,340" \
|
|
--prop series2="Conv %:2.1,2.8,3.2,3.9,3.5,4.1" \
|
|
--prop categories=Jan,Feb,Mar,Apr,May,Jun \
|
|
--prop colors=4472C4,C00000 \
|
|
--prop x=0 --prop y=0 --prop width=12 --prop height=18 \
|
|
--prop secondaryAxis=2 \
|
|
--prop transparency=30
|
|
|
|
# Chart 2: Reference line
|
|
# Features: referenceLine (value:color:width:dash)
|
|
officecli add "$FILE" "/5-Advanced" --type chart \
|
|
--prop chartType=area \
|
|
--prop title="Sales vs Target" \
|
|
--prop series1="Sales:85,92,108,115,98,120" \
|
|
--prop categories=Jan,Feb,Mar,Apr,May,Jun \
|
|
--prop colors=4472C4 \
|
|
--prop x=13 --prop y=0 --prop width=12 --prop height=18 \
|
|
--prop referenceLine=100:FF0000:1.5:dash \
|
|
--prop transparency=25 \
|
|
--prop areafill=4472C4-BDD7EE:90
|
|
|
|
# Chart 3: Axis min/max, major unit, log scale, display units
|
|
# Features: axisMin, axisMax, majorUnit, dispUnits (thousands/millions)
|
|
officecli add "$FILE" "/5-Advanced" --type chart \
|
|
--prop chartType=area \
|
|
--prop title="Axis Scaling Demo" \
|
|
--prop series1="Visits:3200,3800,4500,5100,5800,6400" \
|
|
--prop categories=Jul,Aug,Sep,Oct,Nov,Dec \
|
|
--prop colors=2E75B6 \
|
|
--prop x=0 --prop y=19 --prop width=12 --prop height=18 \
|
|
--prop axisMin=3000 --prop axisMax=7000 \
|
|
--prop majorUnit=500 \
|
|
--prop dispUnits=thousands \
|
|
--prop "axisTitle=Visitors (K)" \
|
|
--prop transparency=30
|
|
|
|
# Chart 4: Color rule, title glow, series shadow
|
|
# Features: colorRule (threshold:belowColor:aboveColor), title.glow
|
|
# (color-radius-opacity), series.shadow
|
|
officecli add "$FILE" "/5-Advanced" --type chart \
|
|
--prop chartType=area \
|
|
--prop title="Performance Threshold" \
|
|
--prop series1="Score:45,62,38,71,55,80" \
|
|
--prop categories=Jan,Feb,Mar,Apr,May,Jun \
|
|
--prop x=13 --prop y=19 --prop width=12 --prop height=18 \
|
|
--prop colorRule=50:C00000:70AD47 \
|
|
--prop referenceLine=50:888888:1:solid \
|
|
--prop title.glow=4472C4-8-60 \
|
|
--prop series.shadow=000000-3-315-1-30 \
|
|
--prop transparency=20
|
|
|
|
officecli close "$FILE"
|
|
|
|
officecli validate "$FILE"
|
|
echo "Generated: $FILE"
|