How can I export Image to excel??

AndyPeng

HI,All
Does anyone know how to export a image(stored in a folder or my database) to excel?
Thank you in advance.

Andy

kailou

Hi Andy
This example export a bmp(c:\logo.bmp) to excel from c:\

XlApplication Automation //excel application
XlWorkSheet Automation //worksheet

//initiate xlapplication
//and create worksheet here

IF EXISTS('c:\logo.bmp') THEN // only export if image exist
XlWorkSheet.Shapes.AddPicture('c:\logo.bmp', 1, 1, 10, 2,//image XlApplication.InchesToPoints(1.16), // Image
XlApplication.InchesToPoints(0.76)); // Location on worksheet

Hope that help

AndyPeng

Hi kailou, thank you very much.
may be you tell me to export image in navasion, but in fact i am using Axapta, and want export image from axapta instead of navasion, could you give me some advice about this?

Thanks very much any way.

Andy.