Import file *.jpg or *.bmp
3 posts
• Page 1 of 1
Import file *.jpg or *.bmp
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
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
- Tranber44
- Posts: 36
- Joined: Mon Jan 11, 2010 4:46 pm
Re: Import file *.jpg or *.bmp
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:
Regards,
Vince
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
- Vince|Dyalog
- Posts: 444
- Joined: Wed Oct 01, 2008 9:39 am
Re: Import file *.jpg or *.bmp
Hi Vince,
Thank you for that information. Dan’s solution works perfectly and addresses all my problems.
Regards
Bertrand
Thank you for that information. Dan’s solution works perfectly and addresses all my problems.
Regards
Bertrand
- Tranber44
- Posts: 36
- Joined: Mon Jan 11, 2010 4:46 pm
3 posts
• Page 1 of 1
Return to Windows: GUI, COM/OLE/ActiveX
Who is online
Users browsing this forum: No registered users and 1 guest
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group