How add image to Excel Report from Table

Finance and Operations/AX Developer Forum
1

hi, All

Help me, please.

I have Table where stored image, me need unload it to excel report/

I found how load to excel image from disc

variant.bStr(“c:\temp\image1.jpg”);

comShapes = activeSheet.shapes();
comShapes.addPicture(variant,false,true,xposLeft,yposTop,width,height);

but me need load from table.

table field extendedDataType = Bitmap.

2

According to documentation, there doesn’t seem to be any method that would accept binary data instead of a file path. Therefore save the image to a temporary file and use the approach you already know.

3

Thanks,
I found how to load the image from the table using the class Image()

Image Image = new Image();
;
Image.setData(Table.Image);
Image.resize(200,100,3); //not necessarily
Image.clipboardCopy();
range = activeSheet.Range(‘B1’);
range.pasteSpecial(0);