1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| Var MonClasseur : _workbook;
MaFeuille :_Worksheet;
rMaPlage : ExcelRange;
Adresse : wideString;
begin
ExcelApplication1.Connect;
MonClasseur:=ExcelApplication1.Workbooks.Open('c:\tutoriel\tuto.xls',False,False,
EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,
EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,0);
ExcelApplication1.Visible[0]:=true;
MaFeuille:=MonClasseur.Worksheets[1] as _worksheet;
rMaPlage:=MaFeuille.Cells.Find('toto',EmptyParam,xlValues,xlPart,
xlByRows,xlNext,EmptyParam,EmptyParam);
if not (rMaPlage = nil) then
begin
Adresse:=rMaPlage.Address[true,true,xlR1C1,false,false];
showmessage(adresse);
repeat
rMaPlage:=MaFeuille.Cells.FindNext(rMaPlage);
showmessage(adresse);
Until (rMaPlage = nil) or (Adresse=rMaPlage.Address[true,true,xlR1C1,false,false])
end;
end; |
Partager