How to select imported rows from localdatatabel(runtime sheet)

[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