How to save each value in a column of a table individually on separate variables for later usage in the automation


Hi @Malebo_Legologela,

You can use following method syntax to get value for each location from the datatable.

value = DT.Rows(Rowindex)(ColumnIndex).ToString

e.g. DT.Rows(3)(3).ToString —> will hold value of cell D4

Thanks You, but I had already figured that out i meant the general case

This works for the hard-coded version, Can you demonstrate to me how in a loop. I want to temporarily store and use details about Marita’s column on the first run of the loop then, John column detail on second of the loop and so on.