How to get picture by embed images type?

xiaoyao · February 15, 2025, 11:21am

What is read is just a text formula=DISPIMG (* *), how to automatically delete the image object when clearing the content?
How to read the image object and save it as PNG or JPG?

D2:=DISPIMG(“ID_74EDB220BEA24FB6A112C69353D9E16B”,1) rId2
E2='=DISPIMG(“ID_40FEBD6A9E1C43FCA051741E6632D6F3”,1) rId1
D4==DISPIMG(“ID_56A20461B3994F828D5574D4EFDD3FF9”,1) rId1

rId3 Target="NULL
rId2 Target=“media/image3.png”
Id=“rId1” Target=“media/image1.png”/>

<xdr:cNvPr id=“3” name=“ID_40FEBD6A9E1C43FCA051741E6632D6F3”/>xdr:cNvPicPr<a:picLocks noChangeAspect=“1”/></xdr:cNvPicPr></xdr:nvPicPr>xdr:blipFill<a:blip r:embed=“rId1”/>

dmytro · February 19, 2025, 1:31pm

Hi Xiayao,

you can delete only a reference to the picture in the sheet with Sheet::removePictureByIndex().

For reading pictures please use Sheet::getPicture() and Sheet::pictureSize() methods.

Please note that the Sheet::getPicture() returns a global picture ID, so you need also pass it to the Book::getPicture() for getting a picture format and a pointer to the memory buffer with that image.