procedure TForm1.Button1Click(Sender: TObject);
var
aWorkBook : _Workbook;
aSheet : Variant;
begin
if OpenPictureDialog1.Execute then
begin
ExcelApplication1.Connect;
aWorkBook := ExcelApplication1.Workbooks.Add(EmptyParam, 0);
aSheet := aWorkBook.Sheets[1];
aSheet.Range['f1'].Select;//这里是定位图片插入的位置
asheet.Pictures.Insert(OpenPictureDialog1.FileName);
ExcelApplication1.Visible[0] := True;
ExcelApplication1.Disconnect;
end;
end;