Как вставить картинку |
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/