raghuramgupta

 Profile Answers by raghuramgupta Questions by raghuramgupta

• Sep 6th, 2007

 

Here you are not changing the row number that's why each and every time its fetching data from first row which the default row

I hope the following code would help? you
I am using the For Loop to get data from the data table. The summary code is:
C=datatable.getrowcount
For i=1 to c
datatable.setcurrentrow(i)
msgbox Datatable.Value("Column1")
Next

Raghuram Gupta
9866379523

ankitjain082@gmail.com

• Aug 29th, 2011

 

Use this

RowCount=DataTable.GetSheet("Global").GetRowCount
For i =1 to RowCount

Data

DataTable.GetSheet("Global").SetNextRow
Next
Window("Flight Reservation").Close

Divya

• Sep 9th, 2011

 

Hi I hope this will useful to u

Code
span style="color: #ff0000;">"column1")


next

dhanunjay

• Aug 29th, 2012

 

iRows=DataTable.getrowcount
For i=1 to iRows
DataTable.SetCurrentRow(i)
MsgBox DataTable("Test", dtGlobalSheet)
DataTable.SetNextRow
Next

RameshTulal

 Profile Answers by RameshTulal 

• Aug 14th, 2013

 

Hi All..

I have followed the discussion above but in my machine, the code is executing rcountno*rowcount times

I mean to say my rcount is "5" and yes my script is executing 5*5 time.(seems like script is a parent loop for my FOR loop)
Any body please tell me whts wrong i am doing

Thanks in Advance
Ramesh

NKANAP

 Profile Answers by NKANAP 

• Sep 17th, 2013

 

RC=datatable.GetRowCount
For i=1 to RC
datatable.SetCurrentRow(i)

( NO NEED TO WRITE DATATABLE.Setcurrentrow IN THE SCRIPT)

Next

helloqtp

• Jul 5th, 2014

 

I think the issue lies in the settings , where you have to check for one iteration only .. by default it remains checked as for all the rows ..

rohan

• May 22nd, 2015

 

rc = datatable.getsheet("sheetname").getRowCount
to increase the loop
for i = 1 to rc
datatable.SetCurrentRow(i)
obj1 = datatable.value("Columnname","sheetname")
next