This happened because of excel sheet u import.... Try to delete blank rows from excel and then try
For example if u have values in 2 rows then click on row 3 control shift pagdwn and delete the rest row Try now u will not find any issue Sent from my iPhone On Jan 17, 2013, at 17:48, Sreenu Akkem <[email protected]> wrote: > 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]> 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]> >>> 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]> >>>> 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] >>>>> 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 >>>> "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 >>> "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 > "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 "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
