How to add collections of collections to data table

Help
, ,
1

Hey,Guys

ive Created list of list of type “New List(Of List(Of String))()”
and i’ve to add this values to excel based on individual strings for example “Invoice Number” in “A1” and “INV-12345” to B2

and so on

2

Hi @Pradeep_Shiv,

1.Use for each activity and keep the list and change the iterate variable data type to New List(Of List(Of String))().

2.Then use inside that add data row activity and mention the specific data table name in it.

Capture
Capture1071×516 19.1 KB

Cheers.
Vashisht.

3

Hi @Pradeep_Shiv

loop your list of list and then add row activity (add list as a array )

list(of string) will be your for each item type and use list(ofstring).toarry to convert the collection to array while adding it into data table

image
image844×249 9.13 KB

Regards
Ajay

4

it’s repeating three times the same string!!
why is that

1 Like
5

Can you share the workflow so that i can suggest you…

Cheers.
Vashisht.

2 Likes