Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Counting rows of an Excel 97 worksheet
Message
From
29/12/2000 09:20:26
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
28/12/2000 23:09:38
Chrita Lee
ProMOS Technology Inc.
Hsinchu, Taiwan
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00456575
Message ID:
00457725
Views:
35
>>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

Hey Chris,
Really neat and short :) Thanks for sharing.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform