How can I export Image to excel??

AndyPeng
AndyPeng Member Posts: 10
edited 2004-05-22 in Dynamics AX
HI,All
Does anyone know how to export a image(stored in a folder or my database) to excel?
Thank you in advance.

Andy
Andy.Peng
Best Regard!

Comments

  • kailou
    kailou Member Posts: 14
    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
    AndyPeng Member Posts: 10
    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.
    Andy.Peng
    Best Regard!

Categories