11-22-2017, 02:34 PM
(11-17-2017, 05:04 AM)Studymode Wrote: Hi all,
This is my very first question on this website, as I found this site to very helpful. My question is how can I iterate through different value from the data table.
For example this is what I have
FirstName lastName Age
John. Doe. 27
Jane. Doe. 37
Mary Jane. 36
So I want the datatble to write 27 for the first row 37 on the second and so on.
Can someone please help me write a loop for this so I can achieve the desired results. Thank you in advance
you have to use SetCurrentRow method in the Datatable and then enter the value in the desired column.
Code:
datatable.setcurrentrow (1) 'Change the row number as per your requirement
datatable.Value ("ColumnName","Value") 'Eg: DataTable.Value("Age","27")
Hope this is what you are looking for.
Thanks,
SUpputuri
SUpputuri