procedure TForm1.InsertPicClick(Sender: TObject);
var
aSheet: variant;
MyFormat : Word;
AData : THandle;
APalette:HPALETTE;
begin
aSheet := ExcelApplication1.Worksheets.Item[1];
//以文件插入
aSheet.Pictures.Insert('6.bmp');
//将Image1的图像插入
Image1.picture.SaveToClipboardFormat(MyFormat,AData,APalette);
ClipBoard.SetAsHandle(MyFormat,AData);
aSheet.Paste;
end;