Logo in the report to Excel

Chandan_kansal

Hello Everybody
I m new to Navision.I have a report in which logo of the company is there.When I m Exporting the report to the Excel using Excel Buffer table,then logo is not exported.
Can anyone give me some idea....

Thanx.

rvduuren

Hello
Exporting images to M$ Excel is not that hard (to imagine ;-)), here's an out of the box working example: Click here

Chandan_kansal

rvduuren wrote:

Hello
Exporting images to M$ Excel is not that hard (to imagine ;-)), here's an out of the box working example: Click here

Thanx.
But it is picking ur bmp file from the hard disk.But I want to export that bmp which is in the report watever it is.Is there any other way......

Phenno

Chandan_kansal wrote:

rvduuren wrote:

Hello
Exporting images to M$ Excel is not that hard (to imagine ;-)), here's an out of the box working example: Click here

Thanx.
But it is picking ur bmp file from the hard disk.But I want to export that bmp which is in the report watever it is.Is there any other way......

You can try to export it to temp folder (with C/AL) and then import it into excel.

Chandan_kansal

But how we can do it?

HalMdy

See in Form 346 to have an example of exporting a picture (Button Picture, fct Export).

liizz

Hello all,

HalMdy wrote:

See in Form 346 to have an example of exporting a picture (Button Picture, fct Export).

Should I make use of this form, to export the logo in the temp folder? Can somebody please clarify my doubts.

Also, how to define the path of the picture if it's on network.

I have used this example mentioned on the link:
XlWrkSht.Shapes.AddShape(1,1,1,200,100).Fill.UserPicture('c:\picture.bmp');

Thanks
Liizz