Code won't stop looping through imported spreadsheet

[sreekanth chilam]

Hi Mike,

Here there are two ways has to be noticed by all of us.

1 st way :
In file-Settings-->Run tab, by default "Run on All rows" will be there.
That means, if there are 'n' number of rows are stored in datatable's Global Sheet then entire script will be running "n' number of times.

2 nd way :
If at all we wont have any data in datatable's Global sheet & we are importing the data from an external spreadsheet.

Then initially we should select "Run one iteration only" option in file-Settings-->Run tab.,

datatable.import "../../../.xls" ' ---> import the data into current global sheet

rc= datatable.getrowcount ' ----> retrieve the rowcount of global sheet (this much number of times we are running the test script by using the loop)

for i=1 to rc ' ----> start of loop
datatable.setcurrentrow(i)
...............
..............
next ' ----> end of loop

we should either follow 1st or 2nd way but not mixing the both ways ......

@ Mike : I hope your query has been solved .......