Hi,
Here is the code for your refernce
set obj=CreateObject("Excel.Application")
obj.workbooks.open("file path")
Set obj1=obj.Sheets("Sheet1")
set obj2=obj1.UsedRange
n1=obj2.Rows.Count
n2=obj2.columns.count
MsgBox n1
MsgBox n2
On Wed, Aug 19, 2009 at 4:11 AM, Pinaki Mishra
<[email protected]>wrote:
> Hi, Can can any one help me to count number of row and column that
> contains data only in excel?
>
> Cheers,
> Pinaki
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
"QTP - HP Quick Test Professional - Automated Software Testing"
group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/MercuryQTP?hl=en
-~----------~----~----~----~------~----~------~--~---
