I have used advanced loop to read two excel files which contain numerical values. I have specified the argument type as numeric inside the advanced loop.
Now I want to check a condition and then add this value to a datatable I created. But to add row in the datatable, I have to assign first to a variable right? How do I assign a numeric value from the datatable to a variable? It shows unable to assign from system.object to int.
For example, if I want to assign a string I use “variable=outres.item(0).tostring()”
Similarly I want to assign a numeric value in the datatable to a variable. How do I do this?
I want to add two columns from the advanced loop sheet and ‘add row’ to a created datatable.
Thanks for the help