How to select imported rows from localdatatabel(runtime sheet)

[Uma]

Hi,

This is my code.

Code:

For x = 1 to DataTable.GetRowCount
print x
'I am adding a sheet in my local datatable.
DataTable.AddSheet("DinInfo")
'Importing values from excel sheet,
DataTable.ImportSheet "C:\LCMan.xls","MyLi-DFa","DinInfo"
'I parmeterized the column:
DResut=(DataTable("In_Din","DinInfo"))
print Dresult
Next

If i print Dresult, it always give first row value why?,
It is not giving the second row value.

My resuls
x=1
Dresult=Din1


X=2
Dresult=Din1[Here I need second row value Din2]

Any help?
Thanks
Uma

[Ankesh]

Hi Uma,

Ur code is fine, bt it needs slight modification.

U need to incremet the row to point to the next row. So u will have to use a row counter. Ur code shloud be something like this...

Code:

intRowNo=1  'Initialize a row counter
For x = 1 to DataTable.GetRowCount
print x
'I am adding a sheet in my local datatable.
DataTable.AddSheet("DinInfo")
'Importing values from excel sheet,
DataTable.ImportSheet "C:\LCMan.xls","MyLi-DFa","DinInfo"
Datatable.GetSheet("DinInfo").SetCurrentRow intRowNo  'Point the focus to the current row using the counter
'I parmeterized the column:
DResut=(DataTable("In_Din","DinInfo"))
intRowNo=intRowNo+1  'increment the counter
print Dresult
Next

I hope this would solve ur problem..

Regards,
Ankesh

[Uma]

Hi Ankesh,
It is working with setcurrentrow
Thank you
Uma