How to add data row without using for each itration in excel?

Help Activities
, ,
1

see these : (1) | write the number and corresponding colum valid in valid (loom.com)

image
image987Ă—569 17.3 KB

image
image746Ă—486 20.2 KB

which expression I can write

how I can write the data into excel
for example

9665410000000 valid

9665410000432 invalid

I made the whole process but I am unable to write into range how to work with that

Main.xaml (34.6 KB)

Thanks, Regards
Deepak

2

@Deepak_Gautam

Check below link for your reference

Reference

Hope this may help you

Thanks

1 Like
3

Bro I am not using for each loop
I directly made data table variable and I iterate it and add data have you seen my
main.xml or loom video ?

Thanks, Regards
Deepak

4

@Deepak_Gautam

If you are passing the variable in ArrayRow then you have to pass as below

{Variable1, Variable2, Variable3…}

Also check the scope of the variables also

Also if you are passing any value then use as below

{“Value1”,“Value2”,“Value3”…}

Hope this may help you

Thanks

1 Like
5

how will iterate the row on next time

6

@Deepak_Gautam

For Iteration you need to use For Each activity or while activity

What is your input? From where you are getting the number to validate?

If it is excel / some other source then you can use For Each row loop and you can write to the datatable

Hope this may help you

Thanks

8

no input from variable double
and i want to put the double varibale into row and valid status

into data table variable

and get output through write range