Automation: logo's in Excel

Luc_VanDyck

I use automation to create an item pricelist in Excel. Is it possible to have brand logo's in Excel?

eg:

BRAND LOGO 1
item 1
item 2
BRAND LOGO 2
item 1
item 2

The logo's can be imported in Navision, or put in a network directory. Question is, how to put those bitmaps in Excel, between the different items?

[ 25-02-2002: Message edited by: Luc Van Dyck ]

wonmo

I know of one way that you could do this.
Assuming that you have the picture in a BLOB field you have to export it to a location on your hard drive. Afterwards, after creating an instance of Excel through automation and assigning a variable to the Excel Automation server of class Sheet which is assigned as the ActiveSheet add this line of code:


xlSheet.Shapes.AddPicture(FilePathAndName, 1, 1, 20, 20, 100, 100);

After the path and filename, the 1 links the image to the file, the next 1 will set SaveWithDocument to TRUE, the next 2 integers are for position (in points) and the final 2 integers are for size (in points). For the logos, then, you would just use point locations to place them. Hope this helps.