Counting rows of an Excel 97 worksheet

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Counting rows of an Excel 97 worksheet

Message

28/12/2000 23:09:38

Chrita Lee
ProMOS Technology Inc.
Hsinchu, Taiwan

23/12/2000 09:30:04

Charles Richard
Nvo Management Systems
Boisbriand, Québec, Canada

Information générale

Forum:

Visual FoxPro

Catégorie:

COM/DCOM et OLE Automation

Titre:

Re: Counting rows of an Excel 97 worksheet

Divers

Thread ID:

00456575

Message ID:

00457663

Vues:

>Can someone tell me if an Excel 97 object (CreateObject('Excel.Application')...) has a property to indicate the actual number of rows and columns containing data?
>
>Thanks
>Charles Richard

A more straightforward way:

? ActiveSheet.UsedRange.Rows.Count
? ActiveSheet.UsedRange.Columns.Count

Excel is REALLY GREAT!!!

Chris Lee

Répondre

Fil

Voir

Click here to load this message in the networking platform