How to do looping for consecutive rows?

Hi...

My application contains a row which is having several fields like(cost level,GL cost,percent of cost,plus amount...).I am importing the data from excel sheet for the above mentioned field and fetching in the respective field.

Instead of fetching the data in one row in application,i want to put the same data in consecutive rows also.

My excel sheet having consective no..of datas even.

Main thing is i dont want to touch the hardcore data.bcos tomorrow the no..of rows may change in application.

I know this is possible by using looping.but how to do looping.

1. At runtime get the Count of the Rows that ur Applicatio have.

2. Set the counter Limit to ur Applications Row Count.


intCntr = Browser(b).Page(p).WebTable(W).GetROProperty("row count")

''I am not sur ewhat ur control is like please check for the RO Property.

For intC = 0 to intCntr-1

''Code for setting the data in ur rows.

Next

Please revert with detail specs if it doesn't solve the purpose.


regards,
Nawab