Hello,guys
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
you can use foreach activity to iterate in the loop and get the data. @Pradeep_Shiv
cheers
Happy learning
Tried its not working!
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.