Как вставить картинку

Previous  Top  Next

    
 

 

 

 

Answer:

 

If WS is your worksheet:

 

Code:

{ ... }

WS.Shapes.AddPicture('C:\Pictures\Small.Bmp', EmptyParam, EmptyParam, 10, 160,

EmptyParam, EmptyParam);

 

 

or

Code:

{ ... }

var

Pics: Excel2000.Pictures; {or whichever Excel}

Pic: Excel2000.Picture;

Pic: Excel2000.Shape;

Left, Top: integer;

{ ... }

Pics := (WS.Pictures(EmptyParam, 0) as Pictures);

Pic := Pics.Insert('C:\Pictures\Small.Bmp', EmptyParam);

Pic.Top := WS.Range['D4', 'D4'].Top;

Pic.Left := WS.Range['D4', 'D4'].Left;

{ ... }

 

 

 

EmptyParam a special variant (declared in Variants.pas in D6+). However in later versions of Delphi some conversions cause problems. This should work:

Code:

uses

OfficeXP;

 

{ ... }

WS.Shapes.AddPicture('H:\Pictures\Game\Hills.bmp', msoFalse, msoTrue, 10, 160, 100,

100);

 

 

 

But you may have to use a TBitmap to find out how large the picture should be.

©Drkb::04385

Взято с Delphi Knowledge Base: http://www.baltsoft.com/