Hey,

I'm new to using QTP. I'm working on testing SAP transactions.My question is in regards to DataTables.

I'm importing an xls into the Global Sheet and I want the test to loop through each row of data. The problem is that when the test runs the last row of data imported to the global sheet, it goes back up to the first row (or iteration) and cycles through the data again....This repeats forever. My script looks like this:

DataTable.Import("C:\Documents and Settings\XXXXXXX\Data\My Documents\MaterialNumber.xls")

Do Until DataTable("MaterialNumber") = ""
.....
.......
.........SetCellData 1,"Material", DataTable("MaterialNumber", dtGlobalSheet)
............
..............
.................
....................
DataTable.SetNextRow
Loop

The "MaterialNumber" is not labeled, or parameterized in the global sheet, it doesn't exist until the xls is imported. Everything works fine except that the loop never ends. Perhaps my loop logic is the wrong way to go. I just want to be able to upload a list of data, have the test run through each row, then stop when it has tested all the rows.

Any help is greatly appreciated. Thanks in advance!!!!

Regards,

Shawn

Hai friend,

select File->Settings-> Run->Run one iteration only

Click on Apply

Click on Ok

Then run the test and let me know

Thanks
Deepa

I think it just doesn't ever recognize the "" as a blank row, because it only pulls in the rows that have data in the xls and none of those are blank. I'm going to try to add an "end" as the last row in my xls sheet. Then run the loop until the value = "end"

I think what you suggested will have helped though, because it doesn't re-import the xls every time now.

That did it. Thank you very much! Before I changed the "run one iteration" setting I guess it would go back the beginning of the test and re-import the data from the excel sheet and start the process over....

Do you know if there is way to get it to end the loop without having to input "end" at the end of the xls data and test for that? I'm not sure we'll want to have to add "end" at the bottom of every column of data that we test.

Thanks again!

hai friend,

Adding end at the end of the column is not at all an apt approach

Use the below code what I have suggested

It will return the number of rows present in the datatable. Your run settings should be select File->Settings-> Run->Run one iteration only. It the datatable row is empty the loop will be automatically get terminated.

Datatable.ImportSheet "C:\Documents and Settings\Deepa\Desktop\ABC.xls"

For i=1 to Datatable.GetRowCount
'Msgbox Datatable.GetRowCount ' Returns number of rows present in the datatable

'your steps here

Datatable.SetNextRow
Next

By using the above code without using "end" your loop will automatically end.

Thanks
Deepa

Thanks so much deepasree!!!! It works great now.