Excel row wise need to assing to the users

Help Activities
, ,
1

Hi Community,

I have an excel datasheet that has certain details those details need to assign to the respective teams row-wise. can you suggest how to develop the code.

image
image870×229 4 KB

2

Hello @chaitanyaKumar,

First, use Read Range and assign a dt variable: my_dt

After that use the activity: for each row

Inside the for each use assign activity for each column you want to get

For example the first one: myvar = row(“1”).ToString

After the assigns do the next steps inside the for each row. After all steps are done, the next row is preformed!

3

Hi @chaitanyaKumar ,

We would appreciate it if you could provide an example of the operation you wish to perform, along with some sample data, as that would put us in a much better position to assist you.

Kind Regards,
Ashwin A.K

4

it worked now thanks for your quick responce.

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.