我特意写了下面的demo,在我的D6/Excel2000中调试通过:
unit Unit1;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls;type
TForm1 = class(TForm)
Button1: TButton;
Button2: TButton;
procedure Button1Click(Sender: TObject);
procedure Button2Click(Sender: TObject);
private
{ Private declarations }
exApp,exWB,exSheet:Variant;
public
{ Public declarations }
end;var
Form1: TForm1;implementationuses ComObj;
{$R *.dfm}procedure TForm1.Button1Click(Sender: TObject);
begin
exApp:=CreateOleObject('Excel.Application');
exApp.visible:=true;
exApp.Caption:='Call Excel from Delphi';
exWB:=exApp.workbooks.add;
exSheet:=exWB.ActiveSheet;
exSheet.Pictures.Insert('E:\My Pictures\1.jpg');
end;procedure TForm1.Button2Click(Sender: TObject);
begin
exApp.Quit;
exWB:=Unassigned;
exSheet:=Unassigned;
exApp:=Unassigned;
end;end.
unit Unit1;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls;type
TForm1 = class(TForm)
Button1: TButton;
Button2: TButton;
procedure Button1Click(Sender: TObject);
procedure Button2Click(Sender: TObject);
private
{ Private declarations }
exApp,exWB,exSheet:Variant;
public
{ Public declarations }
end;var
Form1: TForm1;implementationuses ComObj;
{$R *.dfm}procedure TForm1.Button1Click(Sender: TObject);
begin
exApp:=CreateOleObject('Excel.Application');
exApp.visible:=true;
exApp.Caption:='Call Excel from Delphi';
exWB:=exApp.workbooks.add;
exSheet:=exWB.ActiveSheet;
exSheet.Pictures.Insert('E:\My Pictures\1.jpg');
end;procedure TForm1.Button2Click(Sender: TObject);
begin
exApp.Quit;
exWB:=Unassigned;
exSheet:=Unassigned;
exApp:=Unassigned;
end;end.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货