Repository navigation
excel picture set
goworm edited this page Jul 19, 2026
·
54 revisions
Modify an existing picture's properties.
Path: /{SheetName}/picture[N]
| Property | Accepted Values | Description |
|---|---|---|
x |
number | Update horizontal position |
y |
number | Update vertical position |
width |
number | Update width |
height |
number | Update height |
alt / altText / alttext / description
|
string | Update alt text. Aliases (v1.0.139+) — previously Set rejected altText/description even though Add accepted altText. |
rotation / rot
|
number | Rotation in degrees |
shadow |
"COLOR-BLUR-ANGLE-DIST-OPACITY", true, or none
|
Drop shadow effect (colons auto-converted for backward compatibility) |
glow |
"COLOR-BLUR" or none
|
Glow effect (colons auto-converted for backward compatibility) |
reflection |
tight/small, half/true, full, or percentage |
Reflection effect |
softedge |
number | Soft edge radius in pt |
srcRect |
l=10,r=10,t=5,b=5 |
Compound crop spec. Equivalent to crop.l/crop.r/crop.t/crop.b. |
crop |
10,15,5,20 |
(v1.0.133+) Bare 4-value composite crop (left,top,right,bottom percent — no l=/t= keys). This is the form dump emits on Get; confirmed live: set ... --prop crop=20,20,20,20 writes <a:srcRect l="20000" t="20000" r="20000" b="20000"/>. |
officecli set data.xlsx /Sheet1/picture[1] --prop width=500 --prop height=350
officecli set data.xlsx /Sheet1/picture[1] --prop x=3 --prop y=5
officecli set data.xlsx /Sheet1/picture[1] --prop alt="Updated logo"
officecli set data.xlsx /Sheet1/picture[1] --prop rotation=45
officecli set data.xlsx /Sheet1/picture[1] --prop shadow=true
officecli set data.xlsx /Sheet1/picture[1] --prop shadow="000000-5-45-3-80"
officecli set data.xlsx /Sheet1/picture[1] --prop glow="FF0000-10"
officecli set data.xlsx /Sheet1/picture[1] --prop shadow=none --prop glow=none
officecli set data.xlsx /Sheet1/picture[1] --prop reflection=half
officecli set data.xlsx /Sheet1/picture[1] --prop softedge=5Based on OfficeCLI v1.0.139
