Unable to apply a loop to extract multiple values from single pdf


I am new to UiPath and trying to make a workflow where i have a list of company names in a pdf file and i need to get their current rate from a website and save that data in a excel file.

I have made a workflow which does this however, only for the first value. The rest of the names in the file arent getting extracted and i am facing a challenge to apply a loop to this workflow.

Note: I am not using the PDF to excel activity as currently this isn’t available in the list of packages.

Kindly help with a suggestion or a solution for the above.

Thanks in advance!

Hi @Heena_Thakkar

Try to do string manipulations of extract pdf with string variables


1 Like

Extract the values by string manipulations and store them in datatable and then apply “for each row” activity and use excel, apply the datatable in excel worksheet.

1 Like

Thank you for the quick response @AshwinS2 and @VenkatDurbha !!

I will try the string manipulation method and confirm.:slightly_smiling_face:

1 Like

No problem :slight_smile: