1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
|
unit Unit1;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, ComObj,
Dialogs, OleCtnrs, ExtCtrls;
type
TForm1 = class(TForm)
OleContainer1: TOleContainer;
procedure FormCreate(Sender: TObject);
procedure FormClose(Sender: TObject; var Action: TCloseAction);
private
{ Déclarations privées }
public
{ Déclarations publiques }
end;
var
Form1: TForm1;
oExcel: OleVariant;
implementation
{$R *.dfm}
procedure TForm1.FormCreate(Sender: TObject);
begin
with OleContainer1 do begin
Align:=alClient;
CreateObject('Excel.Sheet', False);
Doverb(ovPrimary);
end;
oExcel:=OleContainer1.OleObject.Application;
end;
procedure TForm1.FormClose(Sender: TObject; var Action: TCloseAction);
begin
if (OleContainer1.State=osUIActive) then begin
oExcel.Quit;
end;
Action:=caFree;
end;
end. |
