putting logo's into excel sheet

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

putting logo's into excel sheet

Postby leon.backbier@endemol.com » Sat Jan 15, 2011 9:59 am

Hi all,

is ther somebody who can help me with placing a logo into an excel sheet. I am ablo to load the picture and put it in a cel. However the placement is not exact enough. is there a way to place this logo on exact coordinates? it places it now by default in the left top corner of the cel
leon.backbier@endemol.com
 
Posts: 2
Joined: Fri Jan 14, 2011 5:42 pm

Re: putting logo's into excel sheet

Postby harry.support » Mon Jan 17, 2011 11:26 am

Thanks for your inquiry.
The properties LeftColumnOffset and TopRowOffset should be what you want.
Code: Select all
            Spire.Xls.ExcelPicture picture
                = worksheet.Pictures.Add(Image.FromFile(@"logo.gif"), "logo");
            picture.TopRow = 2;
            picture.LeftColumn = 3;
            picture.LeftColumnOffset = 10;
            picture.TopRowOffset = 20;

But it looks like there is a bug and these two properties do not work, we will fix this bug in the next release. After fixing it, we will send you a mail.
We are sorry for taht.
Harry
Technical Support / Developer,
e-iceblue Support Team
User avatar
harry.support
 
Posts: 180
Joined: Mon Nov 08, 2010 3:11 pm


Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 1 guest