How to get Strings from List of list of strings and add it to excel

Hello,guys

2 Likes

Hi @Pradeep_Shiv

Can you add more details to easily address the issue. Thanks :smiley:

cheers :smiley:

Happy learning :smiley:

2 Likes

i’m Extracting data from pdf row wise and adding it as list of string and using “add to collection” activity to add this list of strings to collections
then i’ve to use this list of list of strings and loop through each strings and add it to excel

2 Likes

you can use foreach activity to iterate in the loop and get the data. @Pradeep_Shiv

cheers :smiley:

Happy learning :smiley:

1 Like

Tried its not working!

1 Like

Did you get an error ? @Pradeep_Shiv

cheers :smiley:

Happy learning :smiley:

1 Like

Hi @Pradeep_Shiv

If you’re using some loop for extracting data row wise, I’ll suggest you to use Add data row instead of ‘add to collection’, this will adds string to a specified DataTable. firstly you have to use build data table activity to create one empty datatable having that one column.
After that using write range it’ll be easy for you to add data in excel at once. :slightly_smiling_face:

1 Like