Ans:
intRows=dataTable.GetSheet(1).GetRowCount
intCols=DataTable.GetSheet(1).GetParameterCount
For i= 1 to intRows
DataTable.SetCurrentRow i
For j=1 to intCols
If Datatable.Value(j,1)<>"" then
msgbox Datatable.Value(j,1)
end if
Next
Next
Follow @TestingQ
intRows=dataTable.GetSheet(1).GetRowCount
intCols=DataTable.GetSheet(1).GetParameterCount
For i= 1 to intRows
DataTable.SetCurrentRow i
For j=1 to intCols
If Datatable.Value(j,1)<>"" then
msgbox Datatable.Value(j,1)
end if
Next
Next