Import file *.jpg or *.bmp

[Tranber44]

Hello,

I would like to integrate images in *.bmp or *.jpg format, by an APL program, in an Excel sheet, from external files.
The codification
ActiveSheet.Pictures.Insert('D:Ges/FicBas/Sign.bmp')
returns VALUE ERROR. I use ⎕WX 1.Is there a solution?

Regards

Bertrand Delassus

[Vince|Dyalog]

Hi Bertrand,

I think the Pictures.Insert method does not exist in OLE and will only work with .NET. Are you using .NET? If so, can you post the code that you have to create ActiveSheet please?

For OLE, Dan had written an answer for this previously (https://forums.dyalog.com/viewtopic.php?f=30&t=1095#p4415), and it is this:

      xl.ActiveSheet.Shapes.AddPicture 'C:\Program Files\Dyalog\Dyalog APL-64 17.0 Unicode\ws\bubbles.bmp' 0 1 0 0 100 100

Regards,

Vince

[Tranber44]

Hi Vince,

Thank you for that information. Dan’s solution works perfectly and addresses all my problems.

Regards

Bertrand