1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| procedure TForm1.Button1Click(Sender: TObject);
Var MonClasseur : _workbook;
MaFeuille :_Worksheet;
Resultat : variant;
comptLig, ComptCol: integer;
begin
ExcelApplication1.Connect;
MonClasseur:=ExcelApplication1.Workbooks.Open('c:\temp\t.xls',False,False,
EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,
EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,0);
ExcelApplication1.Visible[0]:=true;
MaFeuille:=MonClasseur.Worksheets[1] as _worksheet;
Resultat:=MaFeuille.Range['A1','C20'].Value; // ligne 48
for comptLig:=1 to VarArrayHighBound(Resultat,1) do
for comptCol:=1 to VarArrayHighBound(Resultat,2) do
Resultat[comptlig,comptcol]:=Resultat[comptlig,comptcol]*3+2;
MaFeuille.Range['A1','C20'].Value:=Resultat; // ligne 52
end;
procedure TForm1.Button2Click(Sender: TObject);
begin
ExcelApplication1.Quit;
ExcelApplication1.Disconnect;
end; |
Partager