Input xl file problem

[eroshan]

Hi all

I am using xl sheet for give input parameters. first time i gave two rows(test run twice)
then l delete last row , save and run againg , so normally test should run only one time, but test try to run twice and stuck at the middle (because no inputs)
what is the reason for that ?

Thanks

[Saket]

You must have cleared the row instead of deleting. try deleting the entire row, it will work as expected.
if you just clear the row then QTP treats it as a used row in the datatable, and go for the iteration.

[eroshan]

Thanks Saket it works

Now , My xl sheet have 2 rows but QTP runs only one iteration. (xl sheet is generated by another program) what can be the issue ?

[Saket]

The rows you are referring here is in the Global sheet or local sheet?
Check what you have set for the data table iterations at settings > Run,
make it run on all rows.

[eroshan]

Hi Saket
i checked the setting > Run , it already set to all rows. My xl sheet is genarated by a java program so it named the sheet as 'Sheet0' , because of that no Global sheet or local sheet there. Can it be a issue? (but it works for one iteration)

[Saket]

In that case you will have to get the row count of your sheet and will have to put into a loop.
Yes, If you dont have a global datasheet then QTP will not able to apply datatable iteration, as this is done using rows in global data sheet.

[eroshan]

Hi Saket , I renamed the sheet to 'Global' from my program, now it works
Thanks a lot.