Hi Ankit,
In QTP 11, GetRowCount is giving all rows from the datatable
I've used the following code -
DataTable.ImportSheet "C:\Users\Sreenivasulu\Desktop\QTP\Fundspire
Automation\Results.xls","SignIn","Global"
MsgBox DataTable.GetSheet("Global").GetRowCount
SignIn sheet in the excel is having only 2 rows.
Can you try this and review once
Thanks,
Sreenivas
On Thursday, 18 October 2012 15:51:27 UTC+5:30, Ankit Gupta wrote:
>
> Hi udhay,
>
> If u are using datatable then Getrowcount will give u the only rows having
> data.
>
> pls check again
>
> Regards,
> Ankit
>
>
> On Thu, Oct 18, 2012 at 3:15 PM, udhaya kumar
> <[email protected]<javascript:>
> > wrote:
>
>> Hi,
>>
>>
>> i cant use usedrange.rows.count. because i didnt automate excel.
>> i am just using qtp datatable sheet which doesnt have the property
>> "Usedrange.rows.count". Is there any property for datatable to get data
>> entered rows.
>>
>>
>> Thanks,
>> Udhay
>>
>>
>> On Thu, Oct 18, 2012 at 2:48 PM, Gautham Maroli
>> <[email protected]<javascript:>
>> > wrote:
>>
>>> Delete all the Rows from Row 4 to end row in the excel and try
>>>
>>> On Thu, Oct 18, 2012 at 11:23 AM, udhaya kumar
>>> <[email protected]<javascript:>
>>> > wrote:
>>>
>>>> Hi All,
>>>>
>>>> GetRowcount takes all the row from the excel sheet
>>>> and gives 330 row.But i actually entered value in only three rows.How to
>>>> get rid of this error.
>>>>
>>>>
>>>> Thanks,
>>>> Udhay
>>>>
>>>> --
>>>> 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]<javascript:>
>>>> To unsubscribe from this group, send email to
>>>> [email protected] <javascript:>
>>>> 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
>>> "QTP - HP Quick Test Professional - Automated Software Testing"
>>> group.
>>> To post to this group, send email to [email protected]<javascript:>
>>> To unsubscribe from this group, send email to
>>> [email protected] <javascript:>
>>> 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
>> "QTP - HP Quick Test Professional - Automated Software Testing"
>> group.
>> To post to this group, send email to [email protected]<javascript:>
>> To unsubscribe from this group, send email to
>> [email protected] <javascript:>
>> 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
"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
