1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| var
L : integer;
begin
ExcelApplication1.Connect;
ExcelApplication1.Visible[1] := true;
Opendlg.Execute();
ExcelWorkbook1.ConnectTo(ExcelApplication1.Workbooks.Open
(Opendlg.FileName,EmptyParam,EmptyParam,EmptyParam,EmptyParam,
EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,
EmptyParam,EmptyParam,EmptyParam,EmptyParam,0));
ExcelWorksheet1.ConnectTo(ExcelWorkbook1.Sheets[3] as _WorkSheet);
L := 11; // Début du tableau
while ExcelWorksheet1.Cells.Item[L,1].value.asstring <> ''
do L := L+1; // Trouver la fin du tableau
showmessage(inttostr(L)); |
Partager