Micro Focus QTP (UFT) Forums
Input xl file problem - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: Input xl file problem (/Thread-Input-xl-file-problem)



Input xl file problem - eroshan - 09-09-2009

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


RE: Input xl file problem - Saket - 09-09-2009

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.


RE: Input xl file problem - eroshan - 09-10-2009

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 ?


RE: Input xl file problem - Saket - 09-10-2009

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.


RE: Input xl file problem - eroshan - 09-10-2009

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)


RE: Input xl file problem - Saket - 09-10-2009

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.


RE: Input xl file problem - eroshan - 09-10-2009

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