Hi,
You just made my day supper, I'm daniel
On Thursday, August 20, 2009 at 2:56:01 PM UTC+2, rentala wrote:
>
> 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]
> <javascript:>> 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
---
You received this message because you are subscribed to the Google Groups "QTP
- HP Quick Test Professional - Automated Software Testing" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
