Skip to content

excel picture set

zmworm edited this page Apr 29, 2026 · 51 revisions

Excel: Picture - set

Modify an existing picture's properties.

Path: /{SheetName}/picture[N]

Properties

Property Accepted Values Description
x number Update horizontal position
y number Update vertical position
width number Update width
height number Update height
alt string Update alt text
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

Examples

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=5

Based on OfficeCLI v1.0.64

Clone this wiki locally