row count in Excel (OLE automation)

From: "Sonnich Jensen" <sonnich@xxxxxxxxxxxx>
Date: Sun, 29 May 2005 23:54:49 +0300

Hi!

How do I get the row count here?
Does anyone know this?

Thanks
Sonnich

ExcelApplication := CreateOleObject('Excel.Application');
{ ExcelApplication.Visible := true; { debug only }
ExcelApplication.Workbooks.Open(OpenDialog2.FileName);
ExcelApplication.Workbooks[1].WorkSheets[1].Select;

//needed here:
ProgressBar1.Max :=
ExcelApplication.Workbooks[1].WorkSheets[1].Rowcount?

.

Follow-Ups:
- Re: row count in Excel (OLE automation)
  - From: Rob Kennedy

Prev by Date: Re: distance between lats and lons
Next by Date: Re: Trouble downloading pages
Previous by thread: Trouble downloading pages
Next by thread: Re: row count in Excel (OLE automation)
Index(es):
- Date
- Thread